️https://www.simonsezit.com/the-ultimate-excel-tutorial-instructor-files/
We've combined some of our best Excel tutorials into this training video to take you from beginner to Excel expert in less than 6 hours! We've divided this tutorial into 6 comprehensive topics to make sure we've got you covered.
We start from the basics with Excel Formulas for Beginners, where we teach you some of the common functions used in Excel such as VLOOKUP, COUNT, SUM and IF and how calculations work in Excel, and data cleaning in Excel, where we Let's share 10 tips and tricks for data cleanup like clear formatting, remove duplicates, use Find and Replace and how to do basic cleanup in Power Query.
We then move on to intermediate concepts like pivot tables and pivot tables, where we discuss 8 functions that use pivot tables to solve problems like XLOOKUP and XMATCH.
We finish by covering advanced formulas in Excel, where we delve into logical functions and other advanced Excel functions such as INDEX, MATCH, SUMPRODUCT, SUMIFS and COUNTIFS and finally VBA macros for beginners, where we explain what the macros and VBA. and will show you how to record, save and run macros in Excel. You will also learn how to edit VBA code and assign macro shortcuts.
We've even included downloadable course files so you can take this course. This will help you practice what you learn and master MS Excel.
https://www.simonsezit.com/the-ultimate-excel-tutorial-instructor-files/
Use the timestamps below to navigate to different sections of the course. If you already know any of these topics, don't hesitate!
0:00:00 – Excel formulas for beginners
1:07:19 – Data cleaning in Excel
2:12:55 – Excel Tutorial on Pivot Tables
3:03:44 – Dynamic array functions
15:45:20 – Advanced formulas in Excel
4:41:15 – Basic Macros and VBA in Excel
Benefit from unlimited training with Simon Sez IT's 150 courses https://www.simonsezit.com/courses/
Improve your skills with a 30-day free trial of our comprehensive training library of 8,500 videos https://www.simonsezit.com/ssit-first-month-free
Watch other popular free training tutorials from Simon Sez IT:
Discover our FREE 300-hour training playlist here ️
https://www.youtube.com/playlist?listPLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU
Check out our free video playlist for Excel beginners https://www.youtube.com/playlist?listPLzj7TwUeMQ3iZHn4cv_fZagWSN8tubU9Z
Excel 2021 tutorials for intermediate users here https://www.youtube.com/playlist?listPLzj7TwUeMQ3jhT7yg37LKe8aSTA7OuWn3
Microsoft Excel Tips and Tricks https://www.youtube.com/playlist?listPLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc
Microsoft Office 2021 and Office 365 training here https://www.youtube.com/playlist?listPLzj7TwUeMQ3hH_MxteY6LR3OSMHpDkt_j
Staying in touch!
SimonSezIT.com: https://www.SimonSezIT.com/
LinkedIn: https://www.linkedin.com/company/simon-sez-it/
Facebook: https://www.facebook.com/SimonSezIT
Subscribe to our channel:
https://www.youtube.com/simonsezittraining?sub_confirmation1
If you enjoyed the video, don't hesitate to give it a thumbs up 😉
Please take the opportunity to connect and share this video with your friends and family if you find it useful.
No Comments