Course curriculum

  1. 01

    • Introduction

    • Getting started on Windows, macOS, Android, and IOS

    • How to ask great questions

    • FAQ

    • Start Excel
  2. 02

    • Overview of top Excel tips

    • Add numbers like a pro

    • Save time by filling cells automatically

    • Did data enter into one column - Split it

    • Switch data around by transposing it

    • Sort and filter for quick results

    • Create a data table for tasks to make it easy

    • Make drop-down list

    • Quick Data Analysis

    • Great charts for your visualization

    • Pivot Tables for Data Analytics
  3. 03

    • 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
  4. 04

    • Introduction

    • XLookup

    • Handling NA and Approximates match in XLookup

    • Wildcard matching in XLookup
  5. 05

    • Introduction

    • Split Text into columns

    • Flash Fill

    • Remove Duplicates

    • Get - import Data from CSV

    • 5e Data Validation

    • 5f Get - import Data from Text
  6. 06

    • Introduction

    • Creating Pivot Table

    • Value field settings

    • Number format

    • Pivot Table Design

    • Excel Exercise

    • Solution for Excel Exercise
  7. 07

    • 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