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:
Adam Lacey
Adam Lacey is an Excel enthusiast and online learning expert. He combines these two passions at Simon Sez IT where he wears a number of different hats.When Adam isn't fretting about site traffic or Pivot Tables, you'll find him on the tennis court or in the kitchen cooking up a storm.
