Features
| Name | Value |
|---|---|
| Additional materials: |
|
| Certification: |
|
| Number of training hours: |
|
| Producer: | |
| Training level: |
|
| Type of training: |
|
| Name | Value |
|---|---|
| Date of training: |
|
| Miejsce szkolenia: |
|
Description
We are a dynamically growing training group with a fresh perspective on established solutions in the IT industry. Expose is backed by individuals with many years of experience and passion, and the company's mission is to enhance the quality and efficiency of your work.
The Advanced Microsoft Excel course is designed for individuals who use Excel on a daily basis. It is also a continuation of the Intermediate Excel course. During the training, advanced tools are used to operate on large data sets. Participants will learn how to effectively use Excel tools that will significantly speed up and automate their work with the program.
The Advanced Excel training is intended for those who already know the basics of the program and want to deepen their knowledge and skills. It is a proposal for those who work daily with large data sets, create reports, analyze information, or want to improve their work through automation and advanced Excel tools.
The Advanced MS Excel training prepares participants for independent work in Microsoft Excel. The goal is to effectively utilize the tools available in Excel in professional work.
The training allows for a better understanding and application of advanced functions such as XLOOKUP, conditional functions, pivot tables, Power Query, and Power Pivot. This facilitates making informed decisions based on data and increases the accuracy and clarity of analyses.
- Advanced formulas in Excel
- Data formatting
- Working with Tables
- Pivot tables and charts
- Data tools
- Macros and basics of VBA
16 hours
The training is conducted by a Certified Microsoft Trainer (MCT), ensuring a high level of expertise and professional approach. Participants receive proprietary training materials in both paper and electronic versions, with a one-year access to the online training platform. Upon completion of the training, each participant receives a certificate confirming the skills acquired. Additionally, we provide individual recommendations for further development in the area of Excel, as well as the possibility of consultations with the trainer for three months after the course ends – in case of questions or doubts. A full-day coffee service and lunch are also available on-site.