All blog articles

Lido's Blog

Spreadsheets

Everything you've ever wanted to know about the world's most important software.

The Ultimate Starter Guide to Charts In Google Sheets

The Ultimate Starter Guide to Charts In Google Sheets

Discover the basics of chart-making in Google Sheets with this step-by-step guide, with short tutorials ranging from formatting to editing the data in your chart.

Google Sheets Add-Ons for Creating Forms

Google Sheets Add-Ons for Creating Forms

This article will discuss methods for building Google Forms from Google Sheets. Add-ons add functionality to Google Sheets and make Google Form creation a breeze!

Google Sheets Add-ons for Spreadsheet Formatting

Google Sheets Add-ons for Spreadsheet Formatting

Google Sheets can accomplish so many tasks, but sometimes the perfect feature is lacking. Here are some add-ons to up you spreadsheet formatting abilities on Google Sheets

Boost Your Data Analysis in Google Sheets by Using Pivot Tables

Boost Your Data Analysis in Google Sheets by Using Pivot Tables

Pivot Tables in Google Sheets can be an incredibly useful tool for analyzing data. This article explain everything you need to know to effectively use Pivot Tables in Google Sheets.

40 Essential Google Sheets Tips & Tricks [2022 Edition]

40 Essential Google Sheets Tips & Tricks [2022 Edition]

In this 2022 edition, find 40 tips and tricks to quickly master Google Sheets

A Quick and Dirty Way to Connect Firestore to Google Sheets

A Quick and Dirty Way to Connect Firestore to Google Sheets

Learn a rough way of connecting Firestore to the program we all know and use. Here we outline for you the easiest way of connecting the data analyzation tool.

One Way to Connect Firebase to Google Sheets

One Way to Connect Firebase to Google Sheets

Learn about how to connect additional services to Google Sheets. More specifically, learn how to operate the Firebase program for maximal benefit to your business.

How to use Filter Views in Google Sheets

How to use Filter Views in Google Sheets

Learn how to add filter views in Google Sheets, as well as other aspects of the tool. Become familiar with all the different ways of utilizing filter views, and how useful they can be.

Your 2021 Guide to Spreadsheets

Your 2021 Guide to Spreadsheets

Learn how you can use spreadsheets, as well as the vast array of tools you choose from in order to access them. In addition, this article outlines how you can distinguish between such tools by outlining their various aspects.

Selecting the Correct Chart Type in Google Sheets [Ultimate Guide]

Selecting the Correct Chart Type in Google Sheets [Ultimate Guide]

Learn how to choose between line charts, area charts, column and bar charts, pie charts, scatter charts, and more on Google Sheets. Great for data visualization and analysis.

32 Essential Google Sheets Tips & Tricks [2020 Edition]

32 Essential Google Sheets Tips & Tricks [2020 Edition]

Become a Google Sheets power user with these spreadsheet tips and tricks. We'll cover how you can best format your content, use shortcuts, special formulas, and more!

Enhance Your Google Sheets Mastery Using Logical Functions

Enhance Your Google Sheets Mastery Using Logical Functions

Take full advantage of logical functions on Google Sheets, including NOT, AND, OR, etc. Learn how to combine them with the IF function and comparison operators.

Rounding Numbers in Google Sheets

Rounding Numbers in Google Sheets

Need to round up? Round down? Round in another way? This guide will cover 7 different instances of rounding numbers and how to complete each in Google Sheets. Great for data validation and analysis.

Making the most of unstructured data

Making the most of unstructured data

The ultimate guide on unstructured data management. Improve your business by learning the best ways to process and analyze emails, social media, and more.

Advanced Google Sheets features

Advanced Google Sheets features

Learn key Google Sheets functions, shortcuts, and its advantages over Excel. Pull website info with ImportXML, use Query and advanced formulas, visualize data.

Spreadsheet 101: A Beginner's Guide to Getting Started

Spreadsheet 101: A Beginner's Guide to Getting Started

Learn about the fundamental tool for data collection and management. Find out which platform (Google Sheets vs Excel vs Airtable) works best for you.

Dashboards 101: Using & Building Next Level Dashboard Tools

