Excel Tutorials
Step-by-step guides for pivot tables, charts, conditional formatting, and more.
How to Create a Pivot Table in Excel
How to create a pivot table in Excel: insert one from a table, add rows, columns and values, then group and refresh. Includes a free interactive practice lesson.
Data Validation in Excel: Rules, Dropdowns & Custom Formulas
Master Excel data validation: create dropdown lists, number rules, date constraints, error alerts, and dependent dropdowns to keep your data clean.
Conditional Formatting in Excel: Rules, Formulas & Color Scales
Learn Excel conditional formatting from basics to custom formula rules. Highlight cells, add data bars, color scales, and manage rules across your workbook.
Excel Charts: How to Create, Format, and Choose the Right Chart Type
Learn how to create Excel charts from scratch. Compare column, bar, line, pie, and scatter charts, then customize titles, axes, labels, and chart styles.
How to Freeze Panes in Excel (Rows, Columns & Both)
Learn how to freeze the top row, first column, or any combination of rows and columns in Excel so headers stay visible while you scroll through data.
Power Query in Excel: Import, Transform, and Refresh Data Automatically
Get started with Excel Power Query: import CSV and Excel files, filter and reshape data, load results to a sheet, and refresh with one click when data changes.
How to Remove Duplicates in Excel (4 Methods)
How to remove duplicates in Excel: the Data tab tool, COUNTIF to find them first, UNIQUE for a clean list, and highlight-only. Practice the COUNTIF method live.
Array Formulas in Excel: From CSE Arrays to Dynamic Arrays
Master Excel array formulas: understand legacy CSE arrays and the modern dynamic array functions FILTER, SORT, UNIQUE, SEQUENCE, and XLOOKUP with arrays.
Excel Tables: Why You Should Use Ctrl+T on Every Dataset
Learn how Excel Tables (Ctrl+T) work: structured references, auto-expand, slicers, sorting, filtering, and when to convert back to a regular range.
How to Sort Columns in Excel
How to sort columns in Excel: A–Z from the Data tab, sort by two columns, and the SORT function that spills a live sorted list. Includes a free practice lesson.
Excel VBA Macros: Record, Write, and Run Your First Macro
Learn Excel VBA macros from scratch: show the Developer tab, record a macro with no code, run it, read the generated VBA, write a simple Sub yourself, and save a macro-enabled workbook safely.
Refresh Data in Excel: Shortcuts, Pivot Tables, and Power Query
How to refresh data in Excel: the Ctrl+Alt+F5 Refresh All shortcut, refreshing pivot tables and Power Query, the Mac ribbon method, automatic refresh on open, and fixing refresh errors.