image

In this ‘Excel Pivottable’ course, you will learn 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 courses in Excel VBA are offered.

We also offer company customized courses

Navigation

Select here if you are looking for another application

Select here if you are looking for another type of Excel Courses

Company customized courses

If you have up to 10 Colleagues for the same course, we have a special offer whether you provide a suitable training location or wants us to arrange it all. If needed we can also provide portable computers.

Price: 9.500,- DDK.  excl. VAT

Look here for other courses in your company and book an offer

Solo - Duo course

If you prefer being on your own or perhaps with a Colleague, or if you have special wishes, then a solo/duo course might be the right choice for you. Together we will design the content for your education.

Price: 5.950,- DKK excl. VAT per day.

Look here for other courses in your company and book an offer

Open courses (open for all)

In the calendar to the right and below, you will find dates for open courses. Please notice the different locations.

Price: 3.650,- DKK. excl. VAT

Purpose

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 piovt 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

              • 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

                  Raports

                    • 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

                          Subsequent Courses

                          After this course in Pivot tables, we recommend:

                          Excel VBA Grundlæggende
                          Excel 2016 PowerPivot

                          Back to the overveiw Excel courses

                          Se mulighederne for et firma kursus

                          Referencer

                          "Kurset var rigtig godt tilrettelagt, og så var det en dygtig og kompetent underviser. -- Ole Christian Dalvang, Rambøll Management
                          SE ALLE REFERENCER