Basic to Advanced Excel

Getting Started With Excel

Creating and Opening Workbook

Saving Workbooks

Cell Basics

Modifying Columns, Rows and Sheets

Formatting Cells

Understanding Number Formats

Intro to Formulas

Creating More Complex Formulas

Relative and Absolute Cell References

Functions

Sumlf, Sumlfs

Countlf, Countlfs

Averagelfs,

Nested IF, IFERROR Statement,

AND, OR

Upper, Lower, Proper

Left, Mid, Right

Trim, Len, Exact

Concatenate

Find, Substitute

Today, Now

Day, Month, Year

Date, Date if, DateAdd

EOMonth, Weekday

If Function

How to Fix Errors- if error

Nested If

Complex if and or functions

Vlookup/ HLoolup

Index and Match

Creating Smooth User Interface Using Lookup

Vlookup with Helper Column

Goal Seek
Scenario Analysis
Data Tables (PMT FUNCTION)
Solver Tool

Number, Date & Time Validation
Custom validation based on formula for a cell
Dynamic Dropdown List Creation using Data validation – Dependency List

Creating Simple Pivot Tables
Basic and Advance Value Field Setting
Classic Pivot table
Choosing Field
Filtering PivotTables
Choosing Field
Flitering PivotTable Data
Grouping based on numbers and Dates
Calculated Field & Calculated Items
Arrays Functions
What are the Array Formulas, Use of rthe Array formulas?
Basic Examples Of Arrays (Using ctrl + shift+ enter).
Array with if, len and mid functions formulas.
Array with Lookup functions.
Advanced Use of formulas with Array.

Various Charts i.e. Bar Charts / Pie Charts / Line Charts
Using SLICERS, Filters data with Slicers
Manage Primary andv Secondary Axis

What is VBA?
What Can You do with VBA?
Recording A Marco
Procedure and functions in VBA