Excel tutorials
Practical Excel guides for Microsoft 365, Excel 2021/2024, Excel for Mac and Excel for the web. Formulas, pivots, formatting and data cleanup - each with ribbon paths and common mistakes.
How to merge cells in Excel (and unmerge them)Merge cells in Excel with Merge & Center, merge without losing data, unmerge, and use Center Across Selection instead. Steps and shortcut Alt H M C.How to use VLOOKUP in Excel (with XLOOKUP examples)Learn the VLOOKUP formula with a worked example, fix #N/A errors, and see why XLOOKUP is easier in Excel 365. Copy-ready formulas included.How to freeze rows and columns in ExcelKeep headers visible while you scroll: freeze the top row, first column or several rows and columns in Excel, and unfreeze panes. Windows, Mac and web.How to remove duplicates in Excel (3 ways)Delete duplicate rows with Data > Remove Duplicates, highlight duplicates first with conditional formatting, or use the UNIQUE function in Excel 365.How to create a drop-down list in ExcelAdd a drop-down list to Excel cells with Data Validation, make it update automatically from a table, edit or remove it. Windows, Mac and web steps.How to lock cells in Excel to protect formulasLock specific cells in Excel while letting people edit the rest: unlock input cells, protect the sheet with a password, and unprotect it later.How to wrap text in Excel and add a line break in a cellWrap text in Excel cells with one click, add a line break inside a cell with Alt+Enter (or Option+Return on Mac), and fix rows that won't resize.How to use SUMIF and COUNTIF in ExcelAdd or count cells that meet a condition with SUMIF and COUNTIF, plus SUMIFS/COUNTIFS for multiple criteria. Copy-ready formulas.How to create a pivot table in Excel (beginner guide)Build a pivot table from a data list: Insert > PivotTable, add rows/values/filters, refresh after data changes, and fix common layout issues.How to write an IF formula in Excel (with nested IF and IFS)Learn IF, nested IF and IFS with clear examples for pass/fail, bonuses and status labels. Includes IFERROR and common mistakes.How to use conditional formatting in ExcelHighlight duplicates, color scales and formula-based rules with Home > Conditional Formatting. Edit and clear rules safely.How to split text into columns in ExcelUse Data > Text to Columns to split cells by comma, tab, space or fixed width. Also see TEXTSPLIT in Excel 365.How to filter and sort data in ExcelTurn on filters, filter by values or color, sort A to Z or by multiple columns, and clear filters without losing data.How to create a chart in Excel (and pick the right one)Make a chart in Excel in four clicks, choose column, line, pie or scatter, add titles and labels, and fix charts that plot the wrong data. Windows, Mac, web.