Course curriculum

  1. 01

    • Introduction

    • Course Curriculum

    • Getting Started On Windows, macOS, Android, And IOS

    • How to Ask great Questions

    • FAQ’s

    • Starting Excel
  2. 02

    • Introduction

    • Worksheet basics

    • Entering values and formulas

    • Data formats

    • Data handling basics – cut copy and paste

    • Save and Print in Excel

    • Excel Ranges
  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

    • Data Validation

    • Get - import Data from CSV

    • Get - import Data from Text
  6. 06

    • Introduction

    • Formatting Font

    • Formatting Alignment

    • Formatting Number

    • Formatting Date

    • Formatting Tables
  7. 07

    • Introduction

    • Creating Pivot Table

    • Value field Settings

    • Number Format

    • Pivot Table Design

    • Excel Exercise

    • Solution For Excel Exercise
  8. 08

    • 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
  9. 09

    • Introduction

    • Frequency Distribution and Histograms

    • Waterfall Charts

    • Hierarchy Charts Sunburst And Tree Map

    • Combination Charts

    • Sparklines
  10. 10

    • Pivot Charts
  11. 11

    • Maps Chart

    • 3D Maps Chart
  12. 12

    • Introduction

    • Stock Charts

    • Radar Charts

    • Surface Charts

    • Heat Maps
  13. 13

    • Named Ranges - Dropdown

    • Indirect Name Range Function
  14. 14

    • Import Data Table From PDF File – Excel 2021

    • Import Data From Website – Excel 2019 above
  15. 15

    • Project Sales Forecast Tracker

    • Product Sale Tax invoice Tax Calculations

    • Source File