The purpose of the training is to broaden the knowledge on the use of PivotTable in Excel program.
PivotTable is an easy and friendly tool for Excel users. It provides invaluable help while creating reports, sets or analyses of any kind. Considering simple methods of applying it, the simplicity of creation and the possibility of making calculations rapidly, it constitutes a highly effective working tool.
The training participants will be acquainted with the methods of working with large data sets and how to analyze them with a Pivot Table. Strong emphasis is placed on preparing data in such a way that reports and sets can be made of them with the use of a Pivot Table. We discuss the management of databases (large data sets), the methods of importing data to Excel, which can significantly shorten the time of preparing analyses.
The main part of the training, apart from data preparation, is also working with pivot tables. The stress is put largely on the possibility of data analysis quickly with the use of PivotTable as well as on its advanced functions, with which we are able to obtain multiple report results.
Particularly, we present here the possibility of entering formulas into PivotTable as well as the ability to combine multiple data sets with the use of this tool.
We also discuss how to create Pivot Charts and the methods of formatting them. The training is designed for all those, who make reports, sets and analyses and want their results to appear quickly although they work on large data sets. The course is also aimed at those, who would like to expand their Excel knowledge on the creation of PivotTables.
The training is based primarily on practical exercises, which are performed by the participants during the classes. Specially prepared sheets, with a great amount of data, have been constructed in such a way that all the participants will be able to acquire the skills in working with large sets of data as well as in analyzing them using a PivotTable.
A crucial element of the training is also the possibility of working with data, which are sent to our lecturers earlier by those who are intending to take part in the course. Such a procedure will allow, during the course, to tackle those issues, which can appear while working with data and, additionally, ensures an individual approach towards each participant.
The training has the form of computer workshops. The participants of the course perform practical exercises according to the lecturer’s instructions. Each training topic is presented in the form of practical exercises. With specially devised didactic methods, every participant is treated individually and every effort is made to solve any problems, occurring during the work with Pivot Tables.
The participants of the course receive training materials in the form of:
- Script prepared by AkKom specialists,
- Practical exercises on Excel.
The confirmation of being trained is the certificate, which is given to every participant when the course has ended.
After the training, each participant may contact the lecturer in order to solve any problem which bothers them. The contact with the trainer is free-of-charge exclusively for our trainees up to 12 months after completing the course.
Introduction to Pivot Tables and Charts
- What are pivot tables?
- Benefits and advantages of using pivot tables and charts
- The cons of using pivot tables and charts
Creating a pivot table
- Preparing data
- Changing regular data into a table
- Creating PivotTable from a table and regular data
- Classic PivotTable layout
- Example of designing PivotTable report
Basic operations on PivotTable
- Activating and deactivating PivotTable field list
- Modifying the window of PivotTable field list
- Refreshing a PivotTable
- Displaying source data
- Converting PivotTable into range
- Deleting a PivotTable
Simple operations on PivotTable
- PivotTable fields
- Sorting PivotTable data
- Grouping PivotTable data
- Data filtering in a PivotTable
- Changing PivotTable report layout
- Enabling and disabling subtotals and grandtotals
- Changing PivotTable labels
- Formatting PivotTable cells
Advanced work with PivotTable
- Changing PivotTable concatenate functions
- Using custom calculations in a pivot table
- Using formulas in PivotTables
- Conditional formatting of PivotTable
- Creating PivotTable from multiple consolidated ranges
PivotCharts
- Creating PivotChart using PivotTable
- Changing PivotChart type
- PivotChart formatting
Zapisz się na interesujący Cię termin szkolenia
There are currently no training dates
Rapid acquisition of knowledge by our participants is ensured through workshops and practical exercises, which are the main form of the training. The exercises, constructed by our specialists, have been compiled in such a way that each participant can learn both the elementary and advanced operations on PivotTables.
Through the possibility of conducting the training on worksheets with Excel data, which the participants can sent to the lecturer before the beginning of the course, those, who take part in the training, are able to perform exercises and, simultaneously, solve problems regarding pivot tables. With such a method, there is high efficiency of learning process. As a result, the exercises done during the training allow to turn the knowledge into practice more effectively and the trainees are able to use the gained skills in everyday work immediately after the training.
Favourable technical conditions of our training classes have a great influence on working comfort as well as the rapidity of acquiring knowledge during the training in Excel Pivot Tables.
Our company guarantees all the versions of Excel program, beginning with the 2003 one and ending with 2010, in order to provide each participant with the edition which is used by them in everyday work. A computer station together with exercises, prepared under work profile, awaits every training participant. A small number of training group – up to 10 people – ensures an individual approach towards each participant. Consequently, the lecturer is able to focus his or her attention on every trainee.
There are 6 didactic hours intended, starting at 8:30 a.m. to 1:30 p.m. Two 15-minute breaks are also included, during which the participants have coffee and sandwich catering at their disposal.
The training in the use of PivotTables in Excel program is also carried out in the form of a “tailored training”. This particular course can be conducted in the Client’s headquarters, which is allowed by mobile training facilities owned by us. Such a training is organized for persons from a single company and it must involve at least 6 trainees.
