Dependent Dropdown Lists in Excel (Two Methods That Actually Work)
Create a second dropdown that changes with the first — Category then Product, Country then City — using INDIRECT with named ranges or a…
Read article →Excel Formulas
Lookup, text, date and dynamic-array formulas with worked examples.
📊
← Excel
Excel Formulas
Lookup, text, date and dynamic-array formulas with worked examples.
📄 41 articles⬇️ 39 with practice files🕒 Updated 26 Oct 2026
🎓 Start here: Excel for India Course → 🎓 Start here: Excel Course: Beginner → Expert → 🎓 Start here: Bank Statement Automation →Why 0.1 + 0.2 Is Not Exactly 0.3 (and Why Excel Sometimes Agrees)
Why 0.1 + 0.2 Is Not Exactly 0.3 (and Why Excel Sometimes Agrees)
Computers store decimals in binary, so 0.1 + 0.2 becomes 0.30000000000000004. Why it happens, why Excel usually hides it and where it doesn’t (wrapped…
Read article →Excel’s Strangest Behaviours Explained: 15 “Bugs” That Are Actually Features
Excel’s Strangest Behaviours Explained: 15 “Bugs” That Are Actually Features
Why Excel turns 1-2 into a date, drops leading zeros, shows ####, changes long numbers to E+ notation, gives #SPILL!, auto-corrects gene names and…
Read article →Why Does Excel Have Exactly 1,048,576 Rows? The Logic Behind Software Limits
Why Does Excel Have Exactly 1,048,576 Rows? The Logic Behind Software Limits
Why Excel stops at 1,048,576 rows and column XFD, why old Excel had 65,536 rows, why numbers lose digits after 15, why FAT32 files…
Read article →Excel Lesson 9: Your First Charts
Excel Lesson 9: Your First Charts
Pick the right chart for the job, build column, line, pie and combo charts in seconds, add titles and data labels, change the chart…
Read article →The Complete Guide to Excel Lookups: VLOOKUP, XLOOKUP, INDEX-MATCH and Beyond
The Complete Guide to Excel Lookups: VLOOKUP, XLOOKUP, INDEX-MATCH and Beyond
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 →Excel Lesson 16: Conditional Formatting
Excel Lesson 16: Conditional Formatting
Make important cells stand out automatically: highlight rules, top/bottom, data bars, colour scales and icon sets, formula rules that colour whole rows, managing rule…
Read article →Excel Lesson 8: Excel Tables (Ctrl+T) for Every List
Excel Lesson 8: Excel Tables (Ctrl+T) for Every List
Turn any list into an Excel Table with Ctrl+T: banded rows, filters, automatic expansion, calculated columns, the Total Row, slicers, and formulas that use…
Read article →Excel Lesson 17: Pivot Table Basics
Excel Lesson 17: Pivot Table Basics
Summarise thousands of rows in seconds: create a pivot table, drag fields into Rows, Columns, Values and Filters, change Sum to Count or Average,…
Read article →Excel Tables (Ctrl+T): 10 Reasons to Use Them for Every List
Excel Tables (Ctrl+T): 10 Reasons to Use Them for Every List
Excel Tables make lists self-expanding: formulas fill down, ranges grow, pivots and charts update, structured references read like English, slicers filter, and Power Query…
Read article →SUMIFS, COUNTIFS and AVERAGEIFS: The Complete Guide With 12 Examples
SUMIFS, COUNTIFS and AVERAGEIFS: The Complete Guide With 12 Examples
Master the conditional-sum family: multiple criteria, dates, wildcards, not-equal, blanks, OR logic and cell-referenced criteria, with 12 real examples and the mistakes to avoid.
Read article →Excel Lesson 3: Formatting Cells So Reports Read Well
Excel Lesson 3: Formatting Cells So Reports Read Well
Number, currency, percentage and date formats, custom formats like 000 and lakhs, alignment and wrap text, borders, Format Painter, cell styles — and why…
Read article →