Remote training Excel: Performing tricks with PivotTables

  • Version: Office 2016/Office 365
  • Duration: Half a day
  • Price open training: € 255 VAT excl. / Cheaper course?

Description

You are working with a large list of data in Excel? If you cannot see the forest for the trees, PivotTables will provide you with a clear overview of all the data collected. After this part two, you will know at a glance how many items meet a specific condition. You will also learn how to carry out analyses using the different parameters such as language, region, or any other column in your table. In short, how to optimise the analyses of your data by using the many advantages Excel PivotTables offers.

Choose a date and location

Objectives

After this remote Excel training on PivotTables:

  • you will know how to create the correct foundation for PivotTables
  • you will be aware of the power of PivotTables

Target Group

Employees who regularly work with data lists in Excel and want to analyse their data.

Prerequisites

Participants have completed the Excel course 'Databases' or have the equivalent knowledge.

Content

Working with PivotTables:

  • The use of Recommended PivotTables
  • The different parts of a PivotTable: Filter Fields, Row Fields, Column Fields and Values
  • Creating a PivotTable based on 1 table
  • Creating a PivotTable based on multiple tables using a data model
  • Creating relationships between different tables in the data model
  • Formatting a PivotTable using the ribbon: banded rows/columns, PivotTable Styles
  • Show subtotals at the top/bottom
  • Deleting subtotals
  • Changing calculations: sum, count, average, min, max, distinctcount
  • Formatting calculations: number of decimals
  • Viewing calculations differently: % of grand total, % of row total, …
  • Grouping data: text, data, numbers
  • Analysing data from an external database using a PivotTable
  • Using slicers to filter a PivotTable (general slicers and timeline slicers)

Choose a date and location

  • Dates
  • Days
  • Timing
  • Language
  • Location
  • Planning
  •  

Request an offer



Share this course on Facebook, Twitter, LinkedIn or e-mail

Practical info open training course

The practical info and applicable cancellation conditions related to this open training course.

 

Choose a date and location

€ 255 VAT excl.
Cheaper course?

Would you like to organize this online training/webinar for your employees?

We transform your requirements into the perfect solution.

Request