Tag Archives: google sheets

How To Move Data Between Google Sheets and Excel

Google Excel Spreadsheet InterchangeLet’s begin with a distinction between Google Sheets & Excel:

Excel is a spreadsheet application that is a part of Microsoft Office 365.

Google Sheets a spreadsheet app that is available with free consumer Gmail and also with G Suite (GMail for organizations).

Some people use only one or the other. Other people use both.

If a Google user who does not have Excel installed receives an Excel spreadsheet via email, the user can preview the spreadsheet within Gmail and then convert the spreadsheet to Google Sheets.

There are several ways to move spreadsheets and spreadsheet data between Google Sheets and Microsoft Excel. Here are examples of Google Excel information exchange. Continue reading How To Move Data Between Google Sheets and Excel

25 Ways To Accelerate Your Business With G Suite

Accelerate Business With G SuiteThere are many aspects to G Suite that can add energy to a business. Most of them are not available with standard web host email. Some are available with consumer Gmail.

Through continuous improvement, Google regularly adds new productivity features and functionality to G Suite.

Unless noted, all of the functionality below is included with G Suite at no extra cost. Google packs a lot of business value into G Suite beyond email, word processing, spreadsheets and presentations. Continue reading 25 Ways To Accelerate Your Business With G Suite

GOOGLEFINANCE Function: How To Compare Stock Performance

GOOGLEFINANCE Function ExamplesThe GOOGLEFINANCE function is part of Google Sheets. Google Sheets is available in both consumer Gmail and organization-wide G Suite. The function allows users to create trend charts and comparisons for any assets that have a valid Google Finance ticker symbol.

Here are several examples of how the GOOGLEFINANCE function can be used in Google Sheets to compare the performance of stocks and indexes against one another. Continue reading GOOGLEFINANCE Function: How To Compare Stock Performance

Embed a “Live” Google Sheets Pricing Table in a Proposal Doc

Embed Spreadsheet Pricing Table in DocumentFor salespeople who regularly send out long form proposals that contain pricing tables, there has always been a conundrum.

That is, a pricing table within in a document can’t be dynamically updated as easily as a spreadsheet table. The word processing capabilities within a spreadsheet are limited.

Often, a proposal’s pricing table is revised several times before the final version of a proposal is sent to the prospect or customer. This can require manual effort. Either the new bottom line in the document table needs to be hand calculated when line items are changed — or the spreadsheet table must be re-copied/pasted a into the document. Continue reading Embed a “Live” Google Sheets Pricing Table in a Proposal Doc

What is Google Sheets and How Does it Work?

Google Sheets ExplainedGoogle Sheets is one of the productivity applications that’s included with free consumer Gmail and with G Suite [for business].

It is a cloud based spreadsheet application. No desktop software is needed to create and edit spreadsheets. Spreadsheets are stored in the cloud, on a virtual drive called Google Drive.

Google Sheets can be used for everything from basic calculations to sophisticated data analysis. Continue reading What is Google Sheets and How Does it Work?

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. Continue reading Google Analytics Reports in Google Sheets – Using Filters

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

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. Continue reading Publishing Pivot Table Charts to Your Website With Google Sheets