Excel Tutorials
Step-by-step guides for pivot tables, charts, conditional formatting, and more.
How to Create Pivot Tables in Excel
Learn how to create, customize, and master pivot tables in Excel. Step-by-step guide covering rows, columns, values, grouping, and calculated fields.
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 (3 Methods)
Learn three ways to remove duplicates in Excel: the built-in Remove Duplicates tool, COUNTIF to find them first, and conditional formatting to highlight them visually.
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.