Microsoft Excel Zero to Hero 

Introduction

Introduction

Course Curriculum

Getting started on Windows, macOS, Android, and IOS

Introduction

Worksheet basics

Entering values and formulas

Data formats

Data handling basics – cut copy and paste

Save and print in excel

Excel Ranges

Introduction

Basic formula operations

Mathematical functions level1

Mathematical functions level2

Text functions level1

Text functions level2

Logical functions

Date time functions

V Lookup formula

HLookup formula

HLookup Match formula

Match Index formula

Introduction

XLookup

Handling NA and Approximates match in XLookup

Wildcard matching in XLookup

Introduction

Split Text into columns

Flash Fill

Remove Duplicates

Data Validation

Get - import Data from Text

Get - import Data from CSV

Introduction

Formatting Font

Formatting Alignment

Formatting Number

Formatting Date

Formatting tables

Introduction

Creating Pivot Table

Value field settings

Number format

Pivot Table Design

Excel Exercise

Solution for Excel Exercise

Introduction

Excel Charts – Categories

Elements of a chart

Easy way to create charts

Column or Bar charts

Formatting charts

Line charts

Area charts

Pie and Doughnut charts

Format Area Plot or XY chart

Scatter or bubble charts

Introduction

Frequency Distribution and Histograms

Waterfall charts

Hierarchy charts sunburst and tree map

Combination charts

Sparklines

Pivot charts

Maps chart

3D Maps chart

Introduction

Stock charts

Radar charts

Surface charts

Heat maps

Named ranges - dropdown

Indirect Name range Function

Import Data table from PDF file – Excel 2021

Import Data from Website – Excel 2019 above

Project Sales forecast tracker

Product Sale Tax invoice Tax Calculations