One useful Excel skill
at a time.
Find a practical lesson, follow the steps, and apply it to the workbook you are already using.
Choose your topic.
Formulas & Functions
Understand calculations, references, and useful functions.
Explore Formulas & FunctionsData Cleanup & Error Checks
Clean messy data and trace inconsistencies.
Explore Data Cleanup & Error ChecksShortcuts & Faster Workflows
Make repeated spreadsheet work simpler.
Explore Shortcuts & Faster WorkflowsCharts & Dashboards
Present data clearly and build useful views.
Explore Charts & DashboardsExcel Automation & VBA
Automate repeated tasks and workbook behavior.
Explore Excel Automation & VBATemplates & Business Workflows
Build practical reporting and tracking systems.
Explore Templates & Business WorkflowsLatest lessons.
How to Extract Text Before or After a Delimiter in Excel
Use TEXTBEFORE and TEXTAFTER to split email addresses, codes, and labels at a delimiter in Excel, with older-version fallback formulas and a full verification…
Read Tutorial
How to Create a Gantt Chart in Excel
Learn how to create a Gantt chart in Excel from a simple task table, hide the offset series, format the date axis, and verify every project bar.
Read Tutorial
How to Compare Three Variables with a Bubble Chart in Excel
Compare revenue, margin, and customer count in one Excel bubble chart. Follow the exact setup, formatting, labeling, and verification steps.
Read Tutorial
How to Combine Monthly Files with Power Query
Combine monthly Excel files from a folder with Power Query, standardize the columns, and refresh the consolidated table when files are added.
Read Tutorial
How to Find Inconsistent Data Types in a Column
Find mixed data types in an Excel column, identify the records causing errors, and convert the values to one consistent type.
Read Tutorial
How to Create Month Labels with the TEXT Function
Use the TEXT function to create clean month and year labels from Excel dates while keeping the original dates available for calculations.
Read Tutorial
Find Any Sheet Fast in Excel
Learn find any sheet fast in excel with a practical Excel example, clear steps, and a quick verification check.
Read Tutorial
Insert Page Break Fast
Learn insert page break fast with a practical Excel example, clear steps, and a quick verification check.
Read Tutorial
AutoFit Row Height in Excel
Learn autofit row height in excel with a practical Excel example, clear steps, and a quick verification check.
Read Tutorial
Faster Sheet Navigation in Excel
Learn faster sheet navigation in excel with a practical Excel example, clear steps, and a quick verification check.
Read Tutorial
XLOOKUP Multiple Results with FILTER
Learn xlookup multiple results with filter with a practical Excel example, clear steps, and a quick verification check.
Read Tutorial
Format Phone Numbers Fast in Excel
Learn format phone numbers fast in excel with a practical Excel example, clear steps, and a quick verification check.
Read Tutorial