Course objectives

Ability to use advanced methods of data analysis, reporting transforming data sets into sets of information. The ability to present information in an efficient manner.


Workshop participants will learn:

  • advanced features of the program
  • how advanced data analysis
  • possibilities for efficient data management

Students will gain detailed knowledge to:

  • data validation
  • using advanced formulas
  • using MS Solver
Training scope
  • Advanced formula
  • Naming cells, advanced work with cells named.
  • Conditional Formatting
  • Forms
  • Advanced filters
  • Subtotals after a few categories
  • Data Validation
  • Sharing a workbook
  • Change Management
  • Data protection
  • Pivot Tables and Pivot Charts
  • The connection to the database, query databases
  • Macros. Create, edit and run macros
  • Manager scenarios
  • Tools MS Solver and Analysis Toolpak
  • The window detector

This range is the basis for the classes and may be subject to slight changes depending on what the individual preferences of the group.


People who have good knowledge of MS Excel environment (addressing modes cells, sorting, autofilter, the ability to use basic functions: SUM, AVERAGE, MIN, MAX).

The number of participants: 8-15 people

Duration: 2 days

Available language: PL / EN

Available course material: PL / EN

Course form
Mix of presentation, hands-on exercises.

Download materials


Thank You!

Sorry, something went wrong.

Please refresh the page and try again.


Contact our expert with questions

about any of our trainings

Agnieszka Rzeczkowska

Training Practice Manager


Agnieszka Rzeczkowska

or drag and drop your file here

Allowed extensions: DOC, DOCX, PDF (max 5MB)

Thank you for filling out the form

We will look over your message and get back to you as soon as possible

Sorry, something went wrong and your message couldn’t be delivered

Please refresh the page and try again


You might also like

MS Office

MS Excel intermediate

2 days
MS Office

MS Excel VBA

2 days
MS Office

Microsoft Word + Microsoft PowerPoint

1 day
MS Office

MS Excel basics

2 days

ITIL® and PRINCE2® are registered trademarks of AXELOS Limited, used under permission of AXELOS Limited. All rights reserved.
AgilePM® is a registered trademark of Agile Business Consortium Limited.
All AgilePM® Courses are offered by Sii, an Affiliate of Quint Wellington Redwood, an Accredited Training Organization of The APM Group Ltd.
Lean IT® Association is a registered trademark of the Lean IT Association LLC. All rights reserved. Sii is an Affiliate of Accredited Training OrganizationQuint Wellington Redwood.
All prices presented on the website are net prices. 23% VAT should be added.


Ta treść jest dostępna tylko w jednej wersji językowej.
Nastąpi przekierowanie do strony głównej.

Czy chcesz opuścić tę stronę?

Einige Inhalte sind nicht in deutscher Sprache verfügbar.
Sie werden dann auf die englische Sprachversion der Website weitergeleitet.

Möchten Sie fortsetzen?