The Ultimate Microsoft Excel Mastery Bundle – 8 Courses is a top-rated Udemy course taught by Simon Sez IT — with over 15132+ students enrolled since it launched.
Master Microsoft Excel with this huge-value beginner to advanced eight-course bundle and become an Excel power user!
Don’t wait! This special offer won’t last long.
Click the button below to Get up to 100% OFF the regular price.
(The discount will be applied automatically at checkout — no code needed!)
Hurry — this discount on The Ultimate Microsoft Excel Mastery Bundle – 8 Courses won’t be around forever. Take action now!
Why enroll in the The Ultimate Microsoft Excel Mastery Bundle – 8 Courses Udemy Course?
- Udemy gives you access to over 250,000 courses and 85,000 expert instructors worldwide.
- Courses are led by experienced professionals dedicated to delivering a high-quality learning experience.
- Many of Udemy’s most popular courses have hundreds of thousands of students enrolled.
- Udemy offers online coupons, promo codes and voucher for the majority of its courses.
The Ultimate Microsoft Excel Mastery Bundle – 8 Courses Udemy Promotion code
Microsoft Excel 2021 for Beginners: Getting Started in Excel 2021
Microsoft Excel 2021 for Beginners: Creating You First Excel Spreadsheet
Microsoft Excel 2021 for Beginners: Introduction to Excel Formulas and Functions
Microsoft Excel 2021 for Beginners: Using Named Ranges
Microsoft Excel 2021 for Beginners: Formatting Numbers and Cells
Microsoft Excel 2021 for Beginners: Formatting Worksheets
Microsoft Excel 2021 for Beginners: Working with Excel Lists
Microsoft Excel 2021 for Beginners: Moving and Linking to Data
Microsoft Excel 2021 for Beginners: An Introduction to Intermediate Formulas
Microsoft Excel 2021 for Beginners: Analyzing Data with Charts
Microsoft Excel 2021 for Beginners: Conditional Formatting
Microsoft Excel 2021 for Beginners: Inserting Items into a Spreadsheet
Microsoft Excel 2021 for Beginners: Working with Views and Zoom
Microsoft Excel 2021 for Beginners: Page Layout and Print Options
Microsoft Excel 2021 for Beginners: Finalizing the Spreadsheet
Microsoft Excel 2021 for Beginners: Course Close
Microsoft Excel 2021 Intermediate: Introduction
Microsoft Excel 2021 Intermediate: Designing Better Spreadsheets
Microsoft Excel 2021 Intermediate: Making Decisions with Logical Functions
Microsoft Excel 2021 Intermediate: Looking Up Information
Microsoft Excel 2021 Intermediate: Advanced Sorting and Filtering
Microsoft Excel 2021 Intermediate: Working with Date and Time
Microsoft Excel 2021 Intermediate: Preparing Data for Analysis
Microsoft Excel 2021 Intermediate: PivotTables
Microsoft Excel 2021 Intermediate: Pivot Charts
Microsoft Excel 2021 Intermediate: Adding Interaction to PivotTables and Charts
Microsoft Excel 2021 Intermediate: Interactive Dashboards
Microsoft Excel 2021 Intermediate: Formula Auditing
Microsoft Excel 2021 Intermediate: Data Validation
Microsoft Excel 2021 Intermediate: WhatIf Analysis Tools
Microsoft Excel 2021 Intermediate: Course Close
Microsoft Excel 2021 Advanced: Introduction
Microsoft Excel 2021 Advanced: Dynamic Arrays
Microsoft Excel 2021 Advanced: Advanced Lookup and Reference Functions
Microsoft Excel 2021 Advanced: Statistical Functions
Microsoft Excel 2021 Advanced: Math Functions
Microsoft Excel 2021 Advanced: New Functions – LET and LAMBDA
Microsoft Excel 2021 Advanced: Advanced PivotTables and Pivot Charts
Microsoft Excel 2021 Advanced: Form Controls
Microsoft Excel 2021 Advanced: Working with Power Query
Microsoft Excel 2021 Advanced: Forecasting
Microsoft Excel 2021 Advanced: Macros and VBA
Microsoft Excel 2021 Advanced: Practical Excel – Advanced Formulas
Microsoft Excel 2021 Advanced: Course Close
Excel for Business Analysts: Introduction
Excel for Business Analysts: The Basics
Excel for Business Analysts: Merging and Looking Up Data
Excel for Business Analysts: Making Better Decisions with IF
Excel for Business Analysts: Preparing Data for Analysis
Excel for Business Analysts: PivotTables
Excel for Business Analysts: Visualizing Data with Charts
Excel for Business Analysts: Forecasting
Excel for Business Analysts: Additional Useful Tools in Excel
Excel for Business Analysts: WhatIf Analysis
Excel for Business Analysts: Course Close
PowerPivot, PowerQuery, DAX: Introduction
PowerPivot, PowerQuery, DAX: Getting Started with Power Query
PowerPivot, PowerQuery, DAX: Useful Power Query Features
PowerPivot, PowerQuery, DAX: Creating the Data Model
PowerPivot, PowerQuery, DAX: Introduction to DAX
PowerPivot, PowerQuery, DAX: More DAX Measures
PowerPivot, PowerQuery, DAX: Using PivotTables and Slicers
PowerPivot, PowerQuery, DAX: Closing
Pivot Tables for Beginners: Introduction
Pivot Tables for Beginners: Preparing Data for Analysis
Pivot Tables for Beginners: The Importance of Excel Tables
Pivot Tables for Beginners: Creating a Basic Pivot Table Report
Pivot Tables for Beginners: Aggregation and Grouping
Pivot Tables for Beginners: Formatting Values
Pivot Tables for Beginners: Layout Options
Pivot Tables for Beginners: Formatting Pivot Tables
Pivot Tables for Beginners: Sorting and Filtering
Pivot Tables for Beginners: Creating Pivot Charts
Pivot Tables for Beginners: Formatting Pivot Charts
Pivot Tables for Beginners: Applying Conditional Formatting
Pivot Tables for Beginners: Updating Pivot Tables and Pivot Charts
Pivot Tables for Beginners: Course Close and Next Steps
Advanced PivotTables in Excel: Introduction
Advanced PivotTables in Excel: Importing Data
Advanced PivotTables in Excel: Preparing Data for Analysis
Advanced PivotTables in Excel: Creating and Manipulating PivotTables
Advanced PivotTables in Excel: Formatting PivotTables
Advanced PivotTables in Excel: Value Field Settings
Advanced PivotTables in Excel: Sorting and Filtering
Advanced PivotTables in Excel: Interacting with PivotTables
Advanced PivotTables in Excel: Calculations
Advanced PivotTables in Excel: Pivot Charts
Advanced PivotTables in Excel: Conditional Formatting
Advanced PivotTables in Excel: Dashboards
Advanced PivotTables in Excel: Course Close
Interactive Dashboard in Excel: Introduction
Interactive Dashboard in Excel: Dashboard Setup
Interactive Dashboard in Excel: Design Inspiration
Interactive Dashboard in Excel: Preparing Data for Analysis
Interactive Dashboard in Excel: Useful Excel Formulas
Interactive Dashboard in Excel: PivotTables and Pivot Charts
Interactive Dashboard in Excel: Advanced Chart Techniques
Interactive Dashboard in Excel: Interactive Elements – Form Controls
Interactive Dashboard in Excel: Sales Analysis Dashboard
Interactive Dashboard in Excel: HR Dashboard
Interactive Dashboard in Excel: Course Close
Additional Training
Microsoft Excel 2021/365 desktop version for Windows for the Excel 2021 courses
You’ll need a copy of Microsoft Excel that is compatible with the Power Pivot tool for the Power Pivot, Power Query & DAX course
The PivotTable courses were created using Excel 2019/365 for Windows. All of the code used in this course except for one property is compatible for Excel 2007, Excel 2010, Excel 2013, Excel 2016 and Excel 2019.
**This bundle includes practice exercises, downloadable files, and LIFETIME access**
Let us take you on a journey from being an Excel novice to an Excel expert with this amazing value 8-course training bundle. 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