Dashboards 101: Using & Building Next Level Dashboard Tools

Become a dashboard power user by learning common dashboard use cases and benefits, as well as methods for building next level dashboards!

Jumpstarting Data Analysis with Pivot Tables

Jumpstarting Data Analysis with Pivot Tables

A step-by-step tutorial on how to build Pivot Tables in both Excel and Google Sheets. Learn why Pivot Tables are important for data analysis and visualization.

GOOGLE SHEETS 101 [Guide to The Online Spreadsheet Platform]

GOOGLE SHEETS 101 [Guide to The Online Spreadsheet Platform]

The ultimate 101 introduction to Google Sheets, detailing how to get started on the spreadsheet platform, learning certain functions and formatting features, and exploring other tips and tricks.

How to Highlight Duplicates on Google Sheets (in 5 simple steps)

How to Highlight Duplicates on Google Sheets (in 5 simple steps)

Step-by-step tutorial of how to highlight duplicates on Google Sheets, using Conditional Formatting and a custom formula. Good for locating repeat data!

Using Google Sheets for Basic Data Analysis (Functions, etc)

Using Google Sheets for Basic Data Analysis (Functions, etc)

The ultimate beginner's guide on how to get started with data analytics on Google Sheets. Learn about functions like VLOOKUP, using macros, and organizing data.

Best Methods for Pulling Data into Your Spreadsheet

Best Methods for Pulling Data into Your Spreadsheet

Beginner guide to pulling website data into a Google Sheet! Understand webpage structure and learn 4 ways to do this with IMPORTXML, IMPORTHTML, and more.

No items found.

CodeScript-Green

How to Import Salesforce Data to Google Sheets

Salesforce and Google Sheets, two incredibly popular and useful software applications. What if you could use them together? Read on to discover how to integrate Salesforce data into Google Sheets.

CodeScript-Green

How to Import Snowflake Data to Google Sheets

Snowflake, one of the most popular cloud database platforms today, contains much of your important data. This tutorial will show you how to import that data into Google Sheets so that you can analyze it and find important trends and metrics.

CloudStorage-Green

Guide to Printing in Google Sheets

Printing in Google Sheets can be challenging, but don't fear: this guide will teach you everything to know about printing in Google Sheets

VisualCodeEdit-Green

How to Sum Cells with Checkboxes in Google Sheets

Inserting checkboxes into your Google Sheets spreadsheet allows you to use the SUM formula only on checked checkboxes, giving users freedom to choose which numbers to include in the calculation.

CursorClick-Green

How to Create an Online Form Connected to Microsoft Excel Through Microsoft Forms

Similar to Google Forms, Microsoft also offers an integrated environment for collecting responses and store the results in a spreadsheet. In this article, discover how to create a Microsoft Form and connect it to Microsoft Excel.

CodeScript-Green

How to Add a Button in Google Sheets

Button can be an awesome way to easily trigger custom scripts in Google Sheets, greatly increasing speed and functionality., but a but

AnalyticsGraph-Green

How to Use GOOGLEFINANCE Function in Google Sheets

Google Sheets can be an effective method for analyzing stock market prices with the GOOGLEFINANCE function. This tutorial will teach you how to use the function and how it can be utilized effectively.

DataCheck-Green

How to Import Ethereum Historical Prices to Google Sheets

Google Sheets can be very useful for analyzing Ethereum's performance, but only after transferring the historical price data into Google Sheets. Fear not, for this tutorial will offer three easy solutions

How to Import Bitcoin Historical Prices to Google Sheets

Google Sheets can be an effective way to analyze historical Bitcoin prices, and this tutorial will demonstrate three methods for importing Bitcoin data.

Spreadsheet Grid-Green

How to Use Named Ranges in Google Sheets

Named Ranges are shortcuts to specific ranges that you can define and use in your formulas. In this tutorial, you will learn how to create, use, and edit or delete named ranges.

How to Sort Using Two or More Columns in Google Sheets

Learn how to set two or more sort columns in Google Sheets

How to Make Scatter Charts and Bubble Charts in Google Sheets

Learn how to create scatter charts and bubble charts in Google Sheets, useful tools for plotting data as individual points

