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. Continue reading G Suite: Editing Microsoft Office Files

Google Analytics Event Tracking – 5 Examples

Google Analytics Event TrackingGoogle Analytics Event tracking allows you to incorporate visitor activity from many different sources within Google Analytics.

Once the information is in Google Analytics, as we covered in the previous post, comparative visualizations can be created in Google Sheets.

Here are five ways to use Google Analytics event tracking to measure the effectiveness of your marketing efforts. This is all predicated on the fact that you are using the Universal Analytics tracking code. Continue reading Google Analytics Event Tracking – 5 Examples

Google Analytics Reports in Google Sheets – Using Filters

Google Analytics ReportsOne of many benefits to using G Suite is that Google Apps 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. Continue reading Google Analytics Reports in Google Sheets – Using Filters

G Suite vs. Office 365: Which is Best for Your Business?

G Suite vs. Office 365G Suite and Microsoft Office 365 are the two major suites of business productivity applications currently on the market. The best known applications within these suites are for email, calendar, documents, spreadsheets, presentations and online storage.

Google and Microsoft continue to add their own flavors of additional components to their respective suites. For example, G Suite includes Forms, Drawings and My Maps. Microsoft Office 365 plans variously include Sway, Yammer and Skype. Continue reading G Suite vs. Office 365: Which is Best for Your Business?

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. Continue reading Present Data in Google Slides – In Real Time

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

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

You may even use assorted yahoo.com and aol.com email addresses.

However, your business is growing and/or 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. Continue reading 12 Reasons to Move Your Business From Free Gmail to G Suite

Google Apps: Ready for Enterprises?

Is Google Apps for Work ready for enterprises?

Whirlpool is the largest manufacturer of appliances in the world. It markets familiar brands such as Maytag, KitchenAid, Jenn-Air and Amana.

The company has been in business since 1911 and has revenue of about $21 billion. Whirlpool employees over 100,000 people globally. And, Whirlpool has gone Google. In fact, the company embarked on going Google about two years ago.

Continue reading Google Apps: Ready for Enterprises?

4 Ways to Add Animation to Your Website With Google Slides

Google Slides can easily be embedded in any website by using the code provided in the File > Publish to the web… menu.

By default, there’s a set of controls at the bottom of an embedded Slides presentation that diminishes the website animation effect. The controls provide multiple options including downloading the Slides as a PDF or PPTX file. Continue reading 4 Ways to Add Animation to Your Website With Google Slides

Going All In On Chromebooks for Business Use

All In Chromebook
For many consumers, especially those whose primary personal email account is Gmail, whether to switch to a Chromebook from a PC (or even from a Mac) should be an easy decision.

After my brothers-in-law and I had racked up dozens of hours helping my mother-in-law resolve chronic PC issues, I finally convinced everyone that she would be best off with a Chromebook. It turned out that 100% of her computer use involved cloud applications and online accounts, which made her fully Chromebook-eligible. After we got her to make the switch, intra-family tech support immediately dropped from hours per month to almost zero (we still had to help her with cloud printing). Continue reading Going All In On Chromebooks for Business Use

Create a Poll With Google Forms

With Google Forms, it’s easy to embed surveys, polls and other types of questionnaires into your website.

We created a poll in Google Forms and embedded it below. If you answer the question, you’ll be able to see how others answered the same question simply by clicking the See previous responses link after you submit your response. Continue reading Create a Poll With Google Forms

Google Apps and Salesforce Integration – Dreamforce 2015 Podcast

At Dreamforce 2015, I had the opportunity to interview Brandon Bruce, co-founder of CirrusPath, on the podcast stage in the Admin Lodge.

CirrusPath has done an excellent job of not only integrating Salesforce and Google Apps, but of also developing productivity tools for salespeople that can help to improve win rates. Continue reading Google Apps and Salesforce Integration – Dreamforce 2015 Podcast

9 Reasons Companies Switch to G Suite

Google 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. Continue reading 9 Reasons Companies Switch to G Suite

Google Apps for Work Under The Alphabet Structure

With Google’s recently announced restructuring, where does Google Apps for Work fit in?

Google Apps will live along side a set of related technologies, including Android (which has apps for Google Apps for Work), Search (used in Gmail, Google Drive and Google Sites), YouTube (Google Drive uses the YouTube engine) and Maps (Google My Maps is now part of Google Apps for Work). Continue reading Google Apps for Work Under The Alphabet Structure

Five Google Sites Use Cases

Google Sites is not necessarily the first application that enters the mind of most people as a platform for building out a corporate website, but there are a number of Google Sites use cases that organizations can take advantage of.

One of the great aspects of Google Sites is the fact that it has the built-in sharing options that are common to all Google Apps components. These granular permission levels make Google Sites easy to adapt to a variety of “non standard” use cases.

Here are five ways to use Google Sites other than as a corporate website platform. Continue reading Five Google Sites Use Cases

DIY B2B Marketing Landing Pages for Salesforce

DIY Salesforce Landing PagesYou’re a marketer whose company is subscribing Salesforce Professional Edition or Enterprise Edition.

You want to add on a marketing automation system such as Pardot or HubSpot to Salesforce, but you’re having trouble getting management to commit to a five figure minimum contract.

You’ve got some great blog content and you have a whitepaper or ebook already prepared. You simply want to set up something along the lines of the following flow (click image for full tab view) so that you can capture website leads and assign them to salespeople. You want to avoid involving IT, if at all possible. Continue reading DIY B2B Marketing Landing Pages for Salesforce