The Ultimate Microsoft Excel Mastery Bundle

This bundle includes practice exercises, downloadable files, and By the end of this training, you will be able to clean, summarize, and analyze data easily, as well as create PivotTables, charts, macros, and so much more.

We'll take you on a no-nonsense journey to learn specific functions, formulas, and tools that Excel has to help conduct business or data analysis. We'll also look at three advanced Excel features: Power Pivot, Power Query, and DAX. This suite of Excel functions allows you to manipulate, analyze, and evaluate millions of rows of data from Excel or other databases.

This ultimate Excel course bundle is designed for students of all levels. If you are brand new to Microsoft Excel, this course can get you started on your journey. If you already have a good understanding of Excel, you can further your skills with the more advanced courses in this bundle. This is the only Excel training you are ever going to need.

All courses include practice exercises and follow-along instructor files so you can immediately apply what you learn.

What's included?

Excel 2021 for Beginners

Become familiar with what’s new in Excel 2021
Navigate the Excel 2021 interface
Utilize useful keyboard shortcuts to increase productivity
Create your first Excel spreadsheet
Use basic and intermediate Excel formulas and functions
Effectively apply formatting to cells and use conditional formatting
Use Excel lists and master sorting and filtering
Work efficiently by using the cut, copy, and paste options
Link to other worksheets and workbooks
Analyze data using charts
Insert pictures in a spreadsheet
Work with views, zooms, and freezing panes
Set page layout and print options
Protect and share workbooks
Save your workbook in different file formats

Excel 2021 Intermediate

Designing better spreadsheets and controlling user input
How to use logical functions to make better business decisions
Constructing functional and flexible lookup formulas
How to use Excel tables to structure data and make it easy to update
Extracting unique values from a list
Sorting and filtering data using advanced features and new Excel formulas
Working with date and time functions
Extracting data using text functions
Importing data and cleaning it up before analysis
Analyzing data using PivotTables
Representing data visually with PivotCharts
Adding interactions to PivotTables and PivotCharts
Creating an interactive dashboard to present high-level metrics
Auditing formulas and troubleshooting common Excel errors
How to control user input with data validation
Using WhatIf analysis tools to see how changing inputs affect outcomes.

Excel 2021 Advanced

Using the NEW dynamic array functions to perform tasks
Creating advanced and flexible lookup formulas
Using statistical functions to rank data and to calculate the MEDIAN and MODE
Producing accurate results when working with financial data using math functions
Creating variables and functions with LET and LAMBDA
Analyzing data with advanced PivotTable and PivotChart hacks
Creating interactive reports and dashboards by incorporating form controls
Importing and cleaning data using Power Query
Predicting future values using forecast functions and forecast sheets
Recording and running macros to automate repetitive tasks
Understanding and making minor edits to VBA code
Combining functions to create practical formulas to complete specific tasks.

Excel for Business Analysts

How to merge data from different sources using VLOOKUP, HLOOKUP, INDEX MATCH, and XLOOKUP
How to use IF, IFS, IFERROR, SUMIF, and COUNTIF to apply logic to your analysis
How to split data using text functions SEARCH, LEFT, RIGHT, MID
How to standardize and clean data ready for analysis
About using the PivotTable function to perform data analysis
How to use slicers to draw out information
How to display your analysis using Pivot Charts
All about forecasting and using the Forecast Sheets
Conducting a Linear Forecast and Forecast Smoothing
How to use Conditional Formatting to highlight areas of your data
All about Histograms and Regression
How to use Goal Seek, Scenario Manager, and Solver to fill data gaps

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

PivotTables for Beginners

How to clean and prepare your data
Creating a basic PivotTable
Using the PivotTable fields pane
Adding fields and pivoting the fields
Formatting numbers in PivotTable
Different ways to summarize data
Grouping PivotTable data
Using multiple fields and dimension
The methods of aggregation
How to choose and lock the report layout
Applying PivotTable styles
Sorting data and using filters
Create pivot charts based on PivotTable data
Selecting the right chart for your data
Apply conditional formatting
Add slicers and timelines to your dashboards
Adding new data to the original source dataset
Updating PivotTables and charts

Advanced PivotTables

