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)
Udemy
platform
English
language
Microsoft
category
instructor
The Ultimate Microsoft Excel Mastery Bundle - 8 Courses
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.
4920048
udemy ID
09/10/2022
course created date
09/11/2022
course indexed date
ANUBHAV JAIN
course submited by