EXCEL Pivot table 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 Pivot tables are offered.
Excel Pivot table 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.
Requirements
The course targets people who need to analyze sales, finance, production, logistics, etc. using Pivot tables.
We recommend people who 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 work with large datasets.
Duration
One day: 09: 00-16: 00
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
Company course
- Held in your company
- Up to 12 participants
- Adaptable course content
Solo course
- Held in your company
- Course for you + 1 colleague
- Adaptable course content
Choose between a company-, solo- or open course
Company course
This course is a company course for 3-12 employees from your company. The course is typically held at your location, but can also be in one of our locations, if you prefer that.
The course content can be adapted to your needs and interests.
- Up to 12 participants
- Adapted course content
- Flexible course planning
- Free support after the course
Solo / Duo course
In a solo course you will receive 1:1 education – the course can also be a duo course, where you can bring 1 colleague for free.
We can adapt the course content to your interests and needs. The course will typically be held at your company’s location.
- For you (+ one colleague)
- Adapted course content
- Flexible course planning
- Free support after the course
Open courses
An open course is a course where you participate with course participants from other companies. You can sign up to an open course on a date and location that fits your schedule through our open course calendar. In an open course you will be taught in the planned course content, but you are always welcome to ask questions during the course.
- Max. 8 participants
- Scheduled dates
- Incl. catering
- Free support after the course
Open course calendar
Excel Pivottable1 dag
Excel Pivottable1 dag
Excel Pivottable1 dag
Excel Pivottable1 dag
Excel Pivottable1 dag
Excel Pivottable1 dag
Excel Pivottable1 dag
Excel Pivottable1 dag
Har du spørgsmål?
Vi sidder klar til at hjælpe.
Related courses
Excel Videregående
På kurset lærer du, hvordan du bruger de avancerede funktioner i Excel, så du lettere kan lave beregninger og analyser.
Excel VBA basic course
In this course you will learn how to automate your workflow in Excel using Visual Basic for Application (VBA).
Excel Pivottable course in English
In this course in Excel Pivottables you will learn how to transform large datasets into user-friendly dashboards.
Excel for bogholdere
Lær at automatisere dine rutineopgaver og optimere brugen af Excel til bogholderi og regnskab.