Top Ten Excel Functions - IF, VLOOKUP, PMT, INDEX MATCH - Excel Tutorial HD

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/ - 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 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 ;-)