PivotTable, Charts and Dashboards

Taught by Microsoft Certified Trainers

  • (758)

This is a 5 hours course designed for Excel users to crunch numbers substantially, create reports dynamically using PivotTable and, present professional information Dashboards in Microsoft Excel that is beautiful, precise and clear.

  • Course Duration:
  • 6 Hours (2 Sessions, each of 3 hours)
  • Mode of Training:
  • Virtual Classroom (Instructor-Led)
  • Pre-requisite:
  • Basic Excel knowledge

Course Fee $199

Course Content - Overview

Creating Pivot Table
  1. Changing the Pivot Table layout
  2. Formatting row , column and value fields
  3. Grouping items – Number Grouping and Date Grouping
  4. Inserting calculated fields
  5. Display and hide data in fields
  6. Layout reports directly on worksheet
  7. Manual, Single & Multi sorting options
  8. Manual, Single & Multi Filtering options
  9. Multiple ways of presenting data in Pivot Table
  10. Using advanced value field setting
  11. Display Amount in Percentage
  12. Pivot Table – Design Tab
Pivot table options Using slizers CHARTS & PIVOT CHARTS
  1. Bar Charts / Pie Charts / Line Charts
  2. Dual Axis Charts
  3. Dynamic Charting
  4. Other Advanced Charting Techniques
  1. Bar Charts / Pie Charts / Line Charts
  2. Planning a Dashboard
  3. Adding Tables to Dashboard
  4. Adding Charts to Dashboard
  5. Adding Dynamic Contents to Dashboard
  1. Transform business records into a detailed report within seconds
  2. Construct different views for your business needs
  3. Present visually appealing data through Charts
  4. Summarize all data points into a single screen for effective decision-making
  1. Pre-Course Assessment
  2. Hands-On Instructor Led Training
  3. 10+ Assignments and Real-time exercises
  4. Post-training Support for period of 30 Days

Learner stories around the world!

Jayden Noah

Financial Analyst

Programming is something I thought would never be able to get hang on. I really appreciate Mr. Sami for making the most complex concepts look so simple.

Contact Us

Excelgoodies Consulting, Inc.

575 7th Avenue, 5th Floor, New York City,

NY 10018

  • Mr.Paul Melton, Business Associate
  • (650) 491-3131, (347) 790-1311
  • inquiry_vba@excelgoodies.com

Connect us on