EXPO Katowice S.A.

Excel Pivot Tables

23.10.2023

Excel Pivot Tables

The course fills the gap between substantive knowledge in the field of business data analysis and knowledge related to the advanced use of Microsoft Excel.
The proposed workshop consists of two days of intensive classes.

Target group

The Excel PivotTables workshop is intended for people who use spreadsheets intensively and know the basics of using Excel well.

Training methods

The course is conducted using modern, interactive methods, using a multimedia projector, with the active involvement of participants. All exercises are conducted based on examples taken from practice. Despite presenting complex substantive knowledge, the classes are conducted in an understandable way, ensuring that each course participant absorbs the knowledge provided.
Each participant receives a set of materials and electronic copies with all exercises conducted as part of the course and sample Microsoft Excel sheets.

Training program

Day 1 and 2 - 9:00 - 15:30 - details

The workshop program includes, among others, the following topics

Comparison of Excel versions 2007, 2010, 2013, 2016 to 2019, file types, program development, differences and common features, communication between different versions of the spreadsheet, specificity of using the application in the company’s financial services
History of pivot table development
Optimal “personalization” of the work program, advanced Excel settings options
Use of local and global names, declaring dynamic names, using names in formulas
Technologies for downloading data from external sources (Excel data sources, database queries, using the MS Query module, downloading data from various sources, using the Internet – data in XML format)
Using pivot tables as a business data analysis tool, principles of creating pivot tables
Create and modify PivotTables based on different data sources, custom calculated fields, data grouping, custom data formatting in PivotTables, conditional formatting in PivotTable
Use of slicers for advanced presentation of business data, presentation of data over time
Database functions, examples of practical applications, selection of criteria, alternative and conjunction of criteria
Sheet protection, workbook protection, data validation
Graphical presentation of financial data using charts (complex charts, charts presenting multiple data series, trend analysis on a chart, non-standard charts, charts based on data from pivot tables),

Benefits of training

After completing the training, participants will be able to apply the acquired knowledge to creative data analysis and to build models thanks to which decision-making will be based on reliable and accurate data. Learning advanced techniques for using Microsoft Excel will make your everyday work easier and more effective.

After completing the training, each participant is able to:

Certificate

After the training, the participant will receive a certificate confirming participation in the training and acquired knowledge.

Coach

Janusz Gach

He has been providing training for years, explaining the intricacies of spreadsheets and accessibly showing the possibilities behind them. He specializes in Microsoft Excel, as well as other elements of the MS Office suite. His training courses are aimed at employees in the financial sector, as well as other office workers, engineers, salespeople of various professions. The trainer’s training courses and classes are used by all who wish to expand their practical use of the spreadsheet: both at a basic and more advanced level.

Current trainings