In this 50 minute Excel tutorial we look at Excel formulas and functions that you need to know. This class is perfect for Excel beginners as we cover the basics before moving onto more advanced functions like VLOOKUP in Excel.
To follow along, you can download the Excel file here ⏩ https://www.simonsezit.com/article/top-ten-functions-you-have-to-know-in-excel/
Get a FREE 2.4 hour Excel 2019 Beginners course here ⏩
https://simonsezit.lpages.co/excel-2019-beginner-course-ssit/
Timestamp:
- Introduction 00:00
- SUM: 00:43
- AVERAGE: 02:20
- MIN: 04:18
- MAX: 05:01
- COUNT: 07:20
- Absolute vs Relative Referencing: 10:05
- Text Functions: 15:12
- Simple IF statements: 24:22
- Nested IF functions in Excel: 28:34
- Using PMT to calculate loan payments: 31:35
- VLOOKUP in Excel: 36:00
- HLOOKUP in Excel: 43:59
- INDEX MATCH Excel: 46:18
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.
For more Microsoft Excel 2019 tutorials and Excel lessons, take a look at our Excel course:
️https://www.simonsezit.com/courses/microsoft/learn-microsoft-excel-2019-training-tutorials/
Get unlimited training with Simon Sez IT’s 150+ courses ⏩ https://www.simonsezit.com/courses/
Level up your skills with a free 30 day trial to our complete training library of 8,500+ videos ⏩ https://www.simonsezit.com/ssit-first-month-free
Check out our Excel 2021 tutorials for beginners playlist here
https://www.youtube.com/playlist?list=PLzj7TwUeMQ3jqRlmIaj6jb_X9EGQueMDb
Check out our FREE 300+ hour training course playlist here ️
https://www.youtube.com/playlist?list=PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU
Watch more popular tutorials from Simon Sez IT:
Microsoft Office 2021 and Office 365 Training Tutorials playlist
https://www.youtube.com/playlist?list=PLzj7TwUeMQ3hH_MxteY6LR3OSMHpDkt_j
Microsoft Office 2019 Training Tutorials for Beginners playlist
https://www.youtube.com/playlist?list=PLzj7TwUeMQ3i2OE0G9fSMaVjcW4qi_z_7
PivotTable training here https://www.youtube.com/playlist?list=PLzj7TwUeMQ3iJ5hWG_iZuIvFvnuJJ-mtc
Stay in touch!
SimonSezIT.com: https://www.SimonSezIT.com/
StreamSkill.com: https://StreamSkill.com/
YouTube Channel: https://www.youtube.com/user/simonsezittraining
LinkedIn: https://www.linkedin.com/company/simon-sez-it/
Subscribe to our channel:
https://www.youtube.com/simonsezittraining?sub_confirmation=1
If you enjoyed the video, please give a "thumbs up" and subscribe to the channel ;-)