How to Find the Day of The Week of a Given Date in Google Sheets

Learn how to use the WEEKDAY and SWITCH functions to find and include the day of the week of any date in a Google Sheet.

How to Use the SQL Limit and Offset Clause in Google Sheets

Learn how to utilize the LIMIT and OFFSET functions to manage which data is displayed and used in a Google spreadsheet.

Increase or Decrease the Number of Decimals Places of Numbers in Google Sheets

Learn how to modify the decimal place of numbers in google sheets to the desired precision. This tool will give you greater control fo both data and display in spreadsheets.

How to Create an Order Tracker Sheet in Google Sheets

Learn how to create and use order tracking sheets that will allow you to better communicate with you customers, developing confidence, efficiency, and long-term business success.

SWITCH Function: An Alternative to IF Function in Google Sheets

Learn to use this useful and valuable function which will give you greater control in altering and exchanging values when working in Google Sheets.

How to Lock Cells in Google Sheets

Learn to protect specific sets of cells in Google Sheets. This skill will give you greater control when making calculations, analyzing data, and sharing spreadsheets with other users.

Use VLOOKUP to Convert Numerical Scores to Letter Scores

Learn an easy and valuable strategy for mastering Google Sheets which will allow you to convert numerical scores into letter grades or assign any one value to another.

Working with Date and Time in SQL in Google Sheets

Learn two functions that will allow you to work with and operate on dates and times in SQL queries in Google Sheets.

How to Find and Replace Strings in Google Sheets

This simple yet powerful tool will help users of all skill levels to maximize their usage of Google Sheets in efficiently processing and analyzing data.

How to Search in Google Sheets

This simple tool is important for every Google Sheets user in expertly tracking and analyzing data, no matter their skill level.

Find the Date X Days After The Start Date in Google Sheets

This tutorial seeks to supply the user with the necessary tools to navigate dates in Google Sheets as they account for specified changes in days, months, and workdays.

Image of a Google Sheets spreadsheet.

Find the Number of Days Between Two Dates in Google Sheets

Learn a vital tool in the navigation of Google Sheets.

AnalyticsGraph-Yellow

How to Create an Area Chart in Google Sheets

There are many different kinds of area charts. Learn how to navigate the creation of these charts in Google Sheets to better model your data and statistics.

How to Protect the Contents of your Google Sheets

Learn how to keep your documents protected on this widely-used platform. Also, learn how to toggle controls to restrict or loosen access to your spreadsheets.

Image of a bar chart w/out backdrop

How to Create a Column Chart in Google Sheets

Learn a vital yet simple aspect of navigating Google Sheets.

AnalyticsGraph-Green

How to Create a Line Chart in Google Sheets

Learn a vital yet simple aspect of navigating through Google Sheets, the line chart.

Image of a customized Google Sheets window.

How to Customize Your Google Sheets Theme

Learn how to better navigate Google Sheets by customizing it to your own liking.

Image of a Google Sheets window performing a SUMIF function.

How to Use the SUMIF and SUMIFS Function in Google Sheets

Learn about two functions of Google Sheets that are vital to your proficiency: SUMIF and SUMIFS.

Image of a spreadsheet.

How to Calculate Standard Deviation, Variance, and Z-Score in Google Sheets

Learn how to better navigate Google Sheets and the tools it has to offer. Standard deviation, variance, and z-score are all important aspects and tools at your disposal.

Layered image of a spreadsheet on top of a window conducting data analysis.

How to Connect Google Analytics to Google Sheets

Learn how to connect to vital tools for your business. Doing so will greatly aid in many of your business's endeavors.

Layered image of a spreadsheet within a computer window.

IMPORTRANGE Errors? Here are ways to solve them

IMPORTRANGE is an effective data consolidation tool of Google Sheets. Learn how to harness this element and use it to better your work in Google Sheets.

Double-clicking on the header zooms you in to that section, making it more possible for you to visually see the subdivisions in that category.

How to Make Tree Map Charts in Google Sheets

A tree map diagram is one way to visualize and comprehend data in a chart more easily. This article goes over how you can both add to and customize tree map charts, while also providing you with a sample sheet to work with yourself.

