| Shortcut or formula | Use |
|---|---|
| Ctrl+Shift+L | Turn filters on or off |
| Ctrl+T | Convert range to a table |
| Alt+= | AutoSum |
| F4 | Lock cell references |
| Ctrl+Arrow / Ctrl+Shift+Arrow | Jump or select to the end of data |
| Ctrl+1 | Format cells |
| SUMIFS / COUNTIFS | Total or count with conditions |
| XLOOKUP or VLOOKUP | Match data from another table (XLOOKUP in newer Excel) |
| INDEX + MATCH | Flexible lookup |
| IF / IFERROR | Conditions and clean errors |
| TEXT, EOMONTH | Month names, month-end dates |
| Pivot table | Summaries in seconds |
3 mini exercises
- ReconcileUse XLOOKUP to match invoice numbers from books with GSTR-2B and flag differences.
- AgeingUse IF and TODAY to bucket receivables into 0 to 30, 31 to 60 and 60+ days.
- SummaryUse a pivot table to show monthly expenses by category.
Pro tipPractise on a messy file
Clean data is rare. Learn Text to Columns, Remove Duplicates and TRIM early.
Foundation: Excel skills commerce students need.