Mathematical, Logical and Text Operators (Check Download Files)

Writing basic formula and understanding precedence (Check Download Files)

Understanding basic logical formulas

Sum,Average,Max and Min Functions

Count and Rounding Functions

Countif,AND,OR Logical functions

IF AND IFS Functions

Date Functions

Text Functions

DSUM,DAVERAGE AND DCOUNT

Relative and Absolute referencing Part I

Relative and Absolute referencing Part II

Data selection,creating Pie chart and Bar Chart

Creating Column Chart and Line Chart

Using IF,AND Functions

Nested IF

IFError and IFS used together

Sum IF and Count IF

Naming Ranges

VLook Up

VLook Up and Match

HLook Up

HLook Up and Match

Index and Match

Indirect,VLook Up and Match

Using Approximate Match

Protecting Data and allow editing ranges

Protecting workbook structure and encrypting with password

Simple and Custom Sort

Simple filters and Advanced filters

Using Advanced filters to copy data

Types of Data Validations

Dependant Validations

Understanding and Creating Pivot Table

More Pivot Tables and Value Field Settings

Pivot Tables with Different Fields

Pivot Charts

Creating Dashboard

Dashboard_Get Pivot Data

Inserting Slicer

Basic Preparation before recording macro

Recording macro to add formatting

Recording macro to apply formulas

Running the macros

Visual Basic Editor,Understanding VBA code of formatting

VBA code for calculate macro

VBA code for total macro

Basics of Excel and Course Files

Database Functions, Referencing & Course Files

Formatting & Complex Logical Formulas

Charting and Data Cleaning

Named Ranges,Vlook up,Hlook up,Index & Match

Data Protection,Validation,Filters & Conditional Formatting

Power Pivot and Power Query

Power Query and Data Transformation (Download Files)

Data Visualization, Dashboard Technique & Macros (Download Files)

Goal Seek,Scenario,Data Table,Forcasting and Solver