Ten serwis używa plików cookies. Brak zmiany ustawień przeglądarki oznacza zgodę na ich używanie.
Więcej informacji o plikach cookies znajdziesz tutaj
Kliknij ZGADZAM SIĘ, aby ta informacja nie wyœwietlała się ponownie
You are here: home pageExcel TrainingExcel Pivot Tables Training

Excel Pivot Tables Training

Will the Excel Pivot Tables Training be suitable for me?

The Excel Pivot Tables training is for those who:

  • want to learn how to proficiently use pivot tables,
  • want to speed up and improve their work and enhance their knowledgeand optimise time required for report building and performingmultidimensional analyses.



After the Excel Pivot Tables Training you will know how to:

  • properly prepare data to be laterused in a pivot table,
  • present values as non-standardnumbers and aplying calculation.





What makes us different from other training companies?



Training needs surveys

Before training, we ask you to specify your expectations and analyse your needs. This way, our trainer will be able to suggest the most suitable kind of training for you and modify the programme according to your needs.



Training materials

As a participant of our training, you will receive a complete set of carefully developed training materials including:

  • A reference book discussing the issues covered by the training and providing a "step-by-step" description of the respective exercises,
  • Unlimited electronic access to exercises and training materials within the framework of the Cognity Knowledge Zone.



Having completed a training course, you will receive a certificate confirming the qualifications you gained. The back side of the certificate lists the programme of your training. Cognity certificates are issued pursuant to an entry in the Register of Training Institutions (no. 2.12/00106/2011).



The comfort of learning

In order to ensure optimum learning conditions, we organise training courses in small groups of no more than 10 participants. We will prepare an individual computer station for you, too.



Post-training assistance

Having completed our training course, you will be offered the assistance of our trainer. If you have any doubts or questions concerning the subject-matter of your training, you can call us, e-mail us or arrange a personal meeting (in our company) with the trainer, who will be at your service.



No matter where you choose to have your training...

We offer, as extra service, assistance in finding the right accommodation or restaurant for you and we can organise other attractions as well.

Training courses include lunch and coffee breaks.

Excel Pivot Tables Training programme

Correct preparation of data

  • proper form of source data,
  • importing data from a text or a web page,
  • correction of an incorrect decimal separator in datasets fromdatabases or accounting applications.

Creating a pivot table

  • building a pivot table – a field list, row and column headers , values,the values filter, embedding and moving a pivot table,
  • selecting source data to a pivot table,
  • adding multiple fields to rows, columns, values and the report filter,hiding and displaying data in a pivot table,
  • changing pivot table field names, changing pivot table data source,refreshing source data of a pivot table,
  • displaying filtered data in separate sheets.

Pivot table formatting

  • layout and style of a pivot table,
  • formatting the displayed data.

Various ways to display numeric values in a pivot table

  • different ways to summarize pivot table data,
  • showing values as non standard calculations,
  • pivot table data formatting.

Grouping data in a pivot table

Calculated fields and items

Sorting data in a pivot table

  • manual sorting, alphabetical sorting,
  • sorting by a custom list.

Data filtering in a pivot table

  • custom filters, slicers.

Drill down i.e. getting down to details

Creating advanced pivot tables

  • creating a pivot table out of many consolidated source data ranges,
  • a pivot table based on external data,
  • refreshing source data in pivot tables.

Pivot charts

Day 1

Registration 9:00 - 9:15
Classes 9:15 - 11:00
Break 11:00 - 11:15
Classes 11:15 - 12:30
Lunch 12:30 - 13:15
Classes 13:15 - 14:30
Break 14:30 - 14:45
Classes 14:45 - 16:00

Upcoming dates

DurationNet:8 godzin lekcyjnych / 1 dzień
Price per person:900 zł
Contact phone:12 421 87 54
Application Form
for Training (PDF)
Program (PDF)

Selected clients: