Introduction to Advanced Excel: Introduction to excel, excel interface, creating open workbook, saving & Sharing Books, cells basic, modifying column, function of excel.
Function & Formula in Advance Excel: foundation function & formulas, nesting function, IF Formula, VLOOKUP, VLOOKUP with OFFSET, Money Function, Calculate payment towards principle, future value, Depreciation, 3D formula.
Data Validation: Introduction to data validation, Rules of consistency, Types of Date Validation, Data Validation dialog box, applying Data Validation.
Pivot Table: what is pivot table, preparing your data, creating your first pivot table, Modifying subtotals & grand totals, sorting table, filtering pivot table, formatting pivot table, printing pivot table.
Conditional formatting: Understanding Conditional Formatting, Formatting cells containing values, clearing conditional formatting, more cells formatting options, more top & bottom formatting options, working with data bars, working with color scale, working with icons.
Spreadsheets: introduction to excel worksheet, staring excel, excel screen, column & cells, Sheet & Workbook, moving around in excel, data entry, formatting, formula creation & Math Function, creating charts, chart wizard, text import wizard, printing.