281,329 views
► Subscribe to the channel: https://bit.ly/jakobnbr In this video tutorial I will show you what I think are the 20 most important functions in Microsoft Excel 365. Of course I can't present every single function in one video, but I hope that the basic logic has been explained well. If you still have questions about this or any other MS Access topic, please just ask them in the comments below. ▬ More videos ▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬ ► Professional dashboards in Excel • Create an interactive dashboard in Excel... ► The most important Excel functions • 20 Excel functions that EVERYONE can do... ►Common errors in Microsoft Excel • 8 things you're doing WRONG in Excel ▬ My equipment ▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬ In the video: ► Software: https://amzn.to/3eUCBNb ► Mouse: https://amzn.to/3ERJHwG ► Keyboard: https://amzn.to/3mPemof ► Screen: https://amzn.to/3EMIxCJ ► Microphone: https://amzn.to/3t149cl ► Camera: https://amzn.to/3eQZpgS Recommendations: ► Headset: https://amzn.to/3FSXtk7 ► Glasses: https://amzn.to/3sTf5bR Thank you for your free support through these affiliate links! ▬ About this channel ▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬ I am a business education graduate from Austria and run an SEO & web design agency full-time. On this channel you will find tips, tricks and tutorials about Microsoft products and digital work in general. Subscribe to my channel: https://bit.ly/jakobnbr LinkedIn: https://bit.ly/jnbr_linkedin ▬ Timestamps ▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬ 00:00 INTRO 00:40 SUM 02:03 AVERAGE 02:58 ROUND 04:18 E. IF 07:17 COUNTIF 09:25 SUMIF 10:53 RANK 13:32 TODAY 15:32 DATE 17:32 VLOOKUP 19:23 FIND 20:52 CONCATENATE 21:58 SMOOTH 22:55 RIGHT & LEFT 24:13 LENGTH 25:00 SMALL & LARGE 25:54 MIN MAX 27:02 AND OR 28:54 PART 30:12 IFERROR