Master the MOST POPULAR Excel Formulas and Functions in ONLY 1 HOUR!

I am using Excel 2019 in this tutorial but you can also apply what I teach in Excel 2010, Excel 2013 , Excel 2016, and Excel Mac versions 2011 and 2016 (as well as the latest Office 365 version).

In this Excel Formulas and Functions tutorial you will learn you will also learn:

👉 The most popular Excel Formulas that get asked during interviews & ones that you NEED to know: VLOOKUP, INDEX/MATCH, SUMIF, IF
👉 A proven step by step guide to creating Excel Formulas in SECONDS!
👉 The limitations of using a VLOOKUP and why INDEX&MATCH is better!
👉 3 TIPS that the Excel experts & MVPS use that will enhance your Formula knowledge!

JUMP TO AN EXCEL FORMULA & FUNCTION TUTORIAL WITHIN THIS VIDEO:

0:00:00 - INTRODUCTION
8:38 - IF FUNCTION IN EXCEL
16:44 - SUMIF FUNCTION IN EXCEL
22:16 - VLOOKUP IN EXCEL
31:00 - INDEX & MATCH IN EXCEL
43:36 - WATCH WINDOW
47:30 - FORMULA TRACE
51:32 - EVALUATE FORMULAS WITH F9
57:50 - MYEXCELONLINE ACADEMY COURSE

------------

🔥 OUR BEST EXCEL RESOURCES 🔥

👨‍🏫 Get 30+ Excel & Office Courses & support for ONLY $1💵 (all levels covered)
Learn Formulas, Macros, VBA, Pivot Tables, Power Query, Power Pivot, Power BI, Charts, Financial Modeling, Dashboards, Word, PowerPoint, Outlook, Access, OneNote, Teams, Project, PowerApps, PowerAutomate, Visio, Forms & MORE!

📚 Download Our Free 101 Excel Tips & Tricks E-Book:

💻 Access 1,000+ Free Excel & Office tutorials over at our award-winning blog:

📚Get All Our 101 Excel E-Book series on Formulas, Macros & Pivot Tables:

📚101 Most Popular Excel Formulas Paperback on Amazon:

📚101 Ready To Use Excel Macros Paperback on Amazon:

📚101 Best Excel Tips & Tricks Paperback on Amazon:

👷 Excel Consulting Services:

💻 Looking for more Microsoft Excel & Office tutorials? Check out our playlist below:
------------

Feel free to comment and ask questions about this Microsoft Excel tutorial below and we will get back to you with the answer ASAP!

If you enjoyed the video, please give a thumbs up, comment, share.

Do not forget to SUBSCRIBE to this channel to get our new Microsoft Excel tutorials delivered straight to you each week! Thank You :)

Cheers,

JOHN MICHALOUDIS
Chief Inspirational Officer & Microsoft MVP

❤️ Let’s connect on social ❤️

#MyExcelOnline #MsExcel #Formulas

[mdgjegl]

This is the first instruction in a long time that I was able to learn from without being confused at the end of the webinar.

[bambie]

Very informative. You did an excellent job explaining everything. Thank you !

[nicoleplatt]

This one proved extremely helpful in a large spreadsheet with lots of data. Thank you so much. The content of the spreadsheet was easy to understand so that the formula may be understood for the interpretation and research of other data sources. Loved It!

[AliciaAli]

I thoroughly enjoyed this video, Mr Kyle Pew, you are an excellent teacher.

[melissaverea]

This was awesome and super helpful. THANK YOU.

[UDADNAMAS]

Amazing presentation in the simplest mode of conveying! Thanks a million. Congrats. Learnt a lot in a single video.

[manjulaa]

Thanks a lot for the detailed explanation and the free excel sheet. So helpful😊

[RiteshRG-vt]

Absolutely clear, Thanks a lot man!!!

[ranimaharaj-sharma]

One of the best trainer and great Training Company

[brandoncarlson]

I'm learning functions in excel and this video is phenomenal. I haven't seen another like it!!

[sakshisaini]

To the point and easy to understand, thank you for these videos, they are helping a lot in my company work project

[ghadaragab]

Thank you so much for the great course

[whysoserious]

Thank you for sharing your knowledge - stay health and again thank you - humanity can work together

[milies]

Thank you so much. It's a brilliant video. More ppl should see it!

[ricollchung]

very good tips and training. well presented. very useful. thx.

[abayomi-alliolusola]

I really enjoyed the video. Thank you so much

[oanhluong]

Thank you so much for all of your lectures. I would greatly appreciate it if you could please do more videos that related to using excel formula to estimate student hourly payroll bi-weekly? Thanks

[sharmahemkanta]

Sir, thank you for this video.The is extremely clear....

[RubenRodriguez-jxsc]

Kyle did an excellent job! Now I know how to use these functions 👌🏻

[jerrymilesmiles]

Outstanding! Best regards from Limón, Costa Rica!