Excel Pivottable course in English
Excel Pivottable Course - conducted 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
- 1 dag kl. 9:00 - 16:00
- 3.650 kr. ex. moms
-
Kurset tilbydes også som
solo- eller firmakursus
Excel Pivottable1 dag
Excel Pivottable1 dag
Excel Pivottable1 dag
Excel Pivottable1 dag
Course 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
What you get from the course
Breakfast, lunch,
coffee, tea, cake.
The material can be used as a reference in the future.
After completing the course, you will receive a course certificate.
Even after the course is over, you can always get help.
How we teach
In our courses, the teaching will alternate between theory and practice. We place a high value on active learning in our teaching. This means that even during a review of new topics, you will be actively engaged on the keyboard along with the instructor, followed by a series of tasks you need to complete.
Meet the course instructors.
Related courses
After this course, we recommend that you take our course in Excel PivotTables. You can see the entire Excel course overview here.
Also, check out our Excel courses in Excel Courses in Copenhagen and Aarhus
