Notes

Download study notes

Use these printable notes as a quick revision sheet while learning formulas, shortcuts, and interview topics.

The download is a lightweight study file you can print or save for offline revision.

Excel Mastery Hub Study Notes

1. SUM adds numbers across ranges.
2. IF returns one value for TRUE and another for FALSE.
3. VLOOKUP searches the first column of a table.
4. XLOOKUP is the modern lookup function.
5. FILTER returns rows that meet a condition.
6. UNIQUE removes duplicates from a list.
7. INDEX + MATCH supports flexible lookups.
8. COUNTIF and SUMIF handle conditional counting and totaling.

Practice checklist:
- Review syntax
- Try the example table
- Complete the quiz
- Bookmark difficult topics
- Revisit recently viewed formulas