Understanding Excel and its Introduction

Interface of Excel

Shortcut Keys- 1

Shortcut Keys- 2

Test 1- Shortcut Keys

Basic Functions (SUM, AVERAGE, COUNT)

Functions Class 2- SUMIF, AVERAGEIF, COUNTIF etc.

Test 2- Functions (Level 1)

Recap- Basic Formulas & Shortcuts

Cell Referencing & it's types

Intermediate Formulas & its Uses

Introduction to Error Output

Data Validation- Sorting & Filtering

Practical Concepts in Editing, Formatting, and Referencing

Test 3- Functions (Level 2)

Introduction to the Lookup Functions

Improvisation of the Lookup Functions (INDEX, MATCH)

Test 4- Functions (Level 3)

Advanced Sorting, Filtering & Data Validation with Text-to-Column

Performing Various Charts in EXCEL & Conditional Formatting

Pivot Table & Pivot Charts

Slicers, Spraklines & Timelines

Live Test- 1

Live Test- 2

Introduction to Macros

Excel Macros - VBA & Editor

Macros in a Single Workbook / Multiple Workbooks

Running / Editing A Macro & Assigning Macros to Objects - 1

Running / Editing A Macro & Assigning Macros to Objects - 2

Running / Editing A Macro & Assigning Macros to Objects - 3

Assignment 1- Macros

Assignment 2- Macros