How to do a PivotTable (a quick refresher)
How to combine data from multiple worksheets for a PivotTable
Grouping, ungrouping, and dealing with errors
How to format a PivotTable, including adjusting styles
How to use the Value Field Settings
Advanced Sorting and Filtering in PivotTables
How to use Slicers, Timelines on multiple tables
How to create a Calculated Field
All about GETPIVOTDATA
How to create a Pivot Chart and add sparklines and slicers
How to use 3D Maps from a PivotTable
How to update your data in a PivotTable and Pivot Chart
All about Conditional Formatting in a PivotTable
How to create amazing-looking dashboards

Interactive Excel Dashboards

About Dashboard architecture and inspiration
How to prepare data for analysis (cleaning data)
Useful formulas for creating dashboards in Excel
How to create and edit Pivot Tables in Excel
How to create Pivot Charts from Pivot Tables
Advanced chart techniques in Excel
How to add interactive elements (form controls) into your dashboards
How to create a Sales Dashboard from scratch
How to create an HR Dashboard from scratch

This bundle includes:

60+ hours of video tutorials
550+ individual video lectures
Course and exercise files to follow along
Certificate of completion

What's inside

Learning objectives

Become familiar with what’s new in excel 2021 and navigate the excel 2021 interface
Create your first excel spreadsheet and use basic and intermediate excel formulas and functions
Utilize useful keyboard shortcuts to increase productivity
Linking to other worksheets & workbooks and protecting & sharing workbooks
How to use logical functions to make better business decisions
Creating an interactive dashboard to present high-level metrics
Using the new dynamic array functions to perform tasks
Recording and running macros to automate repetitive tasks
Predicting future values using forecast functions and forecast sheets
Using statistical functions to rank data and to calculate the median and mode
Understanding and making minor edits to vba code
How to merge data from different sources using vlookup, hlookup, index match, and xlookup
How to standardize and clean data ready for analysis in excel
Conducting a linear forecast and forecast smoothing in excel
All about histograms and regression in excel
How to use goal seek, scenario manager, and solver to fill data gaps in excel
Learn to unlock advanced excel tools power query and power pivot
Analyze huge buckets of data to make informed business decisions
How to create pivottables

Grouping and ungrouping pivottable data and dealing with errors
Creating pivotcharts and adding sparklines and slicers
Adding slicers and timelines and applying them to multiple tables
Combining data from multiple worksheets for a pivottable
All about the getpivotdata function
How to use 3d maps from a pivottable
Updating your data in a pivottable and pivotchart
About dashboard architecture and inspiration
How to prepare data for analysis (cleaning data)
Useful formulas for creating dashboards in excel
How to create and edit pivot tables in excel
How to create pivot charts from pivot tables
Advanced chart techniques in excel
How to add interactive elements (form controls) into your dashboards
How to create a sales dashboard from scratch
How to create an hr dashboard from scratch
Show more
Show less

Become familiar with what’s new in excel 2021 and navigate the excel 2021 interface
Create your first excel spreadsheet and use basic and intermediate excel formulas and functions
Utilize useful keyboard shortcuts to increase productivity
Linking to other worksheets & workbooks and protecting & sharing workbooks
How to use logical functions to make better business decisions
Creating an interactive dashboard to present high-level metrics
Using the new dynamic array functions to perform tasks
Recording and running macros to automate repetitive tasks
Predicting future values using forecast functions and forecast sheets
Using statistical functions to rank data and to calculate the median and mode
Understanding and making minor edits to vba code
How to merge data from different sources using vlookup, hlookup, index match, and xlookup
How to standardize and clean data ready for analysis in excel
Conducting a linear forecast and forecast smoothing in excel
All about histograms and regression in excel
How to use goal seek, scenario manager, and solver to fill data gaps in excel
Learn to unlock advanced excel tools power query and power pivot
Analyze huge buckets of data to make informed business decisions
How to create pivottables
Grouping and ungrouping pivottable data and dealing with errors
Creating pivotcharts and adding sparklines and slicers
Adding slicers and timelines and applying them to multiple tables
Combining data from multiple worksheets for a pivottable
All about the getpivotdata function
How to use 3d maps from a pivottable
Updating your data in a pivottable and pivotchart
About dashboard architecture and inspiration
How to prepare data for analysis (cleaning data)
Useful formulas for creating dashboards in excel
How to create and edit pivot tables in excel
How to create pivot charts from pivot tables
Advanced chart techniques in excel
How to add interactive elements (form controls) into your dashboards
How to create a sales dashboard from scratch
How to create an hr dashboard from scratch
Show more
Show less

Syllabus

Microsoft Excel 2021 for Beginners: Introduction

Course Introduction

WATCH ME: Essential Information for a Successful Training Experience

