Using Google Translate Within Google Sheets

Google Translate Sheets

If you want to translate the complete contents of a webpage or a blog post — such as from English to Spanish — the Google Sheets GOOGLETRANSLATE function is a great way to create a first draft translation. A Google Sheet also helps you to … [Read more…]

How to Make a Line Graph in Google Sheets

Lake Shasta Water Level Line Chart

To give you a concrete example of how to make a line graph in Google Sheets, we are first going to show you how to extract some real-world data from The State of California Department of Water Resources. Specifically, we’re going to use a Google … [Read more…]

How to Merge Cells in Google Sheets

Merge Cells Vertically

There are a number of reasons you would want to merge cells in Google Sheets. One reason is that you need to add headings and an image to an instructional sheet such as on this one, which explains how to copy and use a Google … [Read more…]

How To Remove Duplicates In Google Sheets

Duplicates

There are a number of cases in which you may want to remove duplicates from a list of records using Google Sheets. For example, you may want to remove duplicate records before importing a list of leads from a spreadsheet into a CRM system such … [Read more…]

Bitcoin vs Gold in Google Sheets

Bitcoin vs Gold

Updated: January 16, 2021 Google Sheets, available as part of both consumer Gmail and organization-wide Google Workspace, allows users to easily create trend charts based on any source that can be connected to a Google Sheet. The GOOGLEFINANCE function for Bitcoin was not working for … [Read more…]

6 Business Data Sources To Feed Into Google Sheets

Google Sheets Data connector for Salesforce

There are a variety of add-ons and built-in functions for seamlessly and automatically pulling business data into Google Sheets from external sources.

Once business data is in Sheets, it can be manipulated an analyzed in a number of ways.

Here are six functions and add-ons for importing information into Google Sheets. All six are free of charge.

[Read more…]

Using the GOOGLEFINANCE Function In Google Sheets

GOOGLEFINANCE Function Examples

The GOOGLEFINANCE function is part of Google Sheets. Google Sheets is available in both consumer Gmail and organization-wide Google Workspace. 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 … [Read more…]

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.

[Read more…]

What is Google Sheets and How Does it Work?

Google Sheets Explained

Google Sheets is one of the productivity applications that’s included with free consumer Gmail and with Google Workspace [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 … [Read more…]

Google Analytics Reports in Google Sheets – Using Filters

Google Analytics ReportsOne of many benefits to using Google Workspace is that Google Workspace 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…]

Publishing Pivot Table Charts to Your Website With Google Sheets

Google Sheets - Move Chart to Own Sheet

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…]

This site includes affiliate links to Google.com, ClaimYourAid.com & WPEngine — and associate links to Amazon.com. As an Amazon Associate, I earn from qualifying purchases.

Gmail™, Google Workspace™, Google Sheets™ , Google Docs™ , Google Slides™ , Google Meet™ , Google Drive™, and Google Sites™ are trademarks of Google LLC

#supportukraine