Excel pivottable course - in english

In this Excel Pivottable course, you will learn how to transform large datasets into user-friendly dashboards with statistical aggregations, charts and interactive filters. 

To the right and below you can see where and when the next open courses in Excel Pivottables are offered. 

company course

9.500 DKK excl. VAT
  • Up to 10 participants

Solo course

5.950 DKK excl. VAT
  • For 1 or 2 participants

open courses

3.650 DKK excl. VAT
  • Attend an open course

Excel 2016 Pivottable course - in english

Learn how to transform large datasets into user-friendly dashboards with statistical aggregations, Charts and interactive Filters without having to make complex formulas.

Duration

One day: 09: 00-16: 00

Requirements

The course is targeted people who need to analyze sales, finance, production, logistics etc. using Pivottables.

We recommend peolpe to have worked with Excel regularly and have a minimum Excel knowledge corresponding to our Basic Excel 2016 course, but it will be an advantage to have work with large datasets.

CONTENT

Creating a pivot table

  • Why use Pivottables
  • Preparing Data
    • Requirements for data
    • Avoid zero- and/or error-values
  • Connect Data to Pivottable
    • From the Data in Excel
    • From the Data in databases (Access, SQL, and others)

Design of the pivot table

  • Field Areas
  • Grouping of different datatypes (Numbers, text, dates)
  • Viewing data as a percentage of a total
  • Create formulas/calculated fields directly in the pivot table

The work in the pivot table

  • Sorting – automatic/manual
  • Filtering
  • Using the “Slicer” feature
  • “Drill down” – see the underlying data

Presentation using formats and charts

  • Using the built-in styles / formatting
  • Conditional Formatting – Spot developments / trends
  • Create PivotCharts

Reports

  • Make your interactive reports directly in Excel with Pivot tables
  • Create your own reports with the function GetPivotData
  • Record macros to update the pivot table

Settings

  • Pivottables Options

Other tools for working with large data sheets

  • Format as Table
  • Filtering and sorting
  • Subtotals
  • Groupings
 

Back to the overview: Excel courses

No event found!
Hent flere

This course includes