+91 8143 616 616 admin@financetraining.in
Select Page

About Advanced Excel Pivot Table

  • Performing complex calculations more efficiently, using various Excel functions.
  • Organizing and analyzing large volumes of data.
  • Creating MIS reports.
  • Designing and using templates.
  • Consolidating and managing data from multiple workbooks.


Advanced Excel Pivot Syllabus


Advanced Formulas and Functions

  • Advanced Financial Functions
  • Advanced Logical & Error Functions
  • Advanced Text Functions
  • Advanced Date & Time Functions
  • Advanced Lookup & Reference Functions
  • Advanced Mathematics and Statistics Functions
  • Advanced Information Functions

What If Analysis

  • Scenario Analysis
  • Goal Seek
  • Data Table
  • Data Consolidation
  • Working with Duplicates
  • Using the Remove Duplicate command
  • Array formula to locate duplicate data

Data Validation 

  • How to lock values and formulas in your Excel worksheets
  • Track down mistakes in your worksheet using the Formula Auditing tools
  • How to use the Trust Center settings to manage Excel security
  • How to share your Excel workbook and not worry about someone making changes that’ll ruin your work
  • How to use Data Validation to make sure the data going into any cell meets the criteria you’ve specified

Advanced Custom Formatting

  • Advanced Conditional Formatting
  • Sparklines, Slicers & Timelines
  • Random Numbers
  • Debugging formulas& Dependency Tree
  • Counting Unique, Generating Unique List
  • Working with Duplicates

Advanced Pivot Tables

  • PivotTable calculations
  • Creating separate sheets for PivotTables
  • Using slicers in PivotTables
  • Summarizing pivot data
  • Sorting and filtering data
  • Conditional formatting in PivotTables
  • Creating PivotCharts
  • Advanced Charting
  • Macros
  • Troubleshooting Excel Problems
  • Tips & Tricks