ISO 9001 : 2015 | 9419160635 | | Student Verification | Franchisee Login | Contact

Courses Module

  • Overview of the Basic Excel
  • Working with functions-Writing conditional expressions (using IF) ~ Using logical functions (AND, OR, NOT),Using lookup and reference functions (VLOOKUP, HLOOKUP, MATCH, INDEX),Using VLookUP to consolidate Data from Multiple Sheets
  • Data Validations-~ 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
  • Working with Templates-~ Designing the structure of a template ~ Using templates for standardization of worksheets
  • Sorting and Filtering Data-~ Sorting tables ~ Using multiple-level sorting ~ Using custom sorting ~ Filtering data for selected view (AutoFilter) ~ Using advanced filter options
  • Working with Reports-~ Creating subtotals ~ Multiple-level subtotals ~ Creating Pivot tables ~ Formatting and customizing Pivot tables ~ Using advanced options of Pivot tables ~ Pivot charts
  • More Functions-~ Date and time functions ~ Text functions ~ Database functions ~ Power Functions (CountIf, CountIFS, SumIF, SumIfS)
  • Formatting ~ Using auto formatting option for worksheets ~ Using conditional formatting option for rows, columns and cells
advance excel

Course Fees

10,500 + 18% GST

Course Duration

150 Hrs.

Close Menu