Office Applications and Tools
40 courses available
Office Applications and Tools covers advanced Excel, VBA, Power Query and Power Pivot training — for analysts and business specialists who want to automate reporting and analysis without adopting separate BI tools.
This list is useful for a team stuck at a basic Excel level that needs to move on to macros and data modeling before investing in Power BI or another enterprise-class tool.
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 PLNIntroduction to VBA programming in Excel
Introductory training in VBA programming for Microsoft Excel users who want to automate their work with spreadsheets. The program covers the basics of the VBA language and practical applications for everyday work with Excel. Participants learn to create their own macros and automation routines through hands-on workshops. The training methodology is based on practical examples and exercises that can be directly used at work.
from 1,750 PLNJIRA for Beginners - Practical Workshop
This two-day practical workshop introduces participants to the world of effective use of JIRA through intensive exercises and work with real-world use cases. The training is designed for people starting to work with JIRA who learn best through hands-on experience. The workshop program guides participants through successive stages of working with the system, from basic operations to more advanced usage scenarios. Each module contains minimal theory and maximum exercises.
from 2,450 PLNMicrosoft Project – Effective Schedule Planning
Microsoft Project is one of the most popular tools supporting project planning, execution and control. It enables building clear schedules, managing tasks, tracking progress, and making effective use of project resources. The "Effective Schedule Planning" course introduces participants to the application's core functionality, focusing on the practical aspects of working with the program. During the sessions, participants learn to build and update schedules, define dependencies between tasks, manage resources, and monitor project execution. The knowledge gained enables more effective project planning, better work organization, and optimal use of available time and resources.
from 900 PLNMicrosoft Word basics
The training provides a solid foundation of practical work with the Microsoft Word editor, focusing on everyday office tasks. The program is carried out in a workshop format, where each participant performs exercises at their own computer workstation. Participants learn the most important functions of the program through the implementation of practical examples.
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
Creating presentations for the financial industry
The training focuses on creating professional presentations tailored to the financial industry. During the one-day workshop, participants will learn techniques for effective presentation of financial data and economic analysis. The program includes practical exercises using real-life examples from the financial sector, which allows for immediate application of the acquired knowledge in professional practice.
from 590 PLNEnabling and Managing Microsoft 365
This is a 5-day instructor-led training course (ILT) that targets the needs of IT professionals involved in assessing, planning, deploying and operating Microsoft 365 services, including their identities, dependencies, requirements and supporting technologies. This course focuses on the skills required to configure an Microsoft 365 lease, including federation with existing user identities, and the skills required to maintain an Microsoft 365 lease and its users.
from 3,100 PLNGoogle 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 PLNJIRA system administration: bug tracking and project management
A training course designed to provide a comprehensive introduction to JIRA system administration. Participants will learn how to configure, manage and optimize JIRA for effective bug tracking and project management. The training combines theory and practice, enabling you to gain the skills necessary to effectively use JIRA in your daily work.
from 3,000 PLNKSeF — Preparation and Implementation
Complete preparation for the mandatory Polish National e-Invoicing System (KSeF): choosing an integration model (Taxpayer App, API, ERP), rollout timeline, permission management, and procedures for system outages and offline mode.
from 990 PLNMicrosoft 365 - online office solutions
The two-day Microsoft 365 training introduces participants to the world of modern office productivity tools available in the Microsoft cloud. The workshop program has been carefully designed to show how to effectively use the full potential of online applications for team collaboration and document management. During the class, participants not only learn the basic functions of each application, but most importantly, they learn how to combine them into a cohesive ecosystem that increases productivity for the entire team. The training uses a hands-on approach, where each new concept is immediately tested in real business scenarios, allowing participants to see the direct application of the knowledge they gain.
from 2,450 PLNMicrosoft Copilot - Intermediate Level
This training develops skills in using Microsoft Copilot in daily office work. Participants will learn advanced techniques for creating documents, data analysis, and task automation in Microsoft 365. The program combines theory with intensive practical exercises on real business scenarios. The workshop methodology ensures direct experience working with AI tools in an organizational context.
from 2,000 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 PLNMicrosoft SharePoint - Document Management and Collaboration
A two-day hands-on training on the SharePoint 365 platform and integrated Microsoft 365 applications. Participants will learn effective document management, team collaboration, workspace creation, and document workflow automation with Power Automate. The program also covers version control, access permissions management, and integration with the Office suite and Teams.
from 2,450 PLNMicrosoft Power Platform - Power Apps, Power BI, Power Automate
Microsoft Power Platform training enabling the creation of business applications, automation, and analytics without coding. The program combines all platform components into a cohesive whole ensuring maximum productivity. The workshop focuses on practically building solutions that address real business needs. The practical methodology ensures immediate application of acquired skills in the organization.
from 4,800 PLNMS Project for software managers
Specialized training in the use of MS Project in the context of software development project management. The program focuses on adapting the functionality of the tool to the specifics of IT projects, taking into account agile and traditional methodologies. Participants, through practical workshops, learn techniques for planning and monitoring software projects and integrating the tool into software development processes. The classes are conducted in the form of interactive workshops on real cases from the IT industry.
from 1,800 PLNMS Teams (remote training)
Learn about using MS Teams for remote work. Learn how to create teams, communicate, manage files and schedule meetings. Ideal for those working in the MS cloud.
from 490 PLNPostman
Learn the basics of using Postman. Learn how to create and test REST queries, manage environments, and automate API verification. Ideal for developers and testers.
from 2,450 PLNSoapUI
SoapUI course - learn how to test web services using the SoapUI tool to ensure their quality and reliability.
from 2,450 PLNVBA for business analysts
The training is designed specifically for business analysts who want to increase their efficiency by automating analytical processes in Excel. The program combines practical learning of VBA programming with real use cases in business analysis. Participants will learn techniques for creating analytical tools and automating repetitive tasks to significantly increase productivity. The training methodology is based on practical workshops, where each issue is immediately used in the context of real analytical tasks.
from 1,750 PLNAdvanced
Advanced PowerPoint for sales teams
Designed specifically for sales teams, the training focuses on creating effective presentations in Microsoft PowerPoint. During an intensive workshop day, participants will learn advanced techniques for presenting sales data and sales proposals. The program combines practical exercises with real-world examples from the sales industry, allowing participants to immediately apply the knowledge they have gained to their daily work.
from 650 PLNAdvanced slide design in PowerPoint
The one-day training focuses on advanced aspects of visual design in Microsoft PowerPoint. During the intensive workshop, participants will learn professional techniques for creating visually appealing presentations using the program's advanced tools. The program combines theoretical design fundamentals with practical exercises, where trainees work on real-life examples under the guidance of an experienced trainer. The training places special emphasis on the aesthetic and functional aspects of the designed slides.
from 650 PLNAdvanced techniques in Word
The training deepens knowledge of advanced Microsoft Word features, focusing on automating and optimizing work with complex documents. The program is delivered in the form of intensive hands-on workshops, where participants work on real examples of business documents. The class focuses on increasing work efficiency through the use of the editor's advanced tools.
from 850 PLNAdvanced VBA techniques in Excel
The training is dedicated to people who want to develop their VBA programming skills at an advanced level. The program focuses on creating complex Excel automation solutions using advanced programming techniques. Participants will learn code optimization methods and best practices in creating scalable applications. Classes are conducted in a workshop format, where theory is immediately verified in practical tasks.
from 1,200 PLNData analysis in Excel
The training is dedicated to people who want to develop their skills in data analysis using Microsoft Excel. The program covers advanced techniques for analyzing, visualizing and interpreting business data. Participants will learn tools and methods to extract valuable information from large data sets. The classes are conducted in a workshop format, where theory is immediately translated into practical applications using real business cases.
from 900 PLNEffective virtual meetings with MS Teams
Practical training in conducting effective virtual meetings using the Microsoft Teams platform. The program focuses on advanced features of the platform and techniques for conducting engaging online meetings. Participants, through practical workshops, will learn methods of organizing and moderating meetings, using interactive tools and managing group dynamics in a virtual environment. Classes are conducted in the form of intensive workshops, where theory is immediately verified in practical exercises.
from 1,850 PLNExcel - 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 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 PLNFinancial analysis in Excel
The training focuses on the use of Microsoft Excel in financial analysis. The program covers the practical application of Excel tools in assessing a company's financial position, ratio analysis and financial modeling. Participants learn to create professional financial models and conduct advanced analysis using financial functions. Classes are conducted on the basis of real cases and financial scenarios, which allows immediate application of the acquired knowledge in practice.
from 900 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 PLNMicrosoft Project – Effective Schedule Planning and Project Execution Control
Microsoft Project - Schedule Planning and Execution Control is a comprehensive training program combining fundamental and advanced topics, giving participants full, practical competence in working with MS Project. The course leads step by step from building simple schedules, defining task dependencies, and working with resources, through to advanced resource leveling techniques, cost control, progress tracking, and variance analysis in project execution. Participants learn to build calendar templates, modify assignments, create custom views, tables, reports, and custom fields, and to work with multiple projects and a resource pool. The program also covers exporting data to MS Excel for further analysis and reporting. With its comprehensive approach, the training prepares participants for independent, informed project management – from planning through execution to controlling schedule, cost and resources.
from 2,400 PLNMS Project and MS Project Server - project portfolio management
Advanced training in project portfolio management using MS Project Server and MS Project Professional. The program focuses on the effective use of the project environment to manage multiple projects and resources at the organization level. Participants learn techniques for project coordination, resource optimization and portfolio-level reporting through hands-on workshops. The classes combine theory with intensive exercises on real project scenarios, allowing immediate application of the knowledge gained in practice.
from 1,800 PLNPowerPoint and Camtasia in marketing
The training combines advanced techniques for creating PowerPoint presentations with professional video editing skills in Camtasia. The program focuses on the practical use of both tools in marketing activities, with particular emphasis on creating educational and promotional materials. Participants learn to design engaging presentations and transform them into professional video content.
from 1,200 PLNProject management with Microsoft Project
Microsoft Project – Project Management is designed for professionals who want to make full use of one of the leading tools for planning and controlling projects. Participants explore the application's advanced features, including resource leveling, working with constraints and deadlines, building baselines, and tracking schedule and cost variance. The course also covers working with multiple projects, building custom tables, reports and custom fields, and exporting data to MS Excel. Through hands-on exercises, participants learn to manage tasks, resources and costs effectively, control project execution, and tailor the MS Project working environment to their needs.
from 1,800 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 PLNCan't find the right training?
We design custom training programs. Describe your needs and we'll prepare a tailored offer.
Ask about training