Google Sheet with the questions from a Google Form forming the top fixed row.

How to Integrate Google Sheets with Google Forms [Step-by-Step Tutorial]

Learn how to integrate these two Google apps by storing Google Form results in a Google Sheet and generating a Google Form from a Google Sheet. Great for data collection and analysis.

Google Sheet with FILTER function examples

Using Google Sheets FILTER Function [w/ Single & Multiple Conditions]

Learn how to use FILTER on Google Sheets with single condition, multiple conditions, LARGE sort conditions, and SMALL sort conditions. Useful for data analysis and Google Sheets mastery.

Google Sheets with a Pivot Table. The upper-leftmost cell of the Pivot Table highlighted.

How to Delete Pivot Tables in Google Sheets and Excel

Step-by-step guide on how to delete a pivot table in both Google Sheets and Excel. We'll provide multiple methods and helpful screenshots!

IMPORTFEED importing the latest news headlines with their summary and timestamp.

How to Use Google Sheets IMPORT Functions [IMPORTDATA, IMPORTFEED, & More!]

A beginner's guide to using IMPORTDATA, IMPORTFEED, IMPORTHTML, and IMPORTRANGE to retrieve external data for your Google Sheet.

The int function applied to the entire array using arrayformula.

Guide to Using ARRAYFORMULA in Google Sheets (+ Examples!)

Learn how to use ARRAYFORMULA to copy entire rows, columns, and arrays; apply functions to entire arrays; and apply formulas to entire arrays! Great for improving data analysis and spreadsheet skills.

The Admin API section lists all the possible data that can be accessed via the Shopify API.

How to Find Your Shopify Store's API Key [in 6 easy steps]

Easy step-by-step tutorial on how to generate a private API key for your Shopify Store. Important for exporting Shopify data to Google Sheets and other business apps.

Google Sheet with list of fruit names in Column A

How to Randomly Pick a Name from A Long List in Google Sheets

A simple, step-by-step tutorial on how to randomly pick an entry from a list on Google Sheets. Uses the INDEX, RANDBETWEEN, and COUNTA functions in the process.

Google Sheet with sample data and VLOOKUP equations on the right

How to use VLOOKUP with Multiple Criteria in Google Sheets

Learn how to combine two or more criteria in the VLOOKUP function on Google Sheets. Great for data analysis with multiple variables.

How to Use ISBLANK Function in Google Sheets

Learn how to use ISBLANK function in Google Sheets without getting FALSE results on blank cells. Important for data validation and analysis in your spreadsheet.

A table of total profit from each product from a specific week, with a row per day of the week, using pivot. The table is essentially transposed, with each item getting their own column.

How to Use the SQL Pivot Clause in Google Sheets

Learn how to use Google Sheets SQL’s Pivot Clause clause to summarize large amounts of data by using two categories, one defining the rows and another defining the columns.

pop-up box for importing workbooks. Has four tabs for four options of importing the workbook: from your own Google Drive, from other users’ workbooks shared with you, from workbooks you recently opened in Google Sheets, and for uploading a spreadsheet file from your computer or smartphone, often as Excel workbook.

3 Easy Ways to Import Data from Another Workbook in Google Sheets

Step-by-step ways to import data from another workbook in Google Sheets. Learn about File>Import, IMPORTRANGE, and QUERY options to get the task done.

A sheet containing the Pivot Table. Uses Google Sheets’ Groovy theme, using shades of red to highlight the column labels, the row labels (the individual dates from July 6 to July 13), and the Grand Total.

How to Format Pivot Tables in Google Sheets

Learn how to format pivot tables in Google Sheets with or without its Themes option. We'll take you through the font, fill, number formatting, and more to make your pivot table look presentable for the end user.

Google Sheets list of total profit from each product from a specific week, arranged by decreasing total profit

How to Arrange the Order of SQL Query Results in Google Sheets

Learn how to arrange queried and aggregated data using SQL command 'order by'. Organize in ascending and/or descending order with our tutorial!

Results of the query. The first column contains the specific item, the second column contains the “sum profit” per listed item.

How to Use the 'Group by' SQL Clause in Google Sheets