Downloadable Course Transcript

Traffic lights

Read about what's good

what should give you pause

and possible dealbreakers

Covers Power Query, Power Pivot, and DAX, which are essential tools for business intelligence and data analysis, enabling users to manipulate and analyze large datasets

Starts with Excel 2021 basics and progresses to advanced topics like Power Query and VBA, providing a comprehensive learning path for users with varying levels of experience

Teaches skills in data cleaning, summarization, and analysis, which are highly relevant for professionals who need to extract insights from data and make informed decisions

Includes practice exercises and downloadable files, allowing learners to immediately apply what they learn and reinforce their understanding of Excel concepts and techniques

Explores advanced PivotTable and PivotChart techniques, which are valuable for creating interactive reports and dashboards to visualize and communicate data insights effectively

Focuses on Excel 2021, so learners may need to upgrade to the latest version of Microsoft Excel to take full advantage of the features and functionalities taught

Reviews summary

Comprehensive excel mastery bundle

According to inferred student feedback based on the course description, this bundle offers extensive coverage from Excel basics through advanced topics like Power Query and DAX. Learners appreciate the inclusion of useful practice files for hands-on learning. The course is described as catering to all levels of Excel users, although some infer that depth may vary across the wide range of subjects. Specifically, the coverage of VBA is noted as basic , limited to minor edits.

Designed for beginners up to advanced learners.

"I started as a beginner and found the early modules helpful."

"Even with some Excel knowledge, I found value in the intermediate and advanced sections."

"It's structured well enough that you can likely find content relevant to your level."

Course includes files for hands-on practice.

"Having the practice files makes it much easier to follow along and learn."

"I can immediately apply what I learn using the provided exercise files."

"The downloadable files are a key part of the learning process."

A broad range of Excel topics included.

"I appreciate that this bundle covers so many topics, from basic to advanced."

"It's great to see modules on Power Query, DAX, and dashboards all in one place."

"This seems like a truly comprehensive Excel training package."

Coverage of VBA is limited to minor edits.

"The description notes only minor edits to VBA code are covered."

"If you need to write macros from scratch or do complex VBA, look elsewhere."

"The focus seems to be on functions and tools, not deep programming."

Some advanced topics may lack deep coverage.

"While broad, I suspect some very complex topics might not be covered in extreme detail."

"It covers a lot, but I might need other resources for specific advanced needs."

"As an advanced user, I wonder if certain modules will be challenging enough."

Activities

Be better prepared before your course. Deepen your understanding during and after it. Supplement your coursework and achieve mastery of the topics covered in The Ultimate Microsoft Excel Mastery Bundle - 8 Courses with these activities:

Review Basic Excel Functions

Show steps

Reinforce your understanding of fundamental Excel functions before diving into more complex topics. This will make learning advanced formulas easier.

Browse courses on SUM

Show steps

Identify the most common Excel functions (SUM, AVERAGE, COUNT, MIN, MAX).
Practice using these functions with sample datasets.
Review the syntax and arguments for each function.

Brush up on Data Analysis Concepts

Show steps

Revisit key data analysis concepts to better understand how Excel can be used for business intelligence. This will provide a solid foundation for the course.

Browse courses on Data Analysis

Show steps

Review basic statistical concepts like mean, median, mode, and standard deviation.
Familiarize yourself with different types of data visualizations (charts, graphs).
Understand the importance of data cleaning and preparation.

Review 'Excel Data Analysis For Dummies'

Show steps

Supplement your learning with a comprehensive guide to data analysis in Excel. This book provides practical examples and step-by-step instructions.

View Putting Knowledge to Work on Amazon

Show steps

Read the chapters related to data cleaning and preparation.
Work through the examples provided in the book using your own datasets.
Focus on the sections covering PivotTables and data visualization.

Four other activities

Expand to see all activities and additional details

Show all seven activities

Practice PivotTable Creation

Show steps

Master PivotTable creation to efficiently summarize and analyze data. This is a core skill for data analysis in Excel.

Browse courses on Pivot Tables

Show steps

Find several datasets online (e.g., from Kaggle or government websites).
Create PivotTables to summarize the data in different ways.
Experiment with different PivotTable layouts and features.

Build an Interactive Dashboard

Show steps

Create an interactive dashboard to showcase your data analysis skills. This project will solidify your understanding of PivotTables, charts, and form controls.

Show steps

