Top Ten Excel Functions you HAVE to know.
You only really need to know a handful of the 500 or so Excel functions that exist to accomplish most things in a spreadsheet. The tricky thing is knowing which of those functions are the ones you need to know.
In this Excel masterclass, Excel expert Deb Ashby tells us what her top functions are. In this session she covers:
- The ‘Big Five’ Functions (SUM, AVERAGE, COUNT, MAX, MIN)
- Absolute vs Relative Referencing
- Working with Text Functions
- Using PMT to calculate loan payments
- Simple IF statements and Nested IF functions in Excel
- VLOOKUP in Excel
- Lookups with INDEX and MATCH, often called INDEX MATCH.
You can follow along with the session by downloading the Excel file Debs uses in the class: