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.58 (2259 reviews)

Udemy

platform

English

language

Microsoft

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

The Ultimate Microsoft Excel Mastery Bundle - 8 Courses

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

Related Topics