Choose a dataset relevant to your interests (e.g., sales data, website traffic).
Create PivotTables to summarize key metrics.
Design charts to visualize the data.
Add interactive elements like slicers and form controls.

Review 'M Is for (Data) Monkey: A Guide to the M Language in Excel Power Query'

Show steps

Deepen your understanding of Power Query with a dedicated guide to the M language. This book will help you automate data cleaning and transformation tasks.

View M Is for (Data) Monkey: A Guide to the M... on Amazon

Show steps

Read the introductory chapters to understand the basics of the M language.
Work through the examples provided in the book, focusing on data transformation techniques.
Apply what you learn to automate data import and cleaning tasks in Excel.

Automate a Repetitive Task with Macros

Show steps

Automate a repetitive task using Excel macros to improve efficiency. This project will help you understand VBA code and macro recording.

Browse courses on Excel Macros

Show steps

Identify a repetitive task you perform regularly in Excel (e.g., formatting data, creating reports).
Record a macro to automate the task.
Edit the VBA code to customize the macro and add error handling.
Test the macro thoroughly to ensure it works correctly.

Career center

Learners who complete The Ultimate Microsoft Excel Mastery Bundle - 8 Courses will develop knowledge and skills that may be useful to these careers:

Data Analyst

A data analyst uses data to understand trends and help organizations make better decisions. This course is particularly useful because it provides a strong foundation in cleaning, summarizing, and analyzing data using tools like PivotTables, which are essential for a data analyst. Furthermore, the course includes advanced Excel features such as Power Pivot, Power Query, and DAX, allowing for the manipulation of large datasets. These tools are used by data analysts to gather business intelligence from raw data. The course helps you build crucial skills to pursue a career as a data analyst.

See salaries and explore the career path for Data Analyst

Business Analyst

A business analyst examines business processes, identifies areas for improvement, and recommends solutions. This course helps build a foundation in analyzing data, creating PivotTables, and presenting findings. The course includes training on advanced Excel features like Power Query and Power Pivot which are useful for a business analyst to draw insights from large datasets. The course emphasizes the use of Excel functions, formulas, and tools for business analysis, which directly supports the needs of a business analyst. This training can be vital for anyone wanting to pursue a business analyst role.

See salaries and explore the career path for Business Analyst

Financial Analyst

A financial analyst helps companies make investment decisions by analyzing financial data. This course supports the needs of a financial analyst by teaching how to use Excel to manipulate, analyze, and interpret financial data. The course includes coverage of advanced Excel features like Power Pivot and DAX, which are useful for analyzing vast datasets. This course also features training on forecasting and financial modeling using Excel. A financial analyst will apply techniques learned in this course in their everyday work. This course provides relevant skills to advance your career as a financial analyst.

See salaries and explore the career path for Financial Analyst

Operations Analyst

An operations analyst aims to improve a company's processes by creating strategies. This course will be helpful to someone in this career due to its extensive coverage of Excel tools for data analysis. The course includes training on data manipulation, summarization, and analysis, all of which are used by operations analysts when making decisions. This course provides practice in the creation of effective dashboards that can display trends to improve operations. Any prospective operations analyst should enroll in this course to build a skill set that is beneficial in the role.

See salaries and explore the career path for Operations Analyst

Market Research Analyst

A market research analyst studies market conditions to examine the potential sales of a product or service. Excel is a tool market research analysts regularly use to analyze survey data, sales figures, and consumer behavior. This course teaches essential Excel skills such as data cleaning, summarizing, and analysis. The course also includes how to create PivotTables and charts. These are essential tools a market research analyst uses to visualize patterns in data. This course helps build skills needed to pursue a career in market research analysis.

See salaries and explore the career path for Market Research Analyst

Management Consultant

A management consultant advises organizations on how to improve their effectiveness and efficiency. This course will be useful to a management consultant who needs to analyze data, build dashboards, and present insights using Microsoft Excel. The course teaches essential Excel functions and advanced tools like Power Query and Power Pivot that can be applied to complex problem solving. Management consultants rely upon data and the skills learned in this training. Therefore, this course is valuable for anyone pursuing a path in management consulting.

See salaries and explore the career path for Management Consultant

Project Manager

A project manager is responsible for the planning, execution, and closure of specific projects. This course helps a project manager by providing tools for data analysis, project tracking, and reporting using Microsoft Excel. Project managers can use the techniques learned here to create charts and tables to visualize project progress, and also use what-if analysis. The course teaches how to import data, clean it, and create interactive dashboards, which are useful for tracking and communication. This course will be useful for any project manager.

