Course offer

Microsoft Excel - Basics

Microsoft Excel - Advanced A

First use of functions and diagrams

Microsoft Excel - Advanced B

Dealing with complex functions and macros

Also as
online course!

Microsoft Excel – Pivot for advanced users

Back to the main page

Duration:	1 day
Target group:	Advanced Excel users
Target:	Introduction to the Excel BI professional tool Power Query. They learn how to generate queries without using code in Excel and how to create sophisticated reports and visualizations
Prior knowledge:	Extend existing knowledge of pivot tables and charts
Content:	Refresh pivot tables and pivot diagrams Nature of the basic data for the pivot table Pivot table and chart creation Improved data consolidation Deepening the possibilities Manual and automatic grouping of data Drillthrough / Drilldown – temporary data extracts Automatic sheet generation from report filter fields Multiple value fields and value field settings Automatic sorting of row / column fields Basic pivot table settings Pivot from multiple files Further calculations User-defined calculations for data fields Calculated fields and elements Access to data with pivot data assignment Work on the pivot diagram Finding the right diagram types

You have mastered the Excel basics and many advanced topics? Are you familiar with pivot tables?

This seminar offers a continuation of the knowledge about pivot tables and pivot diagrams as well as consolidation-
possibilities with Excel. Deal confidently with pivot tables, formulas and data analysis. Improve
Your Excel skills with our courses.

Course offer

Microsoft Excel – Pivot for advanced users

Company

Information

Support

Partnerships