Advanced Excel Tutorial: 3+ Hours of Tips and Tricks

✅ Download the free course demo files to follow along
➡️ www.simonsezit.com/excel-mast...
Unlock the full potential of Microsoft Excel with this Excel Mastery training with over 3 hours of engaging content, where you'll learn the secrets to becoming an Excel pro.
In this tutorial, dive into PowerPivot and Power Query, mastering data importation, cleaning, and visualization using PivotTables and Pivot Charts. Explore basic forecasting techniques using functions like SLOPE, INTERCEPT, and FORECAST.LINEAR. Discover the power of WhatIf Analysis, including Goal Seek, Scenario Manager, and Data Tables. Finally, delve into Macros and VBA, from recording and running macros to editing and assigning shortcuts.
Join us in this tutorial training and revolutionize your Excel skills! Boost your productivity, make accurate forecasts, and automate tasks like never before.
We've even included downloadable course files so you can follow along in this course. This will help you put what you are learning into practice, and master advanced Excel functions.
✅ www.simonsezit.com/excel-mast...
📝 Use the timestamps below to navigate to different sections of the course. If you already know one of these topics, skip ahead!
00:00:00 - PowerPivot and Power Query
00:54:45 - Basic Forecasting in Excel
01:35:20 - WhatIf Analysis in Excel
02:18:14 - Macros and Basic VBA in Excel
🌍 Get unlimited training with Simon Sez IT's 200+ courses ⏩ www.simonsezit.com/courses/
🚀 Level up your skills with a free 30-day trial to our complete training library of 10,000+ videos ⏩ www.simonsezit.com/ssit-first...
💻 Watch more free popular training tutorials from Simon Sez IT:
🔥Check out our FREE 300+ hour training course playlist here ➡️
• Simon Sez IT Long Trai...
✅ Check out our free video playlist for Excel beginners 👉 • Microsoft Excel Beginn...
✅ Excel 2021 Tutorials for Intermediate Users here 👉 • Excel 2021 Tutorials f...
✅ Microsoft Excel Tips and Tricks 👉 • Microsoft Excel Tips a...
✅ Microsoft Office 2021 and Office 365 Training here 👉 • Microsoft Office 2021 ...
💬Stay in touch!
SimonSezIT.com: www.SimonSezIT.com/
LinkedIn: / simon-sez-it
FaceBook: / simonsezit
🔔 Subscribe to our channel:
ua-cam.com/users/simonsezittra...
If you enjoyed the video, please give a thumbs up 👍🏽 ;-)

[@SimonSezIT]

✅ Download the free course files to follow along and complete the exercises here ➡www.simonsezit.com/excel-mastery-webinar/

[@wilmabaker682]

Thanks for making it so easy to understand.

[@SimonSezIT]

Glad it was helpful! Learn Microsoft Excel Tips and Tricks here ➡️
ua-cam.com/play/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc.html

[@nezmkgamerz4751]

Thanks For this Productive Lecture.

[@SimonSezIT]

Thanks for the kind comments 🙂

[@Locomaid]

@SimonSezIT - I received the download but there were no csv files included... Can I get those somewhere?

[@abrahammanyang5313]

Great Webinar

[@SimonSezIT]

Glad it was helpful! Keep up the excellent work, and keep learning!

[@joaquinvasco9361]

Thanks for this amazing video. I was trying to add Power Pivot to my Excel 365 Office, but I couldn't. Do you have any idea how to do it? Thanks in advance.

[@SimonSezIT]

Glad it was helpful! 🤩 You may check our beginner-friendly Pivot tutorials here ➡️ ua-cam.com/play/PLzj7TwUeMQ3i80FzwXA86zJOK8dtlB-qt.html

[@user-od4fz5ls3d]

Thanks for all you did.......

[@SimonSezIT]

Thanks for the kind comments 🙂

[@dylanemezepo5949]

I did not receive the files on my mail please what to do?

[@adamtabor6754]

Why not csv file ?

[@tomasarguelles8433]

There're not files 2017 and 2018