Microsoft Excel – Pivot table report EX-033

Course Overview

Use the 3 pivot table report assistants, change and reorganize a pivot table, update data in a pivot table, create a report and understand the practical options for pivot tables.

Prerequisites

Beginner Microsoft Excel.

Syllabus

Create a pivot table from a list or Excel database.

• Pivot Table Assistant

Modify a pivot table.

• Update a pivot table
• Reorganize pivot fields
• Delete pivot fields

Formatting a PivotTable

• Select items in a pivot table
• Manual formatting
• Automatic formats

Finalize a pivot table.

• Adjust pivot fields
• Customize the data display
• Pivot table options

Create a pivot table report from worksheet ranges with labels.

• Pivot Table Assistant

Do customized calculations.

• Create a formula
• Create a calculated item
• Solve order
• List of formulas

Display a pivot table report graphically.

• Create a graph from a pivot table
• Pivot graph

Filter the results.

• Page field
• Page display

Create a pivot table report from an external source.

• Pivot Table Assistant
• Read external data

Reorganize a pivot table.

• Group items
• Hide/show details

Create an Excel list.

• Convert a range of cells into a list
• Sort data in a list
• Filter data in a list
• Add a new record
• Add a total line to a list
• Delete the total line in a list
• Resize the list
• Convert a list to a normal range