ADVANCE EXCEL 

Customizing common options in Excel

Absolute and relative cells

Protecting and un-protecting worksheets and cells

Writing conditional expressions (using IF)

Using logical functions (AND, OR, NOT)

Using lookup and reference functions (VLOOKUP, HLOOKUP, MATCH, INDEX)

Specifying a valid range of values for a cell

Specifying a list of valid values for a cell

Specifying custom validations based on formula for a cell

Designing the structure of a template

Using templates for standardization of worksheets

Sorting tables

Using multiple-level sorting

Using custom sorting

Date and time functions

Text functions

Using auto formatting option for worksheets

Using conditional formatting option for rows, columns, and cells

Relative & Absolute Macros

Editing Macro's

Goal Seek

Data Tables

Scenario Manager

Using Charts

Formatting Charts

Using 3D Graphs

Sparklines, Inline Charts, Data Charts

Overview of all the new features

The Final Assignment would test contains questions to be solved at the end of the Course

VBA (VISUAL BASIC FOR APPLICATION) & MACROS

Swap Values, Run Code from a Module, Macro Recorder, Use Relative References, FormulaR1C1, Add a Macro to the Toolbar, Macro Security, Protect Macro.

MsgBox Function, Input Box Function