Module Name

Description

Module - 1

Introduction to the Interface & Source Data

Formatting 

·       Formatting Option-1

·       Formatting option-2

·       Number Formatting

Navigation Shortcuts

Format Painter

Insert Delete Rows & Columns

Autofill Data

Sorting

Filtering

·       Text Based Filtering

·       Number Based Filtering

·       Data Based Filtering

·       Wild Cards

Custom Lists

Module - 2

Essential Concepts

·       Absolute vs Relative Reference

·       Types of References

·       SUM formula

Logical Formulas

·       IF

·       Nested IF

·       AND & OR

·       IF +AND

·       IF + OR

·       NOT & IF + NOT

IF & IFS Formulas

·       COUNT IF

·       AVERAGE IF

·       SUM IF

·       COUNT IFS

·       AVERAGE IFS

·       SUM IFS

Statistical Formulas

·       Statistical Formulas

·       Large, Small & Rank

Lookup Formulas

·       VLOOKUP – Exact Match

·       VLOOKUP- Approximate Match

·       HLOOKUP

·       VLOOKUP Practice

1Index & Match

·       2 ways Lookup

·       Index

·       Match

·       Index Match

·       Index Match Practice

Financial Formulas

SWITCH

Text Formulas

Date & Time Formulas

Common Errors & How to solve them

Module - 3

Excel Data Viz Pro

·       Fundamentals of Data Visualization

·       Inserting Chart in Excel

·       Changing Elements in Chart

Types of Columns & Bar Charts

Line Chart

Select Data Method

Format Chart Elements

Area Chart

Pie Chart

Donut Chart

Histogram & Pareto Chart

Scatter Plot

Treemap & Sunburst Chart

Waterfall Chart

Heat Maps

·       Heat Maps

·       Conditional Formatting

Combo Chart

Sparkline

Dynamic Chart

·       Drop Down Chart

·       Control Spin Button Chart

Funnel Chart

Slope Chart

Dumbbell Chart

Highlight Points in Time

Highlight Min & Max

Actual Vs Target-1

Actual Vs Target-2

Module - 4

Excel Pivot Table

Pivot Table – Need & Benefits

Importance of Tables (Not Pivot Table)

Introduction to the Source Data

Inserting a Pivot Table

Understanding the Field List (Engine)

Clear, Select & Move Functions

Refreshing your Pivot Table

Number Formatting in Pivot Table

Conditional Formatting in Pivot Table

Sorting in Pivot Table

Filtering in Pivot Table

Grouping in Pivot Table

Pivot Table Layouts

Table Styles & Other Important Options

Summarize Values By

Calculated Fields

Pivot Charts

Slicers

Macros