Advanced Excel Table, Charts, PivotTable, PivotChart and Dashboard Reporting (Long-Term Course)

Course Content

  • Ice Breaking and Discussion for Dashboard Reporting
  • Data Matching & Lookups for Preparing Dashboard’s Raw Data
  • Logical Function & Formula Nesting
  • Naming in Excel
  • Data Summarization from Large Data
  • Techniques to Validate Raw Data
  • PivotTable, PivotChart and Slicers
  • Make Protected Your Dashboard
  • PowerPivot – Use Excel’s Built-in Self Service BI Tool
  • Using Objects & Form Controls to Control Your Dashboard
  • Using Charts & Graphs in Dashboard
  • Applying Advanced Conditional Formatting on Dashboard
  • Macro & VBA
  • Exclusive Project Session
  • Does the ERP system strengthen the company’s competitive position ? How might it erode the company’s
  • competitive position ?
  • Does the ERP system strengthen the company’s competitive position ? How might it erode the company’s
  • competitive position ?

 

 

What you will learn

  • What is Pivot Table?
  • Benefits of PivotTable
  • Required Checklist for Pivot Table
  • Preparing Source Data in Tabular Format
  • Creating a PivotTable
  • Formatting PivotTables
  • Arranging / Pivoting Data
  • Add Columns
  • Changing the Way Values are Displayed
  • Formatting Values
  • Grouping Data
  • Calculated Fields
  • Sorting and Filtering Data
  • Refreshing a PivotTable
  • Extending the Dataset
  • Business Blue Print

 

Requirements & who can attend

  • This Course is created on Excel 2016, You can also use Excel 2010 and above
  • Basic Excel Knowledge
  • Interest to Learn and Upgrade Your Skillset
  • A Windows or a MAC PC where Microsoft Excel is Installed

This is an exclusive for them who have experience working with Microsoft Excel and would like to learn more about Pivot Table, Pivot Chart and dashboards.

 

Learn by doing

  • You will learn about Pivot Tables and Pivot Charts
  • You will learn to create 2 interactive Excel Dashboards
  • You will learn how to use 20 Plus different Excel Charts and Graphs used in Dynamic Excel Dashboards.
  • You will learn how to Design, Format and Style Data Elements
  • You will learn 30 Plus top Microsoft Excel Formulas and Functions

 

Course at a Glance

Price:

Starting and Ending Date

Last Date of Registration

Class Schedule

Enroll Now

Resource Person