Learn how to use Google Sheets SQL’s Group by clause to summarize large amounts of data by category defined in the source sheet, whether it’s summarizing by the date of entry or by the items involved.

Various SQL queries for aggregate values on Google Sheets

How to Use SQL Query for Aggregate Values in Google Sheets

Learn how to use SQL Queries for aggregate values in Google Sheets to better analyze your data. This tutorial will include how to use SUM, COUNT, AVG, MAX, and MIN.

Google Sheets spreadsheet with data and QUERY formula written in

How to Use SQL Queries to Format Google Sheets

Learn how to use SQL queries on Google Sheets to format date and time, currency, and more! We'll take you through steps and examples to get this done.

Pivot table on top of corresponding data

How to Add Custom Formulas in a Google Sheets Pivot Table

Step-by-step guide on how to add custom formulas in a pivot table on Google Sheets. We'll take you through how to add it in the source sheet first and in the Pivot Table directly.

Worksheet listing only entries for June 29. All other entries automatically hidden by the Slicer.

How to Use Google Sheets Slicer: Filtering Data (Tutorial)

Learn how to use the Slicer tool on Google Sheets to filter your data by Value and/or Condition. We'll take you through step-by-step on how to complete this task.

Spreadsheet containing several sheets. Names of sheets are week27, week28, and items. The displayed sheet, week27, contains the list of sales, costs, and the resulting profits.

How to Consolidate Several Sheets into a Single Pivot Table

Learn how to use a pivot table for data from multiple sheets in Google Sheets. We'll teach you how to merge sheet data with the QUERY function, allowing you to have all your data in one pivot table.

Snippet of the output sheet. The column headers were replaced by new ones.

How to Use SQL Labels in Google Sheets

Guide on how to use SQL labels in Google Sheets to make your QUERY functions more efficient and to add column headers to your data!

On top, data of US states and name origins. On bottom, query result listing the states, the year their name was first attested, and language of origin of their names. All the listed states have their name first attested before 1800.

How to Select Multiple Columns through SQL Query in Google Sheets

Learn how to select multiple columns with the QUERY function in Google Sheets and SQL language to add conditions to the query. Great for breaking up large sets of data!

end of data displayed by query. There are 1267 rows loaded by the QUERY command. Selected columns loaded: date of entry, total price of order, and profit from the order.

How to SQL Query Multiple Sheets in Google Sheets

Learn how to query data from multiple sheets of the same workbook, multiple sheets from a different workbook, and more! Useful for handling several sheets of data.

List of states whose names originated from either Spanish language or English language: Arizona, California, Colorado, Delaware, Florida, Georgia, Maine, Maryland, Montana, Nevada, New Hampshire, New Mexico, New York, North Carolina, South Carolina, Texas, Utah, and Washington. Queried from the source worksheet.

How to Use SQL Queries to Search for Specific Words in Google Sheets

Learn how to use the Google Sheets QUERY function to search and filter for specific words and phrases within your dataset. Helpful for analyzing text-heavy spreadsheets!

Image: U.S. states whose names did not originate from Spanish, English, nor French. The ones shown on the screen, in alphabetical order, are near the end of the list: Minnesota, Nebraska, North Dakota, Oklahoma, Oregon, Pennsylvania, Rhode Island, South Dakota, Tennessee, Virginia, West Virginia, and Wyoming.

How to Use SQL Query with Multiple Criteria in Google Sheets

Learn how to create a SQL query based on multiple criteria in Google Sheets. We'll go over some key logical operators like AND, OR, NOT to better enhance your data analysis abilities.

How to Filter Charts Using the Slicer on Google Sheets

An easy 5-step guide on how to filter charts and tables using the Slicer functions on Google Sheets. Improve your data analysis and visualization by harnessing the power of this function.

filtered data loaded into the spreadsheet using the same ImportJSON code.

How to Filter SQL Data Before Importing into Google Sheets

Easy guide on how to filter SQL data before importing into Google Sheets. We'll take you through the specific JSON code and alternative methods.

sample table. Includes columns for the title of the product, the description as the “body html”, the product type, the product handle, date of launch as “published at”, and the price as “variants price”.

How to Use Basic SQL Commands + Query Another Sheet in Google Sheets

