The Huge Microsoft Excel Training Bundle - Beginner to VBA

6 Courses in 1! Beginner to advanced Excel training from the Excel experts - Simon Sez IT

4.61 (109 reviews)

Udemy

platform

English

language

Microsoft

What you will learn

How to get started using Microsoft Excel as a complete beginner

How create, save, and open a workbook.

How to use Mathematic Functions (SUM, AVERAGE, MIN, MAX)

Complete data entry, cell formatting, working with multiple worksheets and the “Ribbon” interface.

The basics of entering and editing data in a workbook.

Discover how to format dates and numbers.

How to use Logical Functions (IF, COUNTIF, SUMIF)

Effectively use autofill and flashfill so you are more productive.

Discover the essentials of using fomulas and functions.

How to use Lookup Functions (VLOOKUP, XLOOKUP, HLOOKUP, INDEX MATCH)

How to rename, insert, move, and reference an Excel worksheet.

The Huge Microsoft Excel Training Bundle - Beginner to VBA

What you will learn

How to get started using Microsoft Excel as a complete beginner

How create, save, and open a workbook.

How to use Mathematic Functions (SUM, AVERAGE, MIN, MAX)

Complete data entry, cell formatting, working with multiple worksheets and the “Ribbon” interface.

The basics of entering and editing data in a workbook.

Discover how to format dates and numbers.

How to use Logical Functions (IF, COUNTIF, SUMIF)

Effectively use autofill and flashfill so you are more productive.

Discover the essentials of using fomulas and functions.

How to use Lookup Functions (VLOOKUP, XLOOKUP, HLOOKUP, INDEX MATCH)

How to rename, insert, move, and reference an Excel worksheet.

Discover how to create charts and graphs

Learn practical methods to sort and filter your data

How to protect and secure your Excel data

How to Clean and Prepare your Data in Excel

How to create Pivot Tables

Using the Fields pane and adding Fields and Calculated Fields

How to create Pivot Charts and add sparklines and slicers

Selecting the right Chart to present your data

Adding Slicers and Timelines and how to apply on multiple tables

How to combine data from multiple worksheets for a PivotTable

All about GETPIVOTDATA

How to use 3D Maps from a PivotTable

Adding new Data to the original source dataset

How to update your data in a PivotTable and Pivot Chart

All about Conditional Formatting in a PivotTable

Learn to unlock advanced Excel formulas

Create multi-dependent dynamic drop-down lists in Excel

Perform a 2-way lookup in Excel

Automate repetitive tasks in Excel using Macros

How to edit Macros in the VBA Editor

How to write your own macro from scratch