Microsoft Excel Dashboard and PivotTable Workshop

In this course, you will learn how to:

  • quickly reorganize and manipulate Excel data
  • create a summary to accomplish analysis tasks
Days : 1
Price :




Course Outline

  • pivot table fundamentals
    • create a pivot table
    • add/remove pivot table fields
    • rearrange the layout of pivot table
    • rename a field
    • add a new field
    • work with value areas
    • reveal the source data
  • summarize data
    • use functions to summarize values
    • display values as percentages
    • compare totals and base value
    • show running totals
    • change the sort order
    • show the ranking values
    • changing the analysis function
  • filters and slicers
    • filter data using the report filter
    • filter data using the pivot table filters
    • organize the pivot table through the use of slicers
  • design the pivot table
    • styling the pivot table
    • display sub-totals in different positions
    • remove grand totals¬†
    • tabular view
    • outline view
    • formatting numbers in the data area
  • group data
    • creating custom groups
    • group data by date
    • group data by range
  • work with multiple tables
    • create and manage table relationships
  • consolidation ranges
    • consolidate data using a pivot table
    • work with consolidated data
  • pivot table calculations
    • create calculated items and fields
    • work the calculated items and fields
    • understanding the getpivotdata function
  • pivot charts
    • create and format a pivot chart report
    • work with pivot chart report data
  • dashboard
    • understanding dashboard
    • create a dashboard