The HUGE Excel Bundle: Beginner, Advanced, VBA

10 Courses - Master Excel at your own pace 2013 - 2019 editions

Huge Excel Bundle

Learn Microsoft Excel 2013, 2016 and 2019/365 From the Basics to VBA with this Huge 10-Course Bundle

  • Includes courses: Microsoft Excel - Beginners, Microsoft Excel 2019 Advanced, VBA for Beginners & Intermediate VBA, Power Pivot, Power Query & DAX.
  • Also includes 2016 editions: The Excel 2016 Beginner Course, Learn Excel 2016 Intermediate Level - Beyond the Basics & The Excel 2016 Advanced Course
  • AND 2013 versions: Microsoft Excel 2013 Beginners/Intermediate Training, Learn Microsoft Excel 2013 - Advanced
  • Includes over 65 hours of high-quality, video training by experienced Excel experts
  • Practice as you learn using downloadable exercise files
  • Certificates of Completion with each course.
  • Covers Microsoft Excel 2013, 2016, 2019 and 365 editions

2019 Editions

Microsoft Excel 2019 - Beginners Course:

  • What's new in Excel 2019
  • Creating workbooks
  • Entering text, numbers and working with dates
  • Navigating workbooks
  • Page setup and print options
  • Working with rows, columns and cells
  • Cut, Copy and Paste
  • Introduction to functions and formulas
  • Formatting in Excel, including formatting cells and numbers
  • Creating charts and graphs
  • Sorting and Filtering
  • Introduction to PivotTables
  • Logical and lookup formulas - the basics

Microsoft Excel 2019 - Advanced Course:

  • 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 awesome 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

2016 & 2013 courses follow a similar structure to the above


Power Pivot

Power Pivot, Power Query & DAX

  • 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 Editions

VBA for Beginners

  • Introduction to VBA as a language (syntax and keywords)
  • How to automate repetitive tasks
  • Macros, sub routines 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

  • These are video-led courses. You can preview some videos by clicking on the individual courses below.
  • These courses includes practice exercises so you can practice as you learn.
  • These courses are suitable for Windows users.

Course Certificate Included

Each 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



Microsoft Excel 2016 for Beginners: Learn the Essentials
Learn the essentials of Microsoft Excel 2016 in easy to follow steps
Simon Sez IT
$100
Essential VBA Training for Excel - Automate Repetitive Tasks
Learn Microsoft VBA to automate your time-consuming procedures in Excel.
Simon Sez IT
$50
Learn Microsoft Excel 2013 - Advanced
Insider Method: Learn Advanced Techniques for Microsoft Excel 2013 Fast - Without Lectures, Books, or Night Classes
Simon Sez IT
$97
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 2013 Beginners/Intermediate Training
The Fastest Way to Learn Microsoft Excel 2013 Inside and Out - On Your Schedule
Simon Sez IT
$97
Microsoft Excel 2016 Advanced Training Master Class
The ultimate next step for anyone interested in supercharging their MS Excel and data analysis skills
Simon Sez IT
$100
Microsoft Excel 2019 - Advanced Course
Microsoft Excel 2019 - Advanced Course
Simon Sez IT
$100
Microsoft Excel 2019 - Beginners Course
Learn the Essentials of Microsoft Excel 2019/365
Simon Sez IT
$100
Learn Excel 2016 Intermediate Level - Beyond the Basics
If you already know the basics of Excel, this is the intermediate knowledge that will help you become an Excel power user.
Simon Sez IT
$50
Power Pivot, Power Query & DAX in Excel
Analyze data at scale with these advanced Excel functions.
Simon Sez IT
$75

Original Price: $819


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.
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 120 courses, with tens of thousands of satisfied customers in over 180 countries.

Get started now!