The Ultimate Microsoft Excel Mastery Bundle - 8 Courses
Master Microsoft Excel with this huge-value beginner to advanced eight-course bundle and become an Excel power user!
4.59 (2534 reviews)

15 181
students
66.5 hours
content
Mar 2024
last update
$99.99
regular price
What you will learn
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
Loading charts...
Comidoc Review
Our Verdict
The Ultimate Microsoft Excel Mastery Bundle - 8 Courses offers learners exceptional value with its wide-ranging curriculum and comprehensive coverage of Excel functionalities. Deborah Ashby's teaching expertise results in a well-paced, engaging learning experience, despite some minor flaws. This expansive course is perfect for beginners or intermediate users wanting to master all aspects of Microsoft Excel.
What We Liked
- The course offers a comprehensive coverage of Microsoft Excel, from basics to advanced features, in a single package.
- Deborah Ashby's teaching style is engaging, clear, and supportive, ensuring that learners remain engaged throughout the course.
- Includes practical exercises and downloadable resources for hands-on experience and reinforcement of concepts.
- Covers various advanced topics like dynamic arrays, macros, statistical functions, and data analysis tools.
Potential Drawbacks
- Some repetition of content occurs across the eight courses, which may seem redundant for more experienced users.
- The course might be overwhelming for those solely interested in specific functionalities, as it covers a broad spectrum.
- A few course files related to the FILTER function have discrepancies; however, corrected versions are available.
- Some advanced topics could benefit from a stronger emphasis on real-life applications and industry-specific examples.
Related Topics
4920048
udemy ID
09/10/2022
course created date
09/11/2022
course indexed date
ANUBHAV JAIN
course submited by