The Microsoft Excel Data Analysis Toolkit Bundle

Preview this course

In this course, we look at a number of advanced Excel techniques all aimed at helping you make sense of the numbers in your business. Each section in the course contains an exercise for practice and quiz. The course is created using Excel 2019/365 for Windows.

Unlimited access to 750+ courses.
Enjoy a Free Trial. Cancel Anytime.

- OR -

30-Day Money-Back Guarantee
Full Lifetime Access.
179 on-demand videos & exercises
Level: Intermediate
24hrs 59mins
Access on mobile, web and TV

What to know about this course

In this four-course bundle, we look at a number of advanced Excel techniques all aimed at helping you make sense of the numbers in your business.  In Excel for business analysts, you will learn to clean raw data and look at a number of tools and functions that can be used to conduct analysis. Finally, we move onto some more advanced techniques designed to aid forecasting and use existing data to predict future trends.

In Advanced Excel 2019, you will gain an in-depth understanding of more advanced Excel features that delve into high-level consolidation, analysis, and reporting of financial information. Advanced PivotTables starts with a PivotTable refresher and then goes on to discuss advanced sorting, slicers, timelines, calculated fields, pivot charts, and conditional formatting. In Advanced Formulas, learn the Excel formulas and tools that enable you to perform complex tasks and analyses.  Filtering a dataset, sorting using formulas, creating multi-dependent drop-down lists, 2-way look-ups, text extraction, dynamic chart titles, and XLOOKUP are a few of the exciting concepts covered in the course. 

By the end of the course, you will become an expert in data analysis with Excel.  You can find all the resources for the course at

Who's this course for?

The course is designed for those who want to automate Excel tasks or procedures, for users with basic knowledge of Excel 2019/365, and those upgrading from previous software versions and a foundation of Microsoft Excel. Also, those who are seeking to advance their Excel 2019/365 knowledge can benefit from this course.  This course was recorded using Excel 2019 and Excel 365. It is also relevant to those using other, recent versions of Microsoft Excel, including Excel 2013 and 2016.

What you'll learn

  • How to standardize and clean data ready for analysis in Excel.
  • How to format a PivotTable, including adjusting styles.
  • Create multi-dependent dynamic drop-down lists in Excel.
  • Learn all about histograms and regression in Excel.
  • Conduct a linear forecast and forecast smoothing in Excel.
  • Automate repetitive tasks in Excel using macros.

Key Features

  • Learn how to merge data from various sources using VLOOKUP, HLOOKUP, INDEX MATCH, and XLOOKUP.
  • Learn how to create amazing looking dashboards using PivotTables.
  • Learn how to use Goal Seek, Scenario Manager, and Solver to fill data gaps in Excel.

Course Curriculum

About the Author

Simon Sez IT

Simon Sez IT has offered technical courses for individuals, small businesses, and Fortune 500 companies since 2008, with thousands of employees who can benefit from the easy-to-learn and hands-on software training. It offers over 8,000 video tutorials on a range of software programs.  Simon Sez IT ensures stress-free eLearning and enhanced employee productivity—whether you implement new software or a technological upgrade in your work environment. With over 600,000 students from 180 countries, Simon Sez IT is the preferred online learning choice for individuals and businesses worldwide.

40% OFF! Unlimited Access to 750+ Courses. Redeem Now.