Address : 279/1, New Railway Road Gurgaon
Call us : 99 10 192 454 | 98 11 176 098
Email: usflindia@gmail.com

"Speak a new language
so that the world
will be a new world."

Advance Excel

Advance Excel Course Contents

Module 1: Overview of the Basics


  1. Customizing common option in Excel
  2. Absolute and Relative cells
  3. Protecting and un-protecting worksheets and cells

Module 2: Working with Functions


  1. Writing conditional expressions (using IF)
  2. Using logical functions (AND, OR, NOT)
  3. Using lookup and reference functions (VLOOKUP, HLOOKUP, MATCH, INDEX)

Module 3: Data Validation


  1. Specifying a valid range of values for a cell
  2. Specifying a list of valid values for a cell
  3. Specifying custom validations based on formula for a cell

Module 4: Working with Templates


  1. Designing the structure of a template using templates for standardization of worksheets

Module 5: Sorting and Filtering Data


  1. Sorting tables
  2. Using Multiple-level sorting
  3. Using custom sorting
  4. Filtering data for selected view (Auto Filter)
  5. Using advance filter options

Module 6: Working with Reports


  1. Creating subtotals
  2. Multiple-level subtotals
  3. Creating Pivot tables
  4. Formatting and customizing Pivot tables
  5. Using advanced options of Pivot tables Pivot charts
  6. Consolidating data from multiple sheets and files using Pivot tables
  7. Using external data sources
  8. Using data consolidation feature to consolidate data

Module 7: More Functions


  1. Date and time functions
  2. Text functions
  3. Database functions

Module 8: Formatting


  1. Using auto formatting option for worksheets
  2. Using conditional formatting option for rows, columns and cells

your interest

Universal School