IMPORTRANGE in Google Sheets: Pull Data From Another Sheet
Learn how to use IMPORTRANGE to pull live data from one Google Sheets file into another, allow access, combine it with QUERY, and fix common #REF! errors.
Excel & Sheets
How to Use the QUERY Function in Google Sheets (Beginner Guide)
QUERY is the most powerful function in Google Sheets. Learn SELECT, WHERE, ORDER BY, GROUP BY, LIMIT and LABEL with easy examples you can copy into your own sheets.
Sort vs Filter vs Slicers: How to Organize Data in Excel
Learn when to sort, filter, or use slicers in Excel. Step-by-step instructions for multi-level sorting, filtering by text, numbers and dates, the FILTER function, and slicers.
How to Make a Chart in Excel That Actually Looks Good
Create a chart in Excel in seconds, pick the right chart type for your data, and clean it up with 8 simple design tips so it looks professional in any report.
Excel for Beginners: 15 Things You Need to Know First
New to Excel? Start with these 15 essentials: workbooks and cells, entering data, formulas, AutoFill, cell references, formatting, sorting, filtering, tables, charts and shortcuts.
How to Split First and Last Names in Excel (4 Easy Ways)
Split full names into first and last name columns in Excel using Flash Fill, Text to Columns, TEXTSPLIT, or formulas. Includes tips for middle names and Google Sheets.
How to Freeze Rows and Columns in Excel and Google Sheets
Keep headers visible while you scroll. Learn how to freeze the top row, first column, or several rows and columns at once in Excel and Google Sheets, and how to unfreeze them.
How to Calculate Percentage Change in Excel (Increase and Decrease)
Learn the simple formula for percentage change in Excel, plus percentage of total, adding or removing a percentage, and how to avoid #DIV/0! errors. With copyable examples.
Why Is My Excel Formula Showing as Text? 5 Quick Fixes
Excel showing the formula instead of the result? Here are the 5 causes, from Show Formulas mode and Text-formatted cells to a missing equals sign, and how to fix each one.
Google Sheets Formulas Cheat Sheet (Free PDF)
Download a free printable Google Sheets formulas cheat sheet: 50+ formulas with examples, including Sheets-only tools like QUERY, IMPORTRANGE, ARRAYFORMULA, GOOGLETRANSLATE and REGEX.