To follow along, you can download the Excel file here ► www.simonsezit...
To see a trimmed down version of this live session check out this video ► • Top Ten Excel Formulas...
Get a FREE 2.4 hour Excel 2019 Beginners course here ►
simonsezit.lpa...
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!) - www.simonsezit...
For more Excel tutorials and Excel lessons, take a look at our Excel 2019 course:
www.simonsezit...
Or, some of our other training on KZitem:
Excel 2019 training playlist:
• Microsoft Excel 2019 T...
Excel 2016 beginner training: • Microsoft Excel 2016 C...
Access for beginner tutorials: • Microsoft Access 2016 ...
Project 2016 beginner training: • Microsoft Project 2016...
Visio 2016 for beginners: • Microsoft Visio 2016 T...
Word 2016 training: • Microsoft Word 2016 Tr...
Stay in touch:
SimonSezIT.com: www.simonsezit....
StreamSkill.com: streamskill.com/
KZitem Channel: bit.ly/foiItB
Facebook: on.fb.me/14m8Rwl
Twitter: bit.ly/177EU5J
If you enjoyed the video, please give a "thumbs up" and subscribe to the channel ;-)
Негізгі бет Excel Tutorials - Top Ten Excel Functions you HAVE to know - Excel 2019 (IF, VLOOKUP, SUM, PMT)
Пікірлер: 22