Advanced Excel Course Contents

Brush UP Excel Spreadsheet

Creating, editing, saving and printing spreadsheets

Password Protecting Worksheets, Freeze Panes

Formatting worksheets , Saving Workspace,  Securing & Protecting spreadsheets

Mail Merge

ADVANCED Excel Function

Basic Function (SUM,SUMIF,SUMIFS,SUMPRODUCT, AVERAGE, MIN, MAX,
COUNT,COUNTIF,COUNTIFS, COUNTA, ROUND, INT,MOD

Lookup Functions:- LOOKUP, VLOOKUP, HLOOKUP

The LOOKUP function , Date and time functions, Age Calculation

Logical functions using IF, AND, OR, NOT

Nested functions , Name cells /ranges

Relative, Absolute  references : >,<,= operators

DATA Analysis: (Live Data Analysis)

Sub Total Reports, Auto Filter, Text To Columns

Password Protecting ranges

Sheet Referencing

Consolidation of Data

Data Validation

What-if-analysis

PIVOT Tables

Charting

Graphically representing data : Charts & Graphs

Chart (Bar Charts, Pie Charts, Speedometer, Columns Charts)