See salaries and explore the career path for Project Manager

Statistician

A statistician gathers, analyzes and interprets data in order to solve problems via quantitative analysis. While specialized statistical software is typically used, Excel can be a helpful tool for a statistician for data exploration, analysis, and visualization. This course offers training in a variety of statistical functions, including how to calculate the median and mode, which are helpful for a statistician. The course includes coverage of how to interpret charts and graphs, which can help when preparing results. For these reasons, this course may serve as a tool in a statistician's toolkit.

See salaries and explore the career path for Statistician

Accountant

An accountant manages financial records, typically tracking income and expenses and ensuring compliance with regulations. While accountants often rely on specialized accounting software, they also use Excel for data analysis. This course helps an accountant by offering training in data cleaning, summarizing, and analysis through the use of PivotTables and other Excel tools. The course provides training on formulas, functions, and conditional formatting all of which are essential for the work of an accountant. This course may be useful for someone working as an accountant.

See salaries and explore the career path for Accountant

Auditor

An auditor examines an organization's financial records and processes to ensure accuracy and compliance. This course can be helpful for an auditor, since it includes training on data analysis using tools like PivotTables. An auditor may use this skill to summarize large datasets and identify anomalies. The course includes training on techniques to audit formulas and troubleshoot errors, which are useful for an auditor. For these reasons, this course may prove beneficial for an auditor.

See salaries and explore the career path for Auditor

Actuary

An actuary assesses and manages financial risk by applying mathematics, statistics, and financial theory. Although actuaries often use specialized software, Excel can be useful for data manipulation and analysis. This course's coverage of data manipulation, forecasting, and statistical functions, may be helpful to an actuary. The course includes instruction on how Excel can be used to analyze data, predict future values, and perform statistical analysis. A professional working as an actuary may find this course useful.

See salaries and explore the career path for Actuary

Researcher

A researcher conducts investigations to answer a question or solve a problem. This course may be useful to a researcher who wants to use Excel to organize, analyze, and visualize data. The course covers data cleaning, data organization, and the use of PivotTables. The course also covers data visualization via charting. These skills can help a researcher to analyze their own data. This course may be helpful for someone working as a researcher.

See salaries and explore the career path for Researcher

Sales Manager

A sales manager leads a sales team and develops strategies to achieve sales goals. Excel can be useful to a sales manager for tracking sales data, analyzing performance, and creating reports. This course may be helpful for a sales manager by teaching data analysis, visualization, and creating dashboards. With this knowledge, a sales manager can track his staff more effectively using data. This course may serve as a useful tool for a sales manager.

See salaries and explore the career path for Sales Manager

Human Resources Specialist

A human resources specialist is a professional who focuses on administering an organization's human resource policies and procedures, including hiring, benefits, and employee relations. This course may be useful to an HR professional by providing training in analyzing HR data, such as employee performance and compensation data. This course includes instruction on using PivotTables and creating interactive dashboards, which is important for communicating HR metrics. This course may be helpful for an HR professional.

See salaries and explore the career path for Human Resources Specialist

Technical Writer

A technical writer prepares instruction manuals, how to guides, journal articles, and other documents that explain complex and technical information. While technical writers do not use Excel daily, they may need to work with data or spreadsheets during the course of a project. This course may be useful to a technical writer who wishes to learn how to clean data, manipulate data, and use charts to present their information. Therefore, this course may be helpful to a technical writer.

See salaries and explore the career path for Technical Writer

Reading list

We've selected two books that we think will supplement your learning. Use these to develop background knowledge, enrich your coursework, and gain a deeper understanding of the topics covered in The Ultimate Microsoft Excel Mastery Bundle - 8 Courses.

M Is for (Data) Monkey

Save

Is an excellent resource for mastering Power Query and the M language. It provides a deep dive into data transformation and cleaning techniques. It is particularly useful for those who want to automate data import and preparation processes. This book is more valuable as additional reading to expand on the Power Query sections of the course.

M Is for (Data) Monkey: A Guide to the M Language...

Kindle Edition

Putting Knowledge to Work

Save

Provides a comprehensive overview of data analysis techniques using Excel. It covers a wide range of topics, from basic calculations to advanced statistical analysis. It is particularly useful for beginners who want to learn how to use Excel for data analysis. This book can serve as a useful reference tool throughout the course.

Putting Knowledge to Work

Paperback

Check price

Putting Knowledge to Work

Kindle Edition

Check price