Introduction and Interface of MS Excel

Create worksheets and workbooks I Format worksheets and workbooks I Navigate in worksheets and workbooks I Customize options and views for worksheets and workbooks

Filter, Formula IF, AND. OR

Filter and sort a table, Advance filter, Custom Auto filter I Number, Date, colour and Text filter I Copy and paste formula I Formula and Cell reference, form filter and Subtotal I IF, AND, OR Function in detail I Equal to, Greater than, Less than function I Relative and absolute cell reference

VLOOKUP. INDEX MATCH. Goal Seek

What If analysis (Goal Seek and Solver parameter) I VLOOKUP, HLOOKUP, Index and Match Relationship between Index, Match & VLOOKUP and why we use each of them

IFERROR. ISBLANK. Protect sheet, SUMIF(S)

IFERROR, Types of error, reason for each error & how to remove them I Protect the worksheet I Locked and Unlocked cells I Password protection I SUMIF(S), COUNTIF(S) & their application in multiple conditions IISBLANK Function

Pivot Table

Pivot tables fields and function of each field I Formatting of pivot tables I Value field setting I Filter in Pivot table I Grouping and Ungrouping I Design of Pivot tables and Pivot charts I Expand and Collapse of different fields I Moving between fields I Calculated field and calculated items

Conditional and Custom Format

Find duplicate values and Shades alternate rows I Highlight cell rules I Top bottom rules I Manage rules and icon sets I Data bars, colours scale I Formatting through formulas I Custom formatting rules and function and application of each rules

Basic & Advance Dashboard

Purpose of dashboard and key rules to remind I How to format data set I Slicers I Make Pivot charts for dashboards