Online Microsoft Training in Romania

Microsoft 365 offers a comprehensive suite of cloud-based productivity and collaboration tools, including Teams, OneDrive, Planner, and Copilot, designed to streamline modern workplace workflows.

This instructor-led live training (available online or onsite) is tailored for intermediate-level professionals looking to leverage Microsoft 365 capabilities to boost productivity, governance, and cross-team collaboration.

Upon completing this training, participants will be able to:

• Configure and manage Teams to facilitate effective team collaboration and meeting practices.
• Utilize OneDrive for secure file storage, sharing, and version control.
• Plan and monitor work using Planner and integrate tasks into team workflows.
• Harness Copilot to accelerate document drafting, meeting summaries, and data insights.

Course Format

• Interactive demonstrations combined with guided, hands-on labs.
• Scenario-driven exercises that reflect real organizational workflows.
• Practical sessions covering configuration, governance, and user adoption best practices.

Course Customization Options

• We can tailor examples, governance checklists, and hands-on labs to align with your organization's policies and environment.

Microsoft 365 offers a robust suite of tools for constructing enterprise-grade knowledge management systems, seamlessly integrating SharePoint, Teams, Power Automate, and Power BI to organize, consolidate, and visualize information efficiently. This course examines how to design dynamic intranet dashboards, connect various data sources, and deploy structured workflows to boost collaboration and facilitate knowledge sharing across teams.

This instructor-led, live training (available online or onsite) is designed for advanced professionals aiming to create and manage complex knowledge management frameworks leveraging Microsoft 365 tools.

Upon completion of this training, participants will be capable of:

• Designing sophisticated knowledge management systems utilizing Microsoft 365 tools.
• Constructing interconnected SharePoint sites and Teams channels to facilitate information flow.
• Automating content workflows with Power Automate.
• Developing Power BI dashboards for knowledge visualization and reporting.
• Optimizing governance, access control, and version management across shared repositories.

Course Format

• Interactive lectures and discussions.
• Numerous exercises and practical implementation activities.
• Hands-on configuration within a live Microsoft 365 environment.

Course Customization Options

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

Microsoft Intune is a cloud-based endpoint management solution that empowers organizations to securely oversee users, devices, and applications. It offers robust tools for configuration, compliance, and protection across Windows, macOS, iOS, and Android ecosystems.

This instructor-led, live training (available online or on-site) is designed for IT professionals at intermediate to advanced levels who aim to deploy, configure, and manage enterprise devices using Microsoft Intune alongside related Microsoft 365 technologies.

Upon completing this training, participants will be able to:

• Implement and manage Microsoft Intune for endpoint management.
• Configure device enrollment, compliance, and security policies.
• Deploy and secure enterprise applications using Intune.
• Integrate Intune with Microsoft 365, Entra ID, and Defender for Endpoint to achieve unified management.

Format of the Course

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

Course Customization Options

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

Microsoft 365 is a comprehensive suite of integrated productivity tools that facilitate collaboration, generate data-driven insights, and automate workflows through applications such as Excel, Word, PowerPoint, Outlook, and Copilot.

This instructor-led, live training, available online or onsite, is designed for intermediate-level professionals who want to master Microsoft 365 tools and AI-powered features to enhance decision-making, communication, and organizational efficiency.

Upon completing this training, participants will be able to:

• Apply advanced Excel techniques and automation tools to support business and leadership decisions.
• Create compelling PowerPoint presentations using storytelling and data visualization methods.
• Create, format, and collaborate on professional documents in Word with the assistance of Copilot.
• Boost productivity and time management by leveraging Outlook and AI-driven features across Microsoft 365.

Course Format

• Interactive lectures and discussions.
• Hands-on exercises and scenario-based practice.
• Practical application of Microsoft 365 tools in a live-lab environment.

Customization Options

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

Microsoft To Do is a cloud-based task management application designed to help individuals and teams organize, prioritize, and manage tasks across devices with seamless integration into Microsoft 365.

This instructor-led, live training (available online or onsite) is aimed at beginner to intermediate-level professionals who wish to leverage Microsoft To Do not only for personal productivity but also as a powerful collaborative tool integrated with Microsoft 365 applications.

Learning Objectives

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

• Set up and configure Microsoft To Do across devices and integrate it with Microsoft 365.
• Create, organize, and prioritize tasks and lists for both personal and team use.
• Collaborate effectively by sharing lists, assigning tasks, and monitoring progress.
• Enhance workflows by using Microsoft To Do alongside Outlook, Teams, and Planner.
• Apply productivity best practices and advanced techniques for long-term adoption.

Format of the Course

• Interactive lecture and discussion.
• Hands-on exercises and guided labs.
• Practical team collaboration simulations.

Course Customization Options

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

Microsoft To Do is a cloud-based task management tool designed to help individuals and teams organize, prioritize, and handle tasks across devices with seamless integration into Microsoft 365.

This instructor-led, live training (online or onsite) targets beginner to intermediate-level professionals who want to use Microsoft To Do for effective task management, improved productivity, and better team collaboration.

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

• Set up and configure Microsoft To Do for both personal and team use.
• Create, organize, and prioritize tasks efficiently.
• Integrate To Do with Outlook, Teams, and other Microsoft 365 tools.
• Apply productivity best practices using To Do features.

Format of the Course

• 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.

Microsoft System Center Data Protection Manager (DPM) serves as Microsoft's enterprise-grade backup and recovery solution, designed to safeguard critical workloads including file servers, databases, and virtual machines.

This instructor-led live training, available both online and on-site, targets intermediate-level IT professionals seeking to deploy, configure, and manage DPM to protect data and ensure business continuity.

Upon completing this training, participants will be equipped to:

• Install and configure DPM servers and agents.
• Establish and manage protection groups.
• Execute backup and recovery procedures.
• Integrate DPM with other disaster recovery solutions.

Course Format

• Interactive lectures and discussions.
• Extensive exercises and practical applications.
• Hands-on implementation within a live-lab environment.

Customization Options

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

This instructor-led, live training in Romania (online or onsite) is tailored for beginner to intermediate business users seeking to enhance their productivity and digital collaboration through Microsoft Teams, OneDrive, and Outlook.

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

• Effectively create, manage, and utilize teams and channels in Microsoft Teams.
• Utilize tags, mentions, and app integrations within Teams to streamline communication.
• Store, organize, and securely share files in OneDrive by adhering to best practices.
• Recover documents using version history and collaborate on files in real time.
• Leverage Outlook for advanced email management and shared calendar scheduling.

This instructor-led live training in Romania (online or onsite) targets beginner to intermediate users aiming to enhance team productivity and streamline everyday workflows using Outlook, OneDrive, Teams, Planner, and Forms.

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

• Effectively organize and manage communication using Outlook.
• Store, share, and collaborate on files via OneDrive.
• Conduct meetings, chats, and team collaboration with Microsoft Teams.
• Plan and track tasks efficiently using Microsoft Planner.
• Create and analyze online surveys and quizzes with Microsoft Forms.

Microsoft Exchange Server is a messaging platform that delivers email, calendar, contacts, and task management capabilities.

This instructor-led, live training (available online or on-site) is designed for IT professionals with an intermediate level of expertise who want to install, configure, manage, and troubleshoot Microsoft Exchange Server environments.

Upon completing this training, participants will be able to:

• Install and configure Microsoft Exchange Server.
• Implement disaster recovery and anti-malware solutions.
• Configure message transport and migrate to Exchange Online.
• Troubleshoot issues and ensure server availability.

Course Format

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

Course Customization Options

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

Microsoft OneNote serves as a digital notebook application designed to help users organize, share, and collaborate on information across teams and devices.

This instructor-led live training (available online or onsite) is targeted at professionals with limited or developing experience in OneNote who manage or coordinate digital information and wish to effectively utilize Microsoft OneNote to organize notes, coordinate team knowledge, and enhance collaborative workflows.

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

• Organize personal and team notes using notebooks, sections, and pages.
• Share and collaborate in real-time on OneNote content.
• Embed and link files, emails, and meeting notes into a unified workspace.
• Integrate OneNote with Microsoft 365 apps like Teams, Outlook, and Planner.

Format of the Course

• Interactive lecture and discussion.
• Hands-on use of Microsoft OneNote in sample collaboration scenarios.
• Guided exercises focused on note-taking, content organization, and teamwork.

Course Customization Options

• To request a customized training for this course based on your department's workflows or internal tools, please contact us to arrange.

This instructor-led live training in Romania (online or onsite) targets beginner-level leadership teams eager to master task coordination using Microsoft Planner and its ecosystem, ultimately fostering greater productivity and collaboration throughout the organization.

Upon completing this training, participants will be capable of:

• Creating, managing, and tracking tasks and projects effectively via Microsoft Planner, thereby improving team alignment and project transparency.
• Organizing and prioritizing personal tasks, sharing task lists, and collaborating on assignments using Microsoft To Do.
• Leveraging Microsoft Loop components for real-time collaboration, seamlessly embedding them into projects and meetings, and boosting communication and information exchange among team members.
• Designing and managing custom lists suited to specific project requirements, automating workflows, and integrating Lists with other Microsoft 365 tools for streamlined task tracking.

This instructor-led, live training in Romania (online or onsite) is aimed at beginner-level business professionals who wish to gain the skills necessary to utilize Teams, Word, and Excel effectively in a management context.

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

• Gain a comprehensive understanding of Microsoft 365
• Navigate and utilize Microsoft Teams for communication, collaboration, and project management.
• Develop proficiency in creating, formatting, and managing Word documents.
• Use Excel for data entry, manipulation, and analysis.
• Explore how to integrate Microsoft 365 applications for seamless workflows.

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

This instructor-led, live training (available online or onsite) is designed for users from beginner to advanced levels who wish to build confidence and proficiency across Excel’s essential, intermediate, and advanced capabilities.

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

• Work confidently with spreadsheets, formulas, and formatting.
• Use 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.

Format of the Course

• 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.

Microsoft System Center Operations Manager (SCOM) is a monitoring solution built to guarantee the availability, performance, and reliability of IT services across applications and data centers.

Delivered as an instructor-led live training (available either online or on-site), this program targets intermediate IT professionals looking to deploy, configure, and manage SCOM for enterprise-grade monitoring and alerting.

Upon completion of this training, participants will be capable of:

• Installing and configuring System Center Operations Manager.
• Establishing monitoring rules, alerts, and reports.
• Integrating SCOM with additional System Center components.
• Troubleshooting issues and optimizing performance within monitored environments.

Course Format

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

Customization Options

• To request a tailored training version for this course, please get in touch with us to arrange.

Excel is a widely utilized spreadsheet application designed for organizing, analyzing, and automating data.

This instructor-led, live training—available either online or onsite—is tailored for intermediate Excel users who want to leverage Excel for inventory control, budgeting, reporting, and automation by working with real-world datasets.

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

• Apply formulas such as SUMIF, IF, VLOOKUP, and SUMIFS to manage inventory and purchasing scenarios.
• Efficiently manage and analyze large datasets containing over 5,000 rows.
• Create and interpret pivot tables to track monthly and cumulative data.
• 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 within a live lab environment.

Customization Options

• For requests regarding customized training for this course, please contact us to make arrangements.

This instructor-led live training in Romania (online or onsite) is aimed at intermediate-level IT professionals who wish to manage and secure an organization's IT environment using Microsoft 365.

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

• Deploy and manage Microsoft 365 services such as Intune, MDM, and Autopilot.
• Configure and enforce security policies using Windows Defender and other Microsoft 365 security tools.
• Monitor and troubleshoot devices and applications within a Microsoft 365 environment.
• Understand and implement compliance and data protection measures in Microsoft 365.
• Manage Microsoft 365 security services such as Microsoft Secure Score, Exchange Online Protection, Safe Attachments, and Safe Links.
• Implement compliance solutions using Microsoft Purview, data loss prevention, and sensitivity labels.

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

Upon completion of this training, participants will be capable of:

• Navigating Excel’s interface to execute fundamental data entry, formatting, and calculations.
• Implementing complex formulas, functions, and conditional formatting for in-depth data analysis.
• Designing and managing pivot tables and charts to effectively visualize data.
• Leveraging tools such as Power Query and Power Pivot for comprehensive data analysis.
• Automating processes via macros and VBA to streamline operational workflows.

This instructor-led live training in Romania (online or onsite) is tailored 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 Romania (online or onsite) is aimed at intermediate-level IT professionals who wish to manage and secure an organization's IT environment using Microsoft 365.

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

• Deploy and manage Microsoft 365 services such as Intune, MDM, and Autopilot.
• Configure and enforce security policies using Windows Defender and other Microsoft 365 security tools.
• Monitor and troubleshoot devices and applications within a Microsoft 365 environment.
• Understand and implement compliance and data protection measures in Microsoft 365.
• Apply best practices for Microsoft 365 administration and security.

This instructor-led, live training in Romania (online or onsite) is designed for data analysts or anyone seeking to master Excel for creating data models tailored to data analysis.

Upon completing this training, participants will be able to:

• Analyze and resolve business challenges using structured problem-solving techniques.
• Navigate Excel tools with confidence and efficiency.
• Organize, format, and present data effectively.
• Grasp the logical architecture of models and apply appropriate Excel functions.

This instructor-led, live training in Romania (online or onsite) is aimed at intermediate-level system administrators who wish to effectively deploy, manage, and troubleshoot Hyper-V environments.

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

• Understand virtualization concepts and configure Hyper-V.
• Create and manage virtual machines, VM storage, and networking.
• Utilize advanced Hyper-V features and secure Hyper-V environments.
• Monitor and optimize Hyper-V performance.

This instructor-led, live training in Romania (online or onsite) targets individuals who wish to learn how to use Microsoft OneNote for effective note management and productivity improvement.

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

• Understand the basics and features of OneNote.
• Create, organize, and edit notes using OneNote.
• Integrate notes with other applications.

Participants will learn to efficiently utilize core data analysis tools, including scenarios and pivot tables. The course covers performing calculations on dates, leveraging text-processing functions, and creating or adapting macros to automate spreadsheet tasks tailored to specific requirements.

Excel is a popular spreadsheet program created 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: Consists of worksheets, where each worksheet is an array of cells arranged in rows and columns. Allows creating multiple worksheets within a single file, enabling the organization of different data sets. 2. Calculations and Formulas: Enables performing various mathematical, statistical, and logical calculations using formulas. Has a wide set of built-in functions, such as SUM, AVERAGE, MAX, MIN, IF, VLOOKUP, etc. 3. Data Formatting and Appearance: Provides tools for formatting data, including changing font, color, style, as well as creating charts, pivot tables, and diagrams. 4. Sorting, Filtering, and Grouping: Allows sorting data according to specific criteria. Enables filtering data to display only selected information. Allows grouping data based on needs. 5. Data Analysis: Tools for performing advanced analyses, such as scenario analysis, trend analysis, forecasting, and creating macros. 6. Sharing Data: Allows sharing and collaborating on data in real-time, enabling multiple users to work simultaneously on the same data. 7. Task Automation: Allows creating macros and automating 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 enable data analysis, report generation, budgeting, scheduling, data management, and many other applications.

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

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

• Develop advanced object-oriented applications
• Convert text files
• Utilize external data sources
• Incorporate external libraries

This instructor-led live training in Romania (online or onsite) is designed for data analysts who wish to use VBA in Excel for task automation.

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

• Record and edit macros as needed.
• Write procedures using data from worksheets.
• Create custom functions.
• Handle events (such as opening a worksheet or updating a cell) via handlers.
• Create user forms.

This instructor-led live training in Romania (online or onsite) is designed for data analysts who wish to use VBA in Excel for automating tasks.

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

• Record and edit macros as needed.
• 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

This course is designed for analysts, researchers, scientists, graduates, students, and anyone eager to learn how to streamline statistical analysis using Microsoft Excel.

Course Objectives

By completing this course, participants will deepen their understanding of Excel and statistical concepts, thereby enhancing the efficiency and effectiveness of their professional work or research.

The curriculum covers the utilization of Excel’s Analysis ToolPak, the application of statistical functions, and the execution of fundamental statistical procedures. Additionally, it addresses common limitations within Excel and provides strategies to circumvent them.

This instructor-led live training in Romania (available online or onsite) is tailored for data analysts who wish to acquire techniques for preparing data in Excel and then visualizing it in Power BI.

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

• Understand the core principles, objectives, and approaches of data analysis.
• Apply DAX formulas in Power BI for complex calculations.
• Create and utilize visualizations and charts for specific analytical cases.
• Import data with Power View to transition from Excel-based Power BI to an independent Power BI setup.

Data analytics is a crucial tool in business today. We will focus throughout on developing skills for practical hands on data analysis. The aim is to help delegates to give evidence-based answers to questions: 

What has happened?

• processing and analyzing data
• producing informative data visualizations

What will happen?

• forecasting future performance
• evaluating forecasts

What should happen?

• turning data into evidence-based business decisions
• optimizing processes

The course aims to equip participants with a thorough understanding of the core concepts and practical applications of VBA in Access and Excel.

Microsoft Excel is a robust spreadsheet application 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 completing this training, participants will be capable of:

• Creating and managing spreadsheets within Excel.
• Formatting and structuring data to enhance clarity and efficiency.
• Utilizing formulas and functions to automate calculations.
• Visualizing data through charts, tables, and conditional formatting.
• Collaborating and securely sharing workbooks via Microsoft 365.

Course Format

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

Customization Options

• To request a customized version of this course, please contact us to arrange.

This training session covers the key aspects of financial analysis, leveraging the advanced features of Excel.

The course is designed for financial analysts, accountants, and any professionals seeking to enhance their spreadsheet skills in the context of financial analysis.

Target Audience

Financial and market analysts, managers, and accountants

Course Objectives

Enable learners to facilitate and automate various types of financial analysis using Microsoft Excel

This instructor-led, live training in Romania (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.

In this instructor-led, live training in Romania (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.

Participants in this course will learn how to efficiently carry out a wide range of calculations in a clear and transparent manner to organize and present their results. They will also master various techniques to streamline and accelerate spreadsheet creation, as well as safeguard their calculations and outcomes against unauthorized access.

Participants will enhance their capabilities to optimally create, consolidate, and manage data. Utilizing specialized tools can significantly streamline workflows, reduce the time spent on existing tasks, and enable the design of applications capable of performing new functions.

This course is designed for individuals who are already familiar with VBA basics and wish to expand their knowledge and make greater use of the language's capabilities.

A training program designed for professionals using Microsoft Excel who wish to enhance their efficiency and proficiency.

This instructor-led, live training in Romania (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.

Please consider the following questions:

• Is your daily work in Excel a never-ending cycle of copy-paste commands?
• Are you wasting time repeating similar operations to prepare data for analysis?
• Do you know all the Excel keyboard shortcuts but remain unsatisfied with the results?
• Would you rather focus on data analysis and preparation without the wasted time?
• Do you manually verify the accuracy of data obtained from various systems?
• Do you have to stay late at work or take 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 leads you through an unnecessarily roundabout path to your results?

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

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

WARNING

After this training, your life will change dramatically. Tasks that currently consume your entire day will take only moments. Are you ready for this transformation?

This course is designed to enhance participants' PowerPoint capabilities through a blend of practical exercises and supporting theoretical knowledge. It is suitable for all levels, with a particular focus on professional presentation designers, conference speakers, and individuals responsible for leading team meetings.

“Advanced Excel & AI for Manufacturing” is an instructor-led, live training (online or on-site) designed for intermediate to advanced participants who wish to leverage Excel and AI for production data analysis, KPI reporting, and industrial process optimization.

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

• Install and configure the necessary tools for data analysis and AI in manufacturing.
• Create and manage integrated Excel + AI dashboards for KPIs and production reporting.
• Apply AI models for demand forecasting, predictive maintenance, and process optimization.
• Interpret analysis results and make data-driven decisions within production operations.

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

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

• Apply Excel formulas and functions to perform calculations and manipulate data.
• Utilize Excel data analysis tools, including PivotTables, What-If Analysis, and Forecasting, to summarize and visualize data.
• Employ Excel charts and graphs to design and customize data visualizations.
• Implement data validation and conditional formatting to ensure data integrity and highlight key insights.
• Use Excel's data import and export capabilities to connect with external data sources and share information effectively.

Power Query for Data Automation in Manufacturing is an instructor-led, live (online or onsite) training designed for intermediate to advanced participants who want to use Power Query to automate the collection and processing of production data and the reporting of KPIs.

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

• Install and configure Power Query in Excel to connect to multiple data sources
• Transform, clean, and structure production data for analysis and reporting
• Create automated data flows to generate KPI reports and dashboards
• Apply best practices for data quality control and support data-driven decision-making

This course is designed for Excel users who wish to advance to professional-level data analysis using modern tools such as Power Query and Power Pivot. The programme focuses on transforming Excel from a simple table-handling tool into a powerful data analysis and modelling instrument.

This course is designed for beginner or basic-level users who wish to consolidate their Excel skills and take their first steps in using Artificial Intelligence in their daily activities. The program combines essential Excel concepts with practical exercises and gradually introduces the use of AI (Copilot) for task automation, formula generation, and data analysis

This course is an advanced Excel program designed for participants who already work regularly with data and reports and wish to increase their productivity and the quality of their analysis by leveraging modern functions in Excel 365 and AI (Copilot). The course consolidates advanced data handling skills, introduces modern concepts such as FILTER, LET, and provides an introduction to LAMBDA, demonstrating how these capabilities can be used to build clearer, more robust, and easier-to-maintain files.