Learn more about the QUERY function and easy ways to query another sheet (within the same workbook or from a different workbook) on Google Sheets. Improve your data analysis in no time with basic SQL knowledge!

A portion of a spreadsheet of order information. Contains the order timestamp as “Created At:, the total price, the customer name, and two columns where the timestamp was split into one column for the date of order and the time it was ordered.

How to Use SQL Queries to Search by Date on Google Sheets

Search items and data by date via the QUERY function in Google Sheets. Find entries for a specific date and within a date range with step-by-step SQL commands.

Google script editor. Code from bradjasper’s ImportJSON at GitHub inserted.

How to Export SQL Data to Google Sheets & Update Export

Learn how to import data from a SQL database to Google Sheets and also have the data update/refresh automatically! We'll take you through the specific script and functions needed to accomplish this task in no time.

Google Sheets pivot table, with the items rearranged from biggest profit to smallest.

How to Sort the Rows in the Pivot Table in Google Sheets

Simple 2-step guide on how to sort pivot table rows in Google Sheets. Perfect for enhancing your data analysis and improving your spreadsheet knowledge!

Pivot table in the new sheet. Displays the date as rows. The data cells contain the total profit for each day, as specified under the Values label of the Pivot table editor...

How To Use Pivot Tables To Summarize Data by Time On Google Sheets

Learn how to summarize your data by data, month, year, or any other relevant time period on Google Sheets by using the Pivot Table function. Follow our step-by-step tutorials to complete the tasks in just a couple of clicks!

How to Add/Remove Rows and Columns in Google Sheets [2022 Tutorial]

Step-by-step tutorials of 7 ways you add/remove rows and columns on Google Sheets, including Insert tab, right-click, PC and Mac keyboard shortcuts, and more!

Google Sheet entitled "How to Highlight Duplicates..." with highlighted duplicates in the third column

How to Highlight Duplicates on Google Sheets (in 5 simple steps)

Step-by-step tutorial of how to highlight duplicates on Google Sheets, using Conditional Formatting and a custom formula. Good for locating repeat data!

How to Insert Bulleted or Numbered Lists in Google Sheets

5 step-by-step tutorials of how to create bulleted and numbered lists on Google Sheets, using keyboard shortcuts, CHAR function, and Custom Number Formatting.

Spreadsheet named "How to Wrap Text in Google Sheets" with miscellaneous rows of information below and some wrapped text

Wrapping Text in Google Sheets: How to Keep Text In Cell

Step-by-step tutorials of 4 ways you can wrap text on Google Sheets. We'll also briefly cover all the text formatting options, like Overflow, Wrap, and Clip.

Spreadsheet named "Two Easy Ways to Copy Conditional Formatting..." with data below, the conditional formatting section highlighted, and the paint tool pressed

Two Easy Ways to Copy Conditional Formatting in Google Sheets

Step-by-step tutorials of 2 ways you can copy conditional formatting on Google Sheets with the Paint Format tool and Copy + Paste functions.

Spreadsheet named "How to Vlookup From Another Spreadsheet..." with data below and the second column using VLOOKUP.

How to Vlookup From Another Spreadsheet on Google Sheets

Step-by-step tutorial of how you can use VLOOKUP between two spreadsheets on Google Sheets. We'll also take you through what search_key, range, and index means.

How to Count Non-Empty Cells in Google Sheets

Google Sheets 101. Step-by-step tutorial of 3 ways you can count cells IF NOT blank on Google Sheets. We'll take you through how to use COUNTA, COUNTIF, and SUMPRODUCT for this use-case, as well as other Google Sheets tips and tricks.

Google Sheet titled "Using Conditional Formatting Based On..." with a table of Customer Name and corresponding payments for months May, June, and July

How to Use Conditional Formatting Based On Another Cell

Step-by-step tutorials on how you can apply conditional formatting based on the value of other cells in Google Sheets. We'll provide an example of a Sales use-case!

Header: Missing column between Column A and Column C

How to Quickly Unhide Columns in Google Sheets

Step-by-step tutorials on how you can unhide columns in Google Sheets on both your desktop and smartphone! We'll take you through the toggle and right-click options.

Header: An array of cells with Yes and No from drop-down lists

How to Add Yes/No Drop-Down Lists in Google Sheets

Step-by-step tutorials on how you can add, remove, and expand a yes/no drop-down list in Google Sheets. Eliminate errors via this data collection method!

Annual sales data, one column per branch, with line chart

How to Create a Chart with Multiple Ranges of Data in Google Sheets

Step-by-step tutorials on how you can create a chart with multiple ranges of data. We'll also take you through how to flip rows and columns so chart input is easier!

Heading photo. Name, Location, Phone Number

How to Format Phone Number Data on Google Sheets

3 easy methods on how you can consistently format phone number data in Google Sheets. Add a single quote, use the correct formula, or apply Custom Number Format.

Header image. Display checkboxes at the end of data table

How to Insert a Checkbox in Google Sheets

2 step-by-step tutorials on how to insert checkboxes and use it to control content of charts. We'll also go over its importance in data analysis and presentation!

Miscellaneous rows of data in a Google Sheet

How to Hide and Unhide Rows in Google Sheets

3 step-by-step tutorials on how hiding and unhiding rows in Google Sheets. We'll take you through 2 methods for unhiding rows, making you a Sheets pro in no time!

A table with values, percentage column empty

Absolute Reference in Google Sheets: A Beginner's Guide

A simple guide on how to use absolute references, the infamous F4 keyboard shortcut, and what other reference types (i.e. A$1, $A1) mean!

Gray bar moved to below Row 1, Row 1 now frozen on top

How to Quickly Freeze/Lock Rows in Google Sheets

4 simple ways to lock and unlock (or, freeze and unfreeze) rows on Google Sheets. Make your data more easy-to-read via the drag-down method or the View menu method!

Completed chart with title and labels

How to Add a Title and Label the Legends of Charts in Google Sheets

3 step-by-step tutorials on how you can customize your charts in Google Sheets, including adding a title, labeling legends, and changing the position of your legend!

Paste values only selected from Paste special option

How to Convert Formula Results into Static Values in Google Sheets

Google Sheets 101: learn how to transform cell-referenced data into actual values. Enhance your spreadsheet use and further analyze data with these 2 easy step-by-step tutorials!

Remove duplicates option under Data highlighted

How to Remove Duplicate Entries in Google Sheets

3 step-by-step tutorials on how you can remove duplicates in Google Sheets via Remove Duplicates tool, the UNIQUE function, and external add-ons!

How to Highlight Cells Containing Matching Search Query

Learn how to add an in-sheet search bar and highlight based on the entries in Google Sheets! We'll take you through how to highlight individual cells and rows.

Header image. The cell on another sheet selected.

How to Reference Another Sheet in the Same Workbook on Google Sheets

Easy step-by-step tutorial on how to reference cell(s) from another sheet in the same Google Sheets workbook! Useful for organizing large amounts of data.

Built-in number formats in Google Sheets

How to Convert Numbers to Strings in Google Sheets

Learn how to transform number data into text strings. We'll take you through the built-in Format tool, TO_TEXT(), and TEXT() as well as useful formatted functions!

Simple concatenate function. Data combined without space in between

Three Ways to Merge Cells in Google Sheets

Sometimes, you need to combine cells containing different information. Here are 3 simple ways to do so depending on the data stored in the cell.

Column split to two using SPLIT() function. The original column is not replaced.

How to Split Cells in Google Sheets

Some cells can contain information that must be split into columns. Learn 2 easy methods, via the Split Text tool and SPLIT() function, on how to do this task!

Nested IF() function in Google Sheets

Simple Guide To Using The IF() Function in Google Sheets

Learn the basics of the IF function in Google Sheets! We'll take you through examples of how to use the function on its own, with calculations, and with nested IFs.

Import file window. Upload tab shown

How to Convert Excel Files to Google Sheets (and Vice-Versa!)

As a free alternative to Microsoft Excel, you're likely interested in how to convert .xlsx files to Google Sheets. We'll take you through 2 simple methods for this!

Article Tags

Metrics calculator

Profitability metrics

Predict performance metrics

Customer behavior metrics

Customer satisfaction metrics

More article topics