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
Duration : 0,5 jour
Regular Rate : 275.00 $
Preferential Rate : 233.75 $
Note :

Upcoming Dates

qty

Virtual Class

10 December 2024 from 13:00 to 16:00

Virtual Class

23 January 2025 from 9:00 to 12:00

Virtual Class

21 February 2025 from 13:00 to 16:00

Virtual Class

21 March 2025 from 9:00 to 12:00

Virtual Class

18 April 2025 from 13:00 to 16:00

Virtual Class

16 May 2025 from 9:00 to 12:00

Virtual Class

16 May 2025 from 9:00 to 12:00

Virtual Class

13 June 2025 from 13:00 to 16:00

Virtual Class

11 July 2025 from 9:00 to 12:00

Virtual Class

8 August 2025 from 13:00 to 16:00