Date Time No. of Days Fees (Inclusive Taxes)
20/10/2022 2:00 PM - 5:00 PM 1 3835

Advanced Excel

Advanced Pivots, Formulas & Functions

Analyse data in more complex and detailed way.

Learn proven quantitative tools and methods of Microsoft Excel for analysing, interpreting, and utilizing data, so that more informed and reliable business decisions can be made.

By the end of the workshop you will have a Strong command over

  • Formulas with Multi dimensions
  • Combining more than one formula
  • Lookup with match, row, column, index, match, array formulas
  • User define array formulas
  • Advance pivot table and charts

panel_start Course Objective panel_end

  1. Analysing large data
  2. Avoid manual data entry – User restrictions
  3. Working on the large file size
  4. Complete control over your data
  5. Automating Report
  6. Insights
  7. Automating Repetitive business task
  8. Importing data from different sources

panel_start Course Content panel_end

  • Advanced Formulas and Functions:
    • Advanced Logical
    • Advanced Lookup & Reference Functions
  • What-If Analysis (Data Analysis)
    • Scenario Analysis
    • Goal Seek
    • Data Table
  • Advanced Filters
  • Working on the large size files
  • Sparklines, Slicers & Timelines
  • Advanced Pivot Tables
    • Create Dashboards using Pivots
    • Get Pivot data from different sources
    • PivotTable calculations
    • Using slicers in PivotTables
    • Conditional formatting in PivotTables
    • Creating Pivot Charts