# Zero to Hero in Microsoft Excel Complete Excel guide 2022

A Beginner’s Guide to Microsoft Excel – Learn Excel Charts, Spreadsheets, Formulas, Shortcuts, Macros and Tips & Tricks

4.5/5

## Zero to Hero in Microsoft Excel Complete Excel guide 2022

### What you’ll learn

A Beginner’s Guide to Microsoft Excel – Microsoft Excel, Learn Excel, Spreadsheets, Formulas, Shortcuts, Macros
Knowledge of all the essential Excel formulas
Become proficient in Excel data tools like Sorting, Filtering, Data validations and Data importing
Master Excel’s most popular lookup functions such as Vlookup, Hlookup, Index and Match
Harness full potential of Excel by creating Pivot tables with slicers
Make great presentations using the Conditional and Table formatting options
Visually enchant viewers using Bar charts, Scatter Plots, Histograms etc.
Increase your efficiency by learning how to create and use important Excel shortcuts
Explore fun and exciting use cases of Excel

### Requirements

You will need a PC with any version of Excel installed in it

### Overview

Section 1: Introduction

Lecture 1 Introduction

Section 2: Excel Basics

Lecture 2 Getting started with Excel

Lecture 3 Course Resources

Lecture 4 This is a milestone!

Lecture 5 Worksheet Basics

Lecture 6 Entering values and Formulas

Lecture 7 Data Formats

Lecture 8 Data Handling Basics – Cut, Copy and Paste

Lecture 9 Saving and Printing in Excel

Section 3: Essential Excel functions

Lecture 10 Basic Formula Operations

Lecture 11 Mathematical Functions – Part 1

Lecture 12 Mathematical Functions – Part 2

Lecture 13 Difference between RANK, RANK.AVG and RANK.EQ

Lecture 14 Exercise 1: Mathematical Functions

Lecture 15 Textual Functions – Part 1

Lecture 16 Textual Functions – Part 2

Lecture 17 Exercise 2: Textual Functions

Lecture 18 Logical Functions

Lecture 19 Exercise 3: Logical Functions

Lecture 20 Date-Time Functions

Lecture 21 Exercise 4: Date-Time Functions

Lecture 22 Lookup Functions ( V Lookup, Hlookup, Index-Match )

Lecture 23 Exercise 5: Lookup Functions

Section 4: New! XLookup – only for Excel 2021 and Office 365

Lecture 24 XLookup as a replacement of Vlookup

Lecture 25 Handling #NA and Approximates match in Xlookup

Lecture 26 Wildcard matching in XLookup

Lecture 27 Search modes in XLookup

Section 5: Data Tools

Lecture 28 Data Tools Part 1

Lecture 29 Data Tools Part 2

Lecture 30 Exercise 6: Data Tools

Section 6: Formatting data and tables

Lecture 31 Formatting data and tables

Lecture 32 Exercise 7: Formatting

Section 7: Pivot Tables

Lecture 33 Pivot Tables

Lecture 34 Exercise 8: Pivot tables

Section 8: Excel Charts

Lecture 35 Excel Charts – Categories of messages that can be conveyed

Lecture 36 Elements of charts

Lecture 37 The Easy way of creating charts

Lecture 38 Bar and column charts

Lecture 39 Formatting charts

Lecture 40 Line Charts

Lecture 41 Area Charts

Lecture 42 Pie and Doughnut Charts

Lecture 43 Why we should avoid Pie charts

Lecture 44 Scatter plot or XY chart

Lecture 45 Frequency Distribution and Histograms

Lecture 46 Waterfall Charts

Lecture 47 Hierarchy Charts: Sunburst and Treemap

Lecture 48 Combination charts

Lecture 49 Sparklines

Lecture 50 Exercise 9: Charts

Section 9: Pivot Charts

Lecture 51 Pivot Charts

Section 10: NEW! Maps Chart – only for Excel 2019 and above

Lecture 52 Maps Chart

Section 11: Special purpose charts

Lecture 53 Stock charts

Lecture 55 Surface charts

Lecture 56 Heatmaps

Section 12: Named Ranges

Lecture 57 Named Ranges

Lecture 58 Indirect Function

Section 13: Excel Shortcuts

Lecture 59 Shortcuts

Lecture 60 Exercise 10: Shortcuts

Section 14: Macros

Lecture 61 Macros

Lecture 62 Exercise 11: Macros

Section 15: NEW! Importing data from PDF and Websites

Lecture 63 Importing tables from PDF – Excel 2021 and office 365

Lecture 64 Importing data from Website – Excel 2019 and above

Lecture 65 Advanced Excel: Analytics in Excel

Lecture 66 Solving a transportation problem using Excel

Lecture 67 Income Tax calculation – Slabs based tax

Section 17: Creative Infographics

Lecture 68 Infographic Example 1

Lecture 69 Infographic Example 2

Lecture 70 The final milestone!

Lecture 71 Bonus Lecture

Anyone curious to master excel from beginner to Advanced in short span of time

#### Course Information:

Udemy | English | 8h 41m | 3.75 GB