Advanced Excel Training
Advanced Excel training covers analytical functions and pivot tables, importing and transforming data with Power Query, building data models in Power Pivot, and automating repetitive tasks with VBA macros. The program runs from advanced formulas to independently building reports that combine data from multiple sources without writing code. This page is part of the Office Applications and Tools subcategory in EITT's Technologies training catalog, alongside VBA — Excel remains the starting point for most analytical teams before they move to a dedicated BI tool, such as Power BI in the Data and Analytics subcategory.
19 courses available
Beginner
Excel basics
The introductory Microsoft Excel training course is designed for people new to spreadsheets and those who want to systematize their knowledge. The program covers the fundamental aspects of working with Excel, from basic navigation to creating simple formulas and charts. Classes are conducted in a workshop format, where each new issue is immediately practiced in practice, allowing participants to quickly learn the skills necessary for everyday office work. The teaching methodology is based on a gradual building of competence, from the simplest operations to more advanced applications.
from 750 PLNWord and Excel basics
An introductory training course for working effectively with the basic tools of Microsoft Office. The program is designed to get participants up and running quickly with text documents and spreadsheets. The class combines theoretical elements with practical exercises that reflect real situations in an office environment. The workshop is conducted in an interactive manner, with an emphasis on the practical application of the functions learned.
from 800 PLNIntermediate
Google Sheets for Excel users
Practical workshop training for Microsoft Excel users who want to work effectively in the Google Sheets environment. The course program is designed to use participants' existing Excel knowledge as a starting point for exploring the capabilities of Google Sheets. The training pays special attention to the unique features of Google Sheets related to working in the cloud and team collaboration. The class is conducted in a workshop format, where each topic is discussed through comparison to its Excel counterpart.
from 1,800 PLNMicrosoft Excel - Business Intelligence Module
Practical training on advanced analytical functions in Microsoft Excel, focusing on Business Intelligence tools. Participants will learn advanced data analysis techniques, report and dashboard creation, and automation of analytical processes. The course covers practical application of Power Query, Power Pivot, and other BI tools available in Excel, enabling participants to independently create advanced analytical solutions.
from 900 PLNMicrosoft Excel - Effective calculations and data presentations
Learn effective calculations and data presentation in Excel. Learn advanced formulas, data analysis, charting and formatting. Ideal for intermediate level Excel users.
from 900 PLNMicrosoft Excel - VBA programming in analysis and reports
Learn VBA programming in Excel for analysis and reports. Learn to create macros, manage data, create custom functions and user forms. Ideal for Excel analysts and professionals.
from 2,400 PLNMultidimensional data analysis using MS Excel and Power BI
The main goal of the course is to teach how to efficiently, quickly and effectively compile data from various sources for further analysis and reporting. In addition, the course teaches how to use the tools available in MS Excel and Power BI, which will allow you to streamline and automate tasks without having to learn VBA programming. The goal of the training is to learn how to prepare multidimensional analysis and reports.
from 5,100 PLNAdvanced
Excel - advanced course
The two-day Microsoft Excel advanced training course is designed to develop expert spreadsheet skills. The workshop program covers advanced techniques for data analysis, business modeling and process automation. Participants work on complex business examples, learning to use the full potential of the tools available in Excel. The training uses a workshop methodology, where each issue is immediately translated into practical applications, and participants have the opportunity to consult their own cases with an experienced trainer.
from 1,200 PLNExcel advanced with VBA
The three-day training in advanced Excel functions and VBA programming is designed to enable participants to create their own spreadsheet automation solutions. The workshop program combines advanced Excel techniques with the basics of VBA programming, allowing participants to create personalized tools and applications. Participants work on real-life examples, learning to identify processes that require automation and implement appropriate solutions. The training methodology is based on a hands-on approach, where each new concept is immediately applied in exercises.
from 1,750 PLNExcel and VBA programming for audit and finance professionals
The training is dedicated to audit and finance professionals who want to increase the efficiency of their work through advanced use of Excel and VBA. The program covers the creation of specialized tools for automating audit and financial processes. Participants learn to implement advanced solutions taking into account the specifics of work in the area of finance and audit. Classes are conducted in the form of intensive workshops, where theory is immediately verified in practical tasks in the financial area.
from 2,350 PLNExcel in statistical analysis of data
The two-day training provides a practical approach to using Microsoft Excel in statistical data analysis. The workshop program covers both basic and advanced statistical methods, with particular emphasis on their practical application in a business environment. Participants work on real data sets, learning to interpret results and draw business conclusions. The training methodology is based on practical exercises, where each participant performs analyses independently under the guidance of an experienced statistician.
from 900 PLNExcel modeling
The training focuses on advanced data modeling techniques in Microsoft Excel, with particular emphasis on creating business and financial models. The program covers the design and implementation of complex analytical models to simulate various business scenarios and support decision-making. Participants will learn best practices in modeling, from data structuring to advanced sensitivity analysis. Classes are conducted in the form of intensive workshops, where theory is immediately verified in practical tasks using real business cases.
from 1,850 PLNExcel on steroids: Discover the magic of AI in data analysis!
\Excel on Steroids: Discover the magic of AI in data analysis!\ is an innovative training course that combines traditional Excel skills with the powerful capabilities of artificial intelligence. In the digital age, where data is a key resource, the ability to analyze it effectively is becoming essential. Our training opens the door to the fascinating world of AI, demonstrating how advanced algorithms can revolutionize everyday work with spreadsheets.
from 1,500 PLNMicrosoft Excel - Advanced Tools
Learn advanced Excel tools. Master addressing, advanced formulas, data analysis, and chart creation. Ideal for advanced users.
from 1,050 PLNMicrosoft Excel - intermediate level
The two-day intermediate level Microsoft Excel training focuses on increasing efficiency in working with spreadsheets. The workshop program is designed to take participants from basic knowledge of the program to the free use of its advanced features. During the class, trainees work on practical examples that reflect real business scenarios. The training is conducted in an interactive format, where each new issue is immediately consolidated through practical exercises.
from 1,100 PLNMigration from Excel to Power BI
The training is designed for people who want to migrate their analytics from Excel to the Power BI environment, retaining existing functionality while taking advantage of advanced data visualization and analysis capabilities. The program covers the migration process, from data preparation in Excel, through its import and transformation in Power BI, to the creation of interactive reports. The class is conducted in a workshop format, where participants work on real business cases, learning how to effectively transfer their analytical solutions to a new environment. The training places special emphasis on the practical aspects of migration and optimization of analytical processes.
from 1,050 PLNProgramming in R for Excel users
The training is designed for Excel users who want to extend their analytical capabilities with advanced statistical analysis using the R language. The program combines practical learning of programming in R with real-world applications in business data analysis. Participants will learn how to effectively use R to perform tasks that are difficult or time-consuming in Excel. Classes are conducted in the form of intensive workshops, where theory is immediately verified in practice using real data sets. The teaching methodology focuses on building practical programming skills in the context of data analysis.
from 1,400 PLNPython in Excel - automation and data analysis
The training combines the capabilities of Microsoft Excel with the potential of the Python language for analyzing and automating data processing. The program is designed for people who want to use Pythons advanced capabilities to extend Excels functionality. Participants learn how to integrate the two tools to create advanced analytical solutions. The classes are conducted in the form of practical workshops, where theory is immediately translated into real-world applications in the field of data analysis. The training focuses on the use of libraries such as pandas, numpy and process automation between Python and Excel.
from 2,450 PLNVBA programming in Access and Excel - a synergy of tools
Advanced training combining the VBA programming capabilities of Microsoft Access and Excel, focusing on creating integrated business solutions. Participants will learn techniques for effective communication between applications and process automation using both tools. The program is delivered in the form of practical workshops with an emphasis on real business scenarios.
from 1,750 PLNFrequently Asked Questions
What Excel training does EITT offer?
We offer training in advanced functions and pivot tables, Power Query for importing and cleaning data, Power Pivot for building data models, and automating tasks with VBA macros.
How does advanced Excel differ from basic Excel?
The advanced course assumes knowledge of basic formulas and focuses on pivot tables, lookup functions, Power Query, and building data models that combine multiple sheets or sources.
When should I move from Excel to Power BI?
Consider Power BI once your data outgrows a spreadsheet, you need interactive dashboards shared across a team, or you need automatic refresh from multiple data sources.
Can't find the right training?
We design custom training programs. Describe your needs and we'll prepare a tailored offer.
Ask about training