Microsoft Excel Dashboard And PivotTable Workshop

Microsoft Excel Dashboard and PivotTable workshop is offered by Eliquo Training. Eliquo was established in 2002 as a software training centre dedicated to supporting digital experiences and application development.

In this course, you will learn how to:

• quickly reorganize and manipulate Excel data
• create a summary to accomplish analysis tasks

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