Excel Training in Bratislava

Excel is a powerful spreadsheet application designed for data entry, analysis, reporting, and automation.

This instructor-led live training, available both online and onsite, is tailored for users ranging from beginner to advanced levels. It aims to help participants build confidence and proficiency in Excel’s essential, intermediate, and advanced capabilities.

Upon completing this training, participants will be able to:

• Confidently work with spreadsheets, formulas, and formatting.
• Utilize intermediate tools such as tables, charts, and conditional logic.
• Apply advanced functions, data analysis features, and automation techniques.
• Create professional worksheets that support business decision-making.

Course Format

• Instructor-led demonstrations and guided explanations.
• Extensive workbook exercises and hands-on practice.
• Practical lab activities using real-world spreadsheet scenarios.

Course Customization Options

• For tailored coverage based on your department’s workflows, please contact us to arrange a customized version of this course.

Excel is a widely utilized spreadsheet application designed for organizing data, performing analysis, and automating processes.

This instructor-led live training, available online or onsite, targets intermediate Excel users who want to leverage Excel for inventory control, budgeting, reporting, and automation using real-world datasets.

Upon completing this training, participants will be able to:

• Utilize formulas such as SUMIF, IF, VLOOKUP, and SUMIFS for inventory and purchasing scenarios.
• Efficiently manage and analyze large datasets containing over 5,000 rows.
• Create and interpret pivot tables for monthly and cumulative tracking.
• Automate repetitive reporting tasks using macros.
• Monitor material purchases against consumption using structured templates.

Course Format

• Interactive lectures and discussions.
• Extensive exercises and practice sessions.
• Hands-on implementation in a live-lab environment.

Customization Options

• To request tailored training for this course, please contact us to make arrangements.

This instructor-led, live training in Bratislava (online or onsite) targets data analysts ranging from beginner to advanced proficiency levels who aim to leverage Excel for various tasks, including data entry, formula creation, data analysis, and advanced automation.

Upon completion of this training, participants will be able to:

• Navigate Excel’s interface and execute basic data entry, formatting, and calculations.
• Implement advanced formulas, functions, and conditional formatting for effective data analysis.
• Build and manage pivot tables and charts to visualize data.
• Utilize tools such as Power Query and Power Pivot to enhance data analysis.
• Streamline workflows by automating tasks using macros and VBA.

This instructor-led, live training in Bratislava (online or on-site) is designed for beginner to intermediate-level professionals who wish to enhance their productivity and efficiency by leveraging the advanced features of Excel and Google Sheets for data organization, analysis, and collaboration.

By the end of this training, participants will be able to:

• Navigate and utilize the core features of Excel and Google Sheets.
• Perform data analysis and create actionable insights using advanced spreadsheet techniques.
• Collaborate in real-time using Google Sheets for seamless teamwork.
• Create reusable templates for reporting, tracking, and project management.

This instructor-led, live training in Bratislava (online or on-site) is aimed at data analysts or anyone who wants to learn how to use Excel for creating data models for data analysis.

By the end of this training, participants will be able to:

• Learn to analyze and solve any business problems using structured problem-solving tools.
• Navigate Excel tools with ease.
• Set up, format, and present data effectively.
• Understand the logical structure and apply correct functions to Excel models.

Participants will gain the ability to efficiently utilize core data analysis tools such as scenarios and pivot tables, leverage date calculation features and text-processing functions, and create and customize macros to automate spreadsheet workflows.

Excel is a popular spreadsheet program developed by Microsoft. It is used to store, organize, and analyze data in tabular form. Here are some key features and functions of Excel:

1. Spreadsheets:
It consists of sheets, where each sheet is a grid made up of cells arranged in rows and columns.
It allows you to create multiple sheets in one file, which helps organize different sets of data.
2. Calculations and formulas:
It enables you to perform various mathematical, statistical, and logical calculations using formulas.
It has a wide range of built-in functions, such as SUM, AVERAGE, MAX, MIN, IF, VLOOKUP, etc.
3. Data formatting and appearance:
It provides tools for formatting data, including changing fonts, colors, styles, and creating charts, pivot tables, and diagrams.
4. Sorting, filtering, and grouping:
It allows you to sort data according to specific criteria.
It allows you to filter data to display only selected information.
It is possible to group data according to your needs.
5. Data analysis:
Tools for performing advanced analyses, such as scenario analysis, trend analysis, forecasting, and creating macros.
6. Sharing data:
It allows you to share and collaborate on data in real time, enabling multiple users to work on the same data simultaneously.
7. Task automation:
It is possible to create macros and automate tasks using the VBA (Visual Basic for Applications) programming language.

Excel is widely used in various fields, from business to science and education. Its versatile functions allow data analysis, report creation, budgeting, scheduling, data management, and many other applications.

This instructor-led, live training (online or onsite) is designed for data analysts who wish to utilize advanced VBA in Excel to automate tasks.

By the end of this training, participants will be able to:

• Write an advanced object-oriented application
• Convert text files
• Use of external data sources
• Use external libraries

This instructor-led, live training (available online or onsite) is designed for data analysts looking to utilize VBA in Excel for task automation.

By the end of this training, participants will be able to:

• Record and edit macros as required.
• Write procedures using data from the sheet.
• Create your own functions.
• Handle an event (opening worksheet cell update etc.) by means of the handler.
• Create a form.

This instructor-led live training in Bratislava (available online or onsite) is designed for data analysts who want to leverage VBA in Excel for task automation.

By the end of this training, participants will be able to:

• Record and edit macros as required.
• Write procedures utilizing sheet data.
• Create custom functions.
• Handle events (e.g., worksheet opening, cell updates) via handlers.
• Create forms.

Target Audience

Analysts, researchers, scientists, graduates, and students, as well as anyone interested in learning how to streamline statistical analysis using Microsoft Excel.

Course Objectives

This course aims to enhance your proficiency with both Excel and statistical concepts, thereby increasing the effectiveness and efficiency of your work or research.

Participants will learn how to utilize the Analysis ToolPak in Microsoft Excel, leverage statistical functions, and perform fundamental statistical procedures. The course also covers the limitations of Excel and strategies to overcome them.

This instructor-led, live training in Bratislava (online or onsite) is aimed at data analysts who wish to learn techniques for preparing data in Excel, then visualizing it in Power BI.

By the end of this training, participants will be able to:

• Understand the principles of data analysis, objectives of data analysis, and approaches for data analysis.
• Use DAX formulas in Power BI for complex calculations.
• Create and use visualizations and charts for particular analysis cases.
• Import with Power View to move from Excel based Power BI to independent Power BI.

This course aims to equip participants with comprehensive mastery of the core principles and practical applications of VBA within Access and Excel.

Microsoft Excel is a robust spreadsheet tool designed for organizing, analyzing, and visualizing data.

This instructor-led, live training (available online or onsite) is tailored for beginner-level data analysts looking to leverage Excel for data analysis and reporting.

Upon completion of this training, participants will be able to:

• Create and manage spreadsheets in Excel.
• Format and organize data for clarity and efficiency.
• Use formulas and functions to automate calculations.
• Visualize data using charts, tables, and conditional formatting.
• Collaborate and share workbooks securely in Microsoft 365.

Course Format

• Interactive lecture and discussion.
• Ample exercises and practice.
• Hands-on implementation in a live-lab environment.

Course Customization Options

• To request a customized training for this course, please contact us to arrange.

Throughout the training, we will cover the key aspects of financial analysis leveraging Excel's advanced capabilities.

This course is designed for financial analysts, accountants, and professionals looking to enhance their spreadsheet skills specifically in the area of financial analysis.

This live, instructor-led training, available either onsite or remotely, will take you through the essential tools of MS Excel. By combining thoroughly prepared training materials with the instructor's expertise, this course demonstrates the extensive capabilities of Excel spreadsheets.
Compared to standard Excel courses, this training reveals unique functionalities designed to accelerate and improve your workflow.

Target Audience

Financial or market analysts, managers, accountants

Course Objectives

Streamline and automate a wide range of financial analysis tasks using Microsoft Excel

This instructor-led, live training in Bratislava (online or onsite) is aimed at data analysts who wish to program in R for Excel.

By the end of this training, participants will be able to:

• Toggle and move data between Excel and R.
• Use R Tidyverse and R features for data analytic solutions in Excel.
• Extend their data analytical skills by learning R.

This instructor-led training session, available either on-site or remotely, will walk you through the essential components of Excel VBA. By combining thoroughly prepared course materials with the instructor's expertise, the course will demonstrate how to harness the power of task automation through VBA.

Course Format

• Interactive lectures and discussions.
• Practical application in a live laboratory environment.

Customization Options

• To request a customized training program, please get in touch with us.

This course expands on the fundamentals covered in Microsoft® Office Excel® 2019: Part 1, guiding you toward creating advanced workbooks and worksheets that enhance your grasp of organizational intelligence. The capability to analyze vast datasets, extract actionable insights, and present this information effectively to decision-makers is essential for any organization aiming to compete at a high level.

Learning Objectives

Upon successfully completing this course, you will be equipped to harness the power of data analysis and presentation to support informed, intelligent organizational decisions.

You will learn to:

• Utilize functions.
• Manage lists.
• Analyze data effectively.
• Visualize data using charts.
• Employ PivotTables and PivotCharts.

Participants in this course will learn how to create aesthetically pleasing and professional-looking documents using Microsoft Word. They will acquire the ability to perform calculations efficiently and transparently to organize and present their results, as well as utilize various tools to streamline and accelerate the creation of spreadsheets in Excel.

Upon completing this course, you will be equipped to create and develop Excel worksheets and workbooks, enabling you to begin analyzing essential business data.
This course empowers you to:

• Execute a variety of fundamental Excel commands
• Carry out worksheet calculations
• Construct custom formulas
• Modify elements within a worksheet
• Apply formatting changes to cells
• Manage workbook properties

This course is designed to establish a solid foundation in Excel knowledge and skills, enabling you to progressively advance toward expertise in data manipulation. Excel empowers you to organize, calculate, analyze, refine, update, and present your data in ways that guide organizational decision-makers toward optimal outcomes. These tasks become significantly more efficient, requiring far less time than traditional pen-and-paper methods or general-purpose software.

Learning Objectives

Upon successful completion of this course, you will be capable of creating and developing Excel worksheets and workbooks to effectively manage and analyze the data that is vital to your organization's success.

• You will:
• Get started with Microsoft Office Excel 2019.
• Perform calculations.
• Modify a worksheet.
• Format a worksheet.
• Print workbooks.
• Manage workbooks.

In this instructor-led live training at Bratislava (onsite or remote), participants will learn how to combine the capabilities of Python and Excel.

By the end of this training, participants will be able to:

• Install and configure packages for integrating Python and Excel.
• Read, write, and manipulate Excel files using Python.
• Call Python functions from Excel.

This course expands upon the foundational and intermediate concepts introduced in the Microsoft® Office Excel® Basic and Microsoft® Office Excel® Intermediate courses, empowering you to maximize your Excel experience. By mastering collaboration with colleagues, automating complex or repetitive tasks, and leveraging conditional logic to build and apply sophisticated formulas and functions, you will have the full power of Excel at your fingertips. As you learn to delegate the heavy lifting to Excel, you can dedicate more time to extracting the insights you need from the vast volumes of data generated by your organization.

Learning Objectives

Upon successful completion of this course, you will be able to perform advanced data analysis, collaborate on workbooks with other users, and automate workbook functionality.

• You will:
• Work with multiple worksheets and workbooks.
• Share and protect workbooks.
• Automate workbook functionality.
• Use Lookup functions and formula auditing.
• Forecast data.
• Create sparklines and map data.

Upon completion of this course, participants will be able to efficiently carry out a wide range of calculations and present the results clearly. They will learn to utilize various tools to streamline and accelerate spreadsheet creation, as well as protect their data and formulas from unauthorized access.

Participants will learn how to optimize their Excel skills to efficiently create, consolidate, and manage data. By leveraging specialized tools, you can significantly reduce the time spent on routine tasks and design applications capable of performing new, complex functions.

This course is designed for individuals who are already familiar with the fundamentals of VBA and wish to deepen their understanding and expand their use of the language's capabilities.

A training course designed for individuals who work with Microsoft Excel spreadsheets and wish to enhance their productivity and efficiency.

This instructor-led, live training in Bratislava (online or onsite) is aimed at beginner-level analysts who wish to use Excel VBA to automate repetitive work, clean and transform data, and improve reporting processes.

By the end of this training, participants will be able to: record and edit macros, write simple VBA procedures, work with Excel objects for reporting tasks, and debug basic automation solutions.

Reflect on the following questions:

• Is your daily work in Excel an endless cycle of copy-pasting commands?
• Are you wasting time repeating similar operations to prepare data for analysis?
• Do you know all the Excel keyboard shortcuts, yet remain unsatisfied with the results?
• Do you spend more time dealing with data analysis and preparation than with actual insights?
• Do you have to manually verify the accuracy of data obtained from different systems?
• Do you need to stay late at work or take your Excel files home because you couldn't finish during the day?
• Is your job to prepare reports based on large datasets?
• Do you feel that working in Excel feels like taking a long detour to achieve results?

If you answered YES to any of these questions, it's time to end this nightmare. This training is designed for you.

Discover how you can accelerate your daily operations and get the most out of MS Excel.

WARNING

After this training, your life will change dramatically. Activities that used to take all day will be completed in just a few moments. Are you ready for this?

This instructor-led, live training in Bratislava (online or onsite) is designed for beginner to intermediate business analysts and data analysts who wish to utilize Excel for data analysis and reporting in their projects and tasks.

By the end of this training, participants will be able to:

• Utilize Excel formulas and functions to perform calculations and manipulate data effectively.
• Leverage Excel data analysis tools, such as PivotTables, What-If Analysis, and Forecasting, to summarize and visualize data.
• Create and customize data visualizations using Excel charts and graphs.
• Apply Excel data validation and conditional formatting to ensure data quality and highlight key insights.
• Use Excel’s data import and export features to connect with external data sources and share data with others.