Productivity

Sort Excel tables by cell color, font color, icons, or a custom list without separating rows from their records.

Understand the Google Sheets 20 million cell limit, beta availability, file sizing, and performance trade-offs.

Use Excel Evaluate Formula to step through nested calculations, find the first wrong value, and fix it safely.

Monitor important Excel formulas and values with Watch Window while navigating large, multi-sheet workbooks.

Use Excel Agent Mode for workbook tasks with safer prompts, review steps, and practical Copilot limits.

Learn how Excel formula completion suggests formulas as you type, how to review them, and how to validate results.

Create Google Sheets dependent dropdowns with FILTER, helper ranges, and reliable validation for changing lists.

Trace Excel precedents and dependents to find inputs, downstream impact, and safer formula audits.

Build dependent dropdown lists in Excel with INDIRECT or dynamic arrays, from two-level choices to three-level cascades.

Speed up slow Excel workbooks with Check Performance. Find and remove bloated formatting that drags down your files.

Google Sheets checkboxes store TRUE/FALSE values you can count, format and filter to build interactive to-do lists.

Excel July 2026 update: Copilot model choice (GPT-5.6, Claude Opus 5), inline citations, brand kit skills, and AutoSave-off support.

Learn to use AI for Excel formulas. Prompt templates for VLOOKUP, REGEX, nested IF — and how to validate AI output.

Open UTF-8 CSV files in Excel without garbled characters. Fix encoding issues with Power Query, Import Wizard, and BOM.

Create dropdown lists and validate data in Excel. Step-by-step guide to data validation rules and error alerts.

50+ Excel keyboard shortcuts for Windows and Mac. Organized by navigation, formulas, formatting, and editing.