G Suite: Gmail & Calendar iOS Updates

Gmail G Suite iOSWhile Google has its own mobile phone and tablet operating system, the company needs to remain mindful of the fact that millions of consumer and business Gmail customers are iPhone and iPad users.

In fact, over the last 30 days, 63% of the mobile & tablet visitors to this website, as reported by Google Analytics, are iPhone or iPad users.

For years, Google has offered iOS apps for Gmail, Calendar, Drive, Docs, Sheets, Slides and more. However, until recently, the Gmail app had not been updated since December 4, 2012.

[Read more…]

New Google Sites: How To Use Sites In Business

Updated: January 28, 2019

New Google SitesNew Google Sites rolled out to all G Suite customers in November of 2016.

The original Google Sites, now called “Classic Google Sites” was released in 2008 after the acquisition of JotSpot in 2006. The product did not see much in the way of enhancements for many years.

The new Google Sites was built from the ground up, which means not only a modern set of design components and full device responsiveness, but an app that fits in much better with the rest of the G Suite offerings.

[Read more…]

G Suite: Editing Microsoft Office Files

Edit Microsoft Office Files in Google AppsOne of the things that has prevented some organizations from making the switch to G Suite is the fact that they still would need to maintain and/or purchase Microsoft Office licenses for most of their users.

However, Office licenses may only be needed for a few power users within an organization, as there are two ways that any user can open and edit Microsoft Word, Excel or PowerPoint files using Google Drive. “Power users” can include those who work with very large Excel spreadsheets or who rely on macros within certain Excel spreadsheets. It can also include those who need to exchange redlined Word documents with third parties.

There are two ways that G Suite users can edit Office files without the need for Office software.

[Read more…]

Google Analytics Reports in Google Sheets – Using Filters

Google Analytics ReportsOne of many benefits to using G Suite is that G Suite users with access to their organization’s Google Analytics account can easily share specific slices of Google Analytics data with their co-workers.

The Google Analytics Add-on for Google Sheets lets a Sheets user who has a Google Analytics login create a variety of comparative visualizations within Google Sheets.

[Read more…]

Present Data in Google Slides – In Real Time

G Suite users can now present data in Google Slides. And, this data can be presented in real time.

Until Google introduced this functionality, charts had to either be pasted as images into Google Slides or they had to be created using shapes. When the underlying data changed, a more up-to-date chart image had to be pasted into the slide or the shapes had to be modified. This could be very time consuming.

Google has provided two ways to embed data-driven charts right within individual slides.

[Read more…]

14 Reasons to Move Your Business From Free Gmail to G Suite

Updated: July 11, 2020

Free Gmail vs. G SuiteLet’s say you’ve been using free Gmail accounts for your business communications. Your email addresses may resemble one or more of these:

abbottsolar@gmail.com
solar-lisa94@gmail.com
abbottsupport@gmail.com

Your employees may even be using assorted Yahoo Mail and cable company email addresses for business purposes.

However, your business is growing and you want to start to use more professional looking email addresses such as:

jabbott@abbottsolar.com
lisa@abbottsolar.com
support@abbottsolar.com

Steven Aldrich of GoDaddy has stated that potential customers are far more likely to do business with a company that uses a business email address than those that don’t.

[Read more…]

9 Reasons Companies Switch to G Suite

Switch to G SuiteGoogle is a household name for internet search. Most people are aware of consumer Gmail. However, many businesspeople are not aware of Google’s suite of applications for business, G Suite.

“Gone Google” is a term Google coined for companies that have adopted G Suite. At the time of publication of this post, Google states that over 5 million companies have gone Google. With over 125 million businesses in the world, there’s clearly some upside for Google.

[Read more…]

Publishing Pivot Table Charts to Your Website With Google Sheets

In the spring of 2013, we used SurveyMonkey Audience to collect data about what CRM systems were deployed at organizations across the U.S. The main question we asked in the survey was “What is your organization’s primary CRM system?”

After the survey finished its run, SurveyMonkey provided us with a CSV file of the survey results from approximately 750 respondents. The first thing we did was to upload the CSV file to Google Drive and then open the file with Google Sheets. Once we had the data in Google Sheets, we were able to easily create pivot tables and associated charts.

[Read more…]

Using Google Drawings to Create “Live” Marketing CTAs

A best practice for B2B marketers is to include a call to action (CTA) image at the bottom of every blog post.

When a visitor clicks on the CTA image, they can be directed to a landing page that provides a free offer.

A common process for creating a marketing call to action graphic is to:

  1. Create an image in an image editor (or PowerPoint)
  2. Save the image to a local drive
  3. Upload the image to WordPress or to a marketing automation system’s files area
  4. Incorporate the image into one or more blog posts

If, for any reason you want to modify the CTA image, you need to repeat the entire process.

[Read more…]

Moving to Gmail for Business: Migration Options

Moving to Gmail for BusinessIf you are thinking about moving from your current email provider to business Gmail for your organization, you’re probably wondering what would be involved with associating existing users’ email addresses, which are in a name@yourcompany.com type format, with a new G Suite account.

Also, what’s the best way to get your users’ often years worth of sent and received email into their Gmail accounts?

A move to business Gmail involves a number of technical tasks. However, this post is designed to provide a mainly non-technical overview of the tasks and options involved.

[Read more…]