Google Sheets Tutorials & Guides
Learn how to use Google Sheets with step-by-step tutorials. From basic formulas to advanced features, these guides help you get more done.
Google Sheets Dark Mode
Enable dark mode in Google Sheets on desktop and mobile.
How to Merge Cells
Merge cells in Google Sheets for cleaner layouts.
COUNTIF Guide
Count cells that match specific criteria.
SUMIF Guide
Sum values that meet specific conditions.
VLOOKUP Guide
Search and return matching values.
XLOOKUP Guide
Powerful search in any direction.
Change Currency Format
Apply dollar, euro, or custom currency symbols.
Highlight Duplicates
Find and highlight duplicate values.
Conditional Formatting
Color-code cells based on values and rules.
Sort Data
Sort alphabetically, numerically, or by date.
Checkboxes Guide
Add interactive checkboxes to spreadsheets.
Drop-Down Lists
Create data validation drop-down lists.
Wrap Text Guide
Make long text fit within cells.
How to Sum a Column
Multiple ways to total columns.
IMPORTRANGE Guide
Import data between spreadsheets.
FILTER Function
Extract data matching conditions.
Remove Duplicates
Clean duplicate data from your sheets.
Lock Cells
Protect cells from accidental edits.
Pie Chart Guide
Create and customize pie charts.
How to Subtract
Subtract numbers, dates, and time.
Split Text into Columns
Separate cell contents into columns.
Change Date Format
Customize date display formats.
ARRAYFORMULA Guide
Apply formulas to entire columns.
Pivot Table Guide
Summarize and analyze large datasets.
Alphabetize Data
Sort data A-Z or Z-A quickly.
Search & Find
Find and replace data in spreadsheets.
SUMIFS Guide
Sum with multiple conditions.
Find Duplicates
Various methods to find duplicates.
Keyboard Shortcuts
Boost productivity with shortcuts.