A collection of blog posts about how to use Google Sheets, either with a consumer Gmail account or with a business Google Workspace account.
VLOOKUP in Google Sheets is a useful function for matching up data in different locations within a spreadsheet. In this post, we’ll provide examples of how we used ChatGPT to simplify creating a VLOOKUP formula. … Read more →
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 financial assets with a … Read more →
Salespeople who regularly send out long-form proposals that contain pricing tables find that Google Docs tables are cumbersome to manage. A pricing table within a document, including recalculating totals, can’t be dynamically updated as easily … Read more →
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 … Read more →
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 … Read more →
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 … Read more →
Whether and when to use Excel or Google Sheets depends on a number of factors. Here’s how to move spreadsheet information back and forth between the two environments.
How to visually display your Google Sheets data on your website or blog using embedded Pivot Table charts.
Google Sheets is one of the productivity applications that’s included with free consumer Gmail and with Google Workspace [for business]. Sheets is a cloud-based spreadsheet application. No desktop software is needed to create and edit … Read more →
Update: on December 8, 2022, Google introduced drop-down chips in Google Sheets, which vastly simplifies the process described below. One aspect of spreadsheets that makes them different from database applications is that it’s more difficult … Read more →
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 … Read more →
There are several cases in which you may want to remove duplicate rows from a list of records using Google Sheets. For example, you might want to remove duplicate records before importing a list of … Read more →
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.
This website includes affiliate links to a Google Workspace free trial page and referral links to a Google Cloud Premier Partner page.
Gmail, Google Workspace, Google Sheets, Google Docs, Google Slides, Google Meet, Google Drive, and Google Sites are registered trademarks of Google LLC.