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.

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.

Streamline workflows and develop robust desktop applications with VBA across Microsoft Excel and Access. This comprehensive VBA training covers programming fundamentals, object-oriented coding, SQL database design, user interface development, debugging techniques, error handling, and advanced Excel analysis routines through practical exercises — empowering analysts, financial professionals, and developers to eliminate manual tasks and unlock advanced data management and reporting capabilities.

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.

This course on Analyzing Financial Data in Excel empowers financial analysts and accountants with advanced techniques for automating complex calculations and reports. It covers the core principles of financial functions, INDEX-MATCH lookups, database queries, PivotTables, PivotCharts, and external data integration. The curriculum explores Goal Seek, Solver, Analysis ToolPak, and VBA macros for automating recurring workflows, enabling professionals to transform raw figures into actionable financial insights and accurate forecasts for strategic planning.

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.

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.

Elevate your VBA proficiency to the intermediate tier by mastering custom interfaces, complex data types, conditional logic, looping structures, and professional debugging methods. This practical Excel VBA training covers robust error handling, performance optimization, VBA UserForms, and workflow automation via real-world exercises—bridging the gap from basic macros to advanced automation solutions for data analysts, reporting professionals, and business users aiming to leverage enterprise spreadsheet capabilities.

Take your Microsoft Excel skills to the next level with this professional training course, designed to significantly enhance your spreadsheet efficiency and productivity. You will master essential techniques such as editing worksheets, managing workbooks, constructing complex formulas using powerful functions, applying cell formatting, creating professional charts and graphs, working with PivotTables and data lists, and handling graphic objects. This course is ideal for business analysts, accountants, data handlers, and office professionals who wish to advance their Excel proficiency from an intermediate to an expert level. Boost your data analysis capabilities, streamline reporting workflows, and unlock the full potential of Microsoft Excel to drive better decision-making and improve workplace productivity.

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.

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.