Excel Lesson 4: Your First Formulas and Cell References
Write formulas that start with =, use + - * / and ^, follow the order of operations, refer to cells instead of typing…
Read article →Excel Formulas
Lookup, text, date and dynamic-array formulas with worked examples.
Excel Lesson 2: Entering Data, AutoFill and Flash Fill
Excel Lesson 2: Entering Data, AutoFill and Flash Fill
Enter numbers, text and dates correctly, fill series with the fill handle, use Ctrl+Enter and Ctrl+D, and let Flash Fill split and join names…
Read article →Excel Lesson 1: The Excel Screen and Moving Around Fast
Excel Lesson 1: The Excel Screen and Moving Around Fast
Your first Excel lesson: workbooks, sheets, rows, columns and cells, the ribbon, Name Box and formula bar, and the keyboard shortcuts that make you…
Read article →Remove Duplicates in Excel: 3 Quick Ways (and Which to Use)
Remove Duplicates in Excel: 3 Quick Ways (and Which to Use)
Remove or find duplicates in Excel three ways: the Remove Duplicates button, Advanced Filter unique records, and UNIQUE/COUNTIF formulas. Which to use when, how…
Read article →Using AI to Write Excel Formulas — and How to Check Its Work
Using AI to Write Excel Formulas — and How to Check Its Work
AI assistants can draft Excel formulas and VBA in seconds, but they also make confident mistakes. How to prompt them well and a 5-step…
Read article →TEXTSPLIT, TEXTBEFORE and TEXTAFTER: Splitting Text Without the Headache
TEXTSPLIT, TEXTBEFORE and TEXTAFTER: Splitting Text Without the Headache
Split codes, names, addresses and emails in Excel 365 with TEXTSPLIT, TEXTBEFORE and TEXTAFTER: delimiters, instance numbers, multiple delimiters, rows vs columns, missing values…
Read article →Dynamic Arrays in Excel: SORT, FILTER and UNIQUE in Plain English
Dynamic Arrays in Excel: SORT, FILTER and UNIQUE in Plain English
Understand Excel 365 dynamic arrays: spilling results, the # spill reference, FILTER with AND/OR, SORT and SORTBY, UNIQUE counts, SEQUENCE, LET, and fixing #SPILL!…
Read article →Conditional Formatting with Formulas: 10 Rules Worth Knowing
Conditional Formatting with Formulas: 10 Rules Worth Knowing
Ten formula-based conditional formatting rules for real reports: highlight whole rows, overdue dates, duplicates, top N, weekends, missing values and differences between lists.
Read article →Excel Shortcut of the Week: Ctrl+E Flash Fill
Excel Shortcut of the Week: Ctrl+E Flash Fill
Flash Fill (Ctrl+E) splits, joins and reformats text by example — no formulas. How to use it, five real examples, and when to use…
Read article →INDEX and MATCH Explained: The Lookup That Beats VLOOKUP
INDEX and MATCH Explained: The Lookup That Beats VLOOKUP
Understand INDEX and MATCH separately, combine them for flexible lookups in any Excel version, look left, do two-way and multiple-criteria lookups, approximate matches, and…
Read article →Protect Excel Sheets and Workbooks the Right Way
Protect Excel Sheets and Workbooks the Right Way
Lock formulas and leave inputs editable: unlock input cells, protect the sheet with the right options, hide formulas, protect workbook structure, allow ranges for…
Read article →Excel Data Validation: Stop Bad Data Before It Gets In
Excel Data Validation: Stop Bad Data Before It Gets In
Use Excel Data Validation to block wrong entries: drop-down lists, whole numbers, date ranges, text length, and custom formula rules for PAN, mobile numbers,…
Read article →