A collection of blog posts about how to use Google Sheets, either with a consumer Gmail account or with a business Google Workspace account.
Gold and Bitcoin are viewed by many as hedges against government and Federal Reserve policies that reduce the purchasing power of the US dollar. Google Sheets, available in consumer Gmail and organization-wide Google Workspace, allows users … Read more →
Using AI in Google Sheets can save users time and give them insights they may not otherwise have discovered. In a January 2024 Fast Company article, Kristina Behr, VP of Product Management For Collaboration Apps, … Read more →
IMPORTRANGE is a function in Google Sheets that allows users to import a range of cells from one spreadsheet to another. This function is helpful for businesses that work with multiple spreadsheets and need to … Read more →
By setting up Google Sheets as a free RSS (and Atom) reader with social posting formulas, you can share your content — and the content of others — on social channels more quickly and easily. … Read more →
A slicer is an interactive tool that allows you to filter data in a pivot table, chart, or range in Google Sheets. It provides an intuitive and accessible way to control what data is displayed, … Read more →
Google Sheets, a widely used spreadsheet app, offers many functions to streamline data handling. Among these, the SUMIF is a particularly popular function for business users, providing the capability to perform conditional sums within large … Read more →
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 Google’s free, cloud-based spreadsheet application. It runs entirely in a web browser, stores files on Google Drive, saves every change automatically, and lets several people edit the same spreadsheet at the same … 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 →
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 →
Business users of Google Sheets can automate the import of data from a variety of sources, including RSS feeds, CRM, Google Analytics and more.
Gmail, Google Workspace, Google Sheets, Google Docs, Google Slides, Google Meet, Google Drive, and Google Sites are registered trademarks of Google LLC.