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 : 250.00 $
Preferential Rate : 212.50 $
Note :
Upcoming Dates :
qty
Montreal
11 Dec 2020 - 13:00 to 16:00

Virtual Class
11 Dec 2020 - 13:00 to 16:00

Laval
22 Jan 2021 - 13:00 to 16:00

Montreal
8 Feb 2021 - 13:00 to 16:00

Virtual Class
8 Feb 2021 - 13:00 to 16:00

Montreal
17 Mar 2021 - 13:00 to 16:00

Virtual Class
17 Mar 2021 - 13:00 to 16:00

Brossard
16 Apr 2021 - 13:00 to 16:00

Montreal
4 May 2021 - 13:00 to 16:00

Virtual Class
4 May 2021 - 13:00 to 16:00

Montreal
3 Jun 2021 - 13:00 to 16:00

Virtual Class
3 Jun 2021 - 13:00 to 16:00

Laval
22 Jul 2021 - 13:00 to 16:00

Montreal
26 Aug 2021 - 13:00 to 16:00

Virtual Class
26 Aug 2021 - 13:00 to 16:00

Montreal
22 Sep 2021 - 13:00 to 16:00

Virtual Class
22 Sep 2021 - 13:00 to 16:00