Fast Track Excel Programme

WhatIf Analysis

  • Goal Seek
  • Data Tables
  • Scenario Manager

Auto and Advanced Filters:

  • Extracting Records with Advanced Filter
  • Using Formulas In Criteria
  • Handling complex Criteria(s)
  • Using Multiple Criteria in Advanced Filter
  • Generating MIS Reports and Balance sheets

Advanced Charting and Dashboard:

  • Creating Multiple Chart Types
  • Primary, Secondary and Combo Charts
  • Trend line Charting, Spark Line
  • Gantt Chart, Doughnut Charts
  • Dynamic Charting Techniques
  • Dashboard Designing
  • Excel templates designing

Data Analysis:

  • Sub Total Reports, Auto Filter
  • Password Protecting Worksheets, Single Cell Protection
  • Linking Multiple Sheets
  • Sheet Referencing
  • MIS Reporting


  • What-if-analysis
  • Reporting
  • Character Functions
  • Date Functions
  • Age Calculations

Pivot Tables and Pivot Charts:

  • Enter the Pivot Table Data
  • Create the Pivot Table
  • Adding Data to the Pivot Table
  • Filtering the Pivot Table Data
  • Change the Pivot Table Data
  • Analyze Data Columns in Pivot Tables
  • Adjust Data to Analyze