To follow along, you can download the Excel file here ► https://www.simonsezit.com/article/top-ten-functions-you-have-to-know-in-excel/

To see a trimmed down version of this live session check out this video ► https://youtu.be/pz_qPnWh1vg

Get a FREE 2.4 hour Excel 2019 Beginners course here ►
https://simonsezit.lpages.co/excel-2019-beginner-course-ssit/

You only really need to know a handful of the 500 or so functions that Excel can do to accomplish most things in a spreadsheet. The tricky thing is knowing which of those Excel 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.

This was an Excel 2019 live class session delivered by Simon Sez IT. To attend future classes live, sign up to the Simon Sez IT newsletter (scroll to the bottom of the page!) - https://www.simonsezit.com/

For more Excel tutorials and Excel lessons, take a look at our Excel 2019 course:

https://www.simonsezit.com/courses/microsoft/learn-microsoft-excel-2019-training-tutorials/

Or, some of our other training on YouTube:

Excel 2019 training playlist:
https://www.youtube.com/playlist?list=PLzj7TwUeMQ3gABy6lbJgp6kZtXVhadATg

Excel 2016 beginner training: https://www.youtube.com/playlist?list=PLzj7TwUeMQ3iMo-GQKwQs5Ccb2IPtlwzW

Access for beginner tutorials: https://www.youtube.com/playlist?list=PLzj7TwUeMQ3ha9zOSPu9gGqgOilSRCKyK

Project 2016 beginner training: https://www.youtube.com/playlist?list=PLzj7TwUeMQ3gEx7_OYMI-PM_2ofCiVSq9

Visio 2016 for beginners: https://www.youtube.com/playlist?list=PLzj7TwUeMQ3gyO23ivFmXp37MsEEbFf2n

Word 2016 training: https://www.youtube.com/playlist?list=PLzj7TwUeMQ3gLcSQaxPMW_vma_z3xiwF1

Stay in touch:
SimonSezIT.com: http://www.simonsezit.com/
StreamSkill.com: http://streamskill.com/
YouTube Channel: http://bit.ly/foiItB
Facebook: http://on.fb.me/14m8Rwl
Twitter: http://bit.ly/177EU5J

If you enjoyed the video, please give a "thumbs up" and subscribe to the channel ;-)