The Complete Advanced Excel Bundle

Four Advanced Excel Courses to Supercharge Your Spreadsheets

This four-course bundle is not for Excel newbies. If you've got an excellent understanding of Excel and you're ready to learn how to automate repetitive tasks, how to analyze millions of rows of data, how to forecast and use statistical functions, then this bundle is for you.

This bundle includes four comprehensive, advanced courses designed to take your spreadsheeting skills to the top level.

The courses included in this bundle are below as well as the order in which we recommend you take them:

  1. Advanced Excel 2019
  2. Power Pivot, Power Query and DAX in Excel
  3. VBA for Beginners
  4. VBA Intermediate

Advanced Excel 2019

What you'll learn:

  • What's new/different in Excel 2019
  • Advanced charting and graphing in Excel
  • How to use detailed formatting tools
  • Lookup and advanced lookup functions
  • Financial functions including calculating interest and depreciation
  • Statistical functions
  • Connecting to other workbooks and datasets outside of Excel, e.g. MS Access and the web.
  • How to create impressive visualizations using sparklines and data bars
  • Mastery of PivotTables and Pivot Charts
  • Scenario Manager, Goal Seek and Solver
  • Advanced charts such as Surface, Radar, Bubble and Stock Charts

Power Pivot, Power Query & DAX in Excel

In this course you will learn:

  • How to get started with Power Query
  • How to connect Excel to multiple workbooks
  • How to get data from the web and other sources
  • How to merge and append queries using Power Query
  • How the Power Pivot window works
  • How to set up and manage relationships in a data model
  • How to create a PivotTable to display your data from the Power Pivot data model
  • How to add calculated columns using DAX
  • How to use functions such as CALCULATE, DIVIDE, DATESYTD in DAX
  • All about creating Pivot Charts and PivotTables and using your data model
  • How to use slicers to adjust the data you display

VBA Beginners

  • Introduction to VBA as a language (syntax and keywords)
  • How to automate repetitive tasks
  • Macros, subroutines and logical constructs
  • Introduction to VBA functions including returning values from functions
  • Writing an array formula
  • Key Objects and error handling in VBA
  • PivotTable and Chart Objects

Intermediate VBA

  • Deeper dive into the VBA Language
  • Core VBA module interactions
  • Advanced parameter definitions
  • Excel events including pre-defined and event parameters
  • Custom Objects including creating and defining a Class
  • Creating and designing a Userform
  • Modifying the Excel interface and UI
  • External references and Office Interlop
  • The ADODB and Scripting Libraries

Course Format

  • This is a video-led course. You can preview some videos below.
  • This course includes practice exercises so you can practice as you learn.
  • This course is suitable for Windows users.

Course Certificate Included

This course includes an optional online quiz that will generate a course certificate upon completion.

14-Day Guarantee

We offer an unconditional, 14-day, full money-back guarantee, no questions asked. This is our way of ensuring you have complete confidence in your Stream Skill purchase. If you don’t learn, you don’t pay.

Why Trust Us?

Stream Skill is part of the Simon Sez IT family and has been in business 10+ years and taught over 500,000 students in that time. We’ve created over 90 software training courses, 5,000+ video tutorials, and we’ve helped thousands of people across around the world learn how to use Microsoft Excel. We’ve now created 10+ Microsoft Excel courses and continue to help people get to grips with spreadsheets.

What People Are Saying:

“I bought the course because I wanted to learn more about the use of Excel to assist me in my job. So far, I am very happy with the instructions. They are very detailed and easy to follow. I am able to pause to make notes and rewind if needed. I have used Excel with basic knowledge of the system, but I feel that when I am done with this course I will be able to create better spreadsheets and documents.” -Doris Santangelo

“I was able to learn a lot from this course and to do so at my own pace. I was able to review areas where I needed more time than someone more advanced than I. For the monetary investment, this is a great course for beginners.” -David F. Wilson

“I have been using Excel for some time and this course has shown me just how much I did not know or was unaware of. A terrific learning experience. Thanks for the opportunity!” -Allan Thomson

“I enjoyed to course and it was presented in an orderly fashion with incremental information that gave an intuitive feel to the progression. Thank you.” -John Brown

“Course is well done and since you can go back and review at any time or after the course is done is helpful for us slow learners.” -Rick Clarke


Your Instructor


Simon Sez IT
Simon Sez IT
Simon Sez IT makes business and technical software simple to learn.

Our most important goal is to help learners build and strengthen your software skills. We focus on simplicity but explain things in the detail they deserve. Simon Sez IT subject matter experts bring passion, knowledge and practical insights to video-based courses and practice exercises – all designed to help learners immediately apply your new knowledge and master your learning goals.

This is why more than a million learners have relied on Simon Sez IT since 2008.

Courses Included with Purchase



Essential VBA Training for Excel - Automate Repetitive Tasks
Learn Microsoft VBA to automate your time-consuming procedures in Excel.
Simon Sez IT
$50
VBA Intermediate Training: Discover Excel Automation Secrets
VBA for Excel Intermediate Instruction - Become the Office VBA for Excel Expert & a Master of Productivity
Simon Sez IT
$50
Microsoft Excel 2019 - Advanced Course
Microsoft Excel 2019 - Advanced Course
Simon Sez IT
$19
Power Pivot, Power Query & DAX in Excel
Analyze data at scale with these advanced Excel functions.
Simon Sez IT
$75

Original Price: $194


Frequently Asked Questions


What if I am unhappy with the course?
If you are unsatisfied with your purchase, contact us in the first 14 days and we will give you a prompt and full refund.
How long do I have access to the course?
After purchasing a course, you have unlimited access to this course for as long as you like - across any and all devices you own. Active memberships have access to all courses while they membership is active.
When does the course start and finish?
The course starts now and never ends! It is a completely self-paced online course - you decide when you start and when you finish.
Will your videos work with iPhone, iPads, and Android devices?
All of our courses are compatible with iPhones and iPads and most Android devices. If you are looking to confirm that it works for you, feel free to view the free preview videos offered for each course.
Will your videos work with Mac computers?
All of our courses are compatible with both Windows (PC) and Mac computers
What if I have questions or problems while I am watching my tutorial?
Should you have any problems using the system, we offer free technical support to customers. Just send an email to [email protected] and we will respond promptly.
Do you offer Certificates of Completion?
We offer 2 types of Certificate. The first applies to all courses and is awarded on completing 100% of the course. The second is for courses that include an online quiz (currently over 80% of our courses). The Certificates of Completion are offered as part of the online test/quiz, which accompanies the course. You will need a passing grade of 70% in order to receive a Certificate. The quizzes are based solely on course content.
Do you offer a subscription option?
Yes, we offer a monthly or annual membership. Any monthly or annual subscription includes unlimited access to all StreamSkill.com courses including new courses released while your subscription is active. Click here http://streamskill.com/course/streamskill-membership/ to get additional details about the Ultimate Training Library membership.
Do you provide any group discounts?
Yes, we offer group discounts or multiple users. Contact [email protected] for more information.
Do you offer discounts for non-profits or educational institutions?
Yes, we offer 20% off discounts to non-profit, educational, and government agencies. Contact [email protected] for more information.
Can I interact with others who are taking the same course?
Yes, you can interact with others by using the discussion section offered for each course.
How long have you been in business?
We started our company in 2008 with our first course for Excel 2007. Since that time, our company has published over 80 courses, with tens of thousands of satisfied customers in over 180 countries.

Get started now!