Course curriculum

  • 01

    MS Excel

    Show Content
    • Thunder Template
  • 02

    Learning Excel Basics

    Show Content
    • Basic of Workbook in MS Excel
    • Excel Ribbon & Shortcuts - Basics
    • Autofill Option in Excel
    • Formula & Calculations - The Basics
  • 03

    Formatting Excel

    Show Content
    • Naming & referencing cells
    • Formatting Basics
    • Conditional Formatting - Basics
    • Conditional Formatting - Advanced
    • Apply Data Validation to Cells
  • 04

    Functions in MS Excel

    Show Content
    • Introduction
    • COUNTIF function
    • IF Function
    • Advanced IF Function
    • IFS Function
    • Nested IFS Function
    • IF with AND and OR
    • SUMIFS and COUNTIFS
    • SUMIF Function
    • Date & Time Function in Excel
    • LEFT RIGHT and MID Function
    • TRIM Function
  • 05

    LOOKUP Function

    Show Content
    • LOOKUP Function - Basics
    • Nested VLOOKUP
    • VLOOKUP Function - Advanced
    • VLOOKUP - Troubleshooting Tips
  • 06

    Pivot Table

    Show Content
    • Creating Pivot Tables - Basics
    • Manipulating the Pivot Table Data
    • Grouping Data in Pivot Table
    • Pivot Charts
  • 07

    Data Analysis & Validation

    Show Content
    • Data Analysis in Excel
    • Data Validation in Excel
    • Quick Data Analysis using Charts
    • Data Trends using Sparklines
  • 08

    Data Table

    Show Content
    • Data Table & What If Analysis
  • 09

    Dashboards

    Show Content
    • Dashboard Creation for Beginners
    • Dashboard Creation - Advanced
    • Dashboard Creation using Pivot Tables & Charts