âš¡ Multi-Platform Spreadsheet Education
Master Every Cell, Formula & Shortcut
Practical, step-by-step guides, cheat-sheets, and downloadable practice workbooks for Microsoft Excel, Google Sheets, and LibreOffice Calc.
| A | B | C | |
|---|---|---|---|
| 1 | Emp ID | Department | Salary |
| 2 | 1014 | Finance | $84,000 |
| 3 | 1015 | Operations | $92,500 |
| 4 | 1016 | Analytics | $96,000 |
fx =XLOOKUP(A4, Emp_ID, Salary, "Not Found")
Essential Cheat-Sheets Range [A1:D4]
View All Formulas →
LOOKUP
Excel 365
XLOOKUP Mastery
Modern replacement for VLOOKUP & HLOOKUP. Bidirectional, exact match by default, and error safe.
=XLOOKUP(val, lookup_rng, ret_rng)
Read Practical Guide
CLASSIC
Google Sheets
INDEX & MATCH
The enterprise workhorse lookup. Superior performance on massive workbooks across older Excel versions.
=INDEX(col, MATCH(val, col, 0))
Read Practical Guide
ARRAYS
Dynamic Arrays
FILTER & UNIQUE
Spill ranges automatically without Ctrl+Shift+Enter. Filter data dynamically into live report tables.
=FILTER(array, condition)
Read Practical Guide
SHORTCUTS
Windows & Mac
Top Speed Shortcuts
Save hours every week with keyboard navigation, auto-fill, and formula locking tricks.
Ctrl + Shift + L
Read Practical Guide
Latest Tutorials & Guides Table [Articles_Data]
#
Col A: Tutorial Title & Topic
Col B: Category
Col C: Platform
Col D: Companion Guide
1
Formulas & Functions
Excel 365
2
Other Office Tools
PowerPoint
6
Page Layout
Excel 365
9
Formulas & Functions
Excel 365