Lookup, text, date and dynamic-array formulas with worked examples.
Everything about looking up data in Excel in one place: exact and approximate matches, left lookups, two-way lookups, multiple criteria, last match, returning all…
Read article →Create a second dropdown that changes with the first — Category then Product, Country then City — using INDIRECT with named ranges or a…
Read article →Three ways to remove duplicates in Excel — the Remove Duplicates button, the UNIQUE function and Advanced Filter — with when each is the…
Read article →Computers store numbers in binary, so 0.1 cannot be stored exactly. Why that makes 0.1+0.2 ≠ 0.3, how it shows up in Excel, Python…
Read article →Formatting a range as an Excel Table gives you auto-expanding formulas, readable references, slicers, totals and pivot sources that never miss new rows. Ten…
Read article →A cheat sheet of Excel date formulas: first and last day of the month, quarters, Indian financial year, working days, age, week numbers, adding…
Read article →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 →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 →Lock formulas while letting people type in input cells, protect the workbook structure, and understand what Excel protection does — and does not —…
Read article →A practical comparison of VLOOKUP, XLOOKUP and INDEX-MATCH in Excel — when each one works, when it breaks, and which to use in 2025.
Read article →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 →
