Advance Excel with VBA Training Course 

offered by IIHT Academy St. Marks Road Bangalore

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)

VlookUP with Exact Match, Approximate Match

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

Creating subtotals

Multiple-level subtotals

Creating Pivot tables