Advanced Excel Tutorial: 3+ Hours of Tips and Tricks

✅ Download the free course demo files to follow along

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.

📝 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

💻 Watch more free popular training tutorials from Simon Sez IT:

🔥Check out our FREE 300+ hour training course playlist here ➡️

💬Stay in touch!

🔔 Subscribe to our channel:

If you enjoyed the video, please give a thumbs up 👍🏽 ;-)

[wilmabaker]

Thanks for making it so easy to understand.

[GreenBooks-mmgp]

Good Efforts brother stay continued Shadab

[joaquinvasco]

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.

[Locomaid]

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

[alainpkpan]

The workbook for power query is not included. I hope you can settle it

[chrismansfield]

Hi, are you able to make the Sales Data files available for download - they're not included in the zip file. thanks

[dylanemezepo]

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