NobleProg Transylvania provides the most up-to-date Certification Paths for Microsoft 365, Dynamics 365, Azure, and the Microsoft Power Platform.
Benefit from training delivered by Microsoft-certified trainers and an official Microsoft learning partner in Transylvania.
Additionally, we offer training courses on Exchange, SharePoint, SQL Server, Windows, and more.
NobleProg - Your Local Training Provider
Brasov, Calea Bucuresti Street
NobleProg Brasov, 13 Calea Bucuresti Street Sacele, Brasov, romania, 505600
The hotel is situated at the city entrance, being the best conference and training location in Brasov. Three conference rooms can accommodate up to 170 guests and can be modified for the company needs. These training rooms are equipped with the all necessities of a good conference or training.
Salile de training sunt situate central în Sibiu, pe principalul bulevard. Clădirea hotelului care le gazduieste este de factură clasicistă si reprezinta un punct de referinta arhitecturala a orasului.
Turnul Sfatului, Galeria de Arta Contemporana, sau parcurile Corneliu Coposu si Astra se află în imediata apropiere.
Pentru a ajunge aici de la gara, puteti merge pe jos 20min sau cu autobuzul 5 circa 10min
Locuri de parcare găsiți în parcarea supravegheata, sau pe străzile alăturate.
Cluj-Napoca, Pitești Street
NobleProg Cluj-Napoca, Strada Pitești 19, Cluj-Napoca, romania, 400124
ClujHUB has more rooms for events and training sessions, which can host from 4 to 80 people. These areas can be setup up to fit the companies need. The location is great, 10 minutes walk from the historical city center.
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.
This instructor-led, live training in Transylvania (online or onsite) is aimed at beginner to intermediate-level business professionals, educators, and marketers who wish to integrate DeepSeek with PowerPoint to automate and optimize their presentations.
By the end of this training, participants will be able to:
Automate the creation of text-based content in PowerPoint slides using DeepSeek.
Generate data-driven visuals and infographics powered by DeepSeek models.
Use AI to summarize long reports and turn them into presentation-ready slides.
Integrate DeepSeek with PowerPoint for streamlined, dynamic presentations.
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 Transylvania (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 Transylvania (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 Transylvania (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 Transylvania (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 Transylvania (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 Transylvania (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 Transylvania (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 Transylvania (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 Transylvania (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.
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 Transylvania (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:
This instructor-led live training in Transylvania (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
Streamline workflows and develop powerful desktop applications using VBA across Microsoft Excel and Access. This thorough VBA training program explores programming fundamentals, object-oriented coding, SQL database design, user interface creation, debugging strategies, error handling, and advanced Excel analysis techniques through hands-on exercises. It equips analysts, financial experts, and developers to automate manual processes and leverage sophisticated data management and reporting functionalities.
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 Excel training for financial analysis delves into the advanced spreadsheet techniques essential for finance professionals. The curriculum covers lookup functions, search formulas, and Pivot Charts, as well as conditional formatting, external data workflows, and securities analysis. Participants will explore practical methods for evaluating time value of money concepts, identifying market trends, building financial forecasting models, and leveraging Excel's comprehensive analytical toolkit for complex financial computations and reporting.
This course empowers financial analysts and accountants with advanced Excel techniques for automating intricate calculations and reports. It covers fundamental principles of financial functions, INDEX-MATCH lookups, database queries, PivotTables, PivotCharts, and external data integration. Participants will explore Goal Seek, Solver, Analysis ToolPak, and VBA macros to streamline recurring workflows. The training enables professionals to convert raw data into actionable financial insights and precise forecasts for strategic planning.
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.
Participants will learn to create clean, professional documents (including various forms of official correspondence) and fully utilize basic features to ensure clear information flow in both short and long texts.
Master advanced document workflows with Microsoft Word's full feature set. Customize styles, perform mail merges from external databases, record macros, and create templates. Participants gain expertise in section-level layout control, dynamic tables of contents, indexes, hyperlinks, content controls, document comparison, and version tracking. This course equips professionals to build automated reporting systems, standardized enterprise templates, cross-referenced documents, and SharePoint-integrated workflows.
Enhance your VBA expertise to the intermediate level by exploring custom interfaces, complex data structures, conditional logic, loop constructs, and professional debugging strategies. This practical Excel VBA course provides training in robust error handling, performance tuning, VBA UserForms, and workflow automation via real-world exercises, bridging the gap between basic macros and advanced automation solutions for data analysts, reporting specialists, and business users aiming for enterprise-grade spreadsheet functionality.
Master Microsoft Excel with this professional training course, designed to enhance your spreadsheet efficiency and productivity. Learn essential skills including editing worksheets, managing workbooks, building complex formulas with powerful functions, formatting cells, creating professional charts and graphs, working with PivotTables and data lists, and handling graphic objects. Ideal for business analysts, accountants, data handlers, and office professionals seeking to advance their Excel proficiency from intermediate to expert level. Boost your data analysis capabilities, streamline reporting workflows, and unlock the full power of Microsoft Excel for better decision-making and workplace productivity.
This instructor-led, live training in Transylvania (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.
Going beyond the basics of PowerPoint enables you to create refined, scalable presentations that truly captivate your audience. This course explores advanced slide and handout master customization, template development, the use of SmartArt for visual process mapping, and deep integration with Excel for live-linked data dashboards and charts. Professionals will learn power-user workflows utilizing add-ins such as Office Timeline and Poll Everywhere to speed up complex deck creation, streamline review processes, and deliver impactful business presentations.
Professionals aiming to create polished presentations can significantly benefit from advanced slide design techniques that transform standard content into compelling visual narratives. This course explores the fundamental principles of slide composition, chart and infographic development, and image editing. Participants will build practical skills in strategically positioning elements, highlighting key information, and customizing their workspace. Upon completion, professionals will possess actionable strategies for designing clean, impactful slides and delivering confident presentations using structured public speaking methods.
Enhancing the ability to craft engaging presentations using PowerPoint and other available tools.
Target Audience:
Sales representatives, consultants, academic and research staff, managers, educators, corporate employees, SMEs, and public institution staff who need to present confidently in front of groups and capture their interest.
"Advanced Excel & AI for Manufacturing" is an instructor-led, live (online or on-site) training designed for intermediate/advanced participants who want to use Excel and AI for production data analysis, KPI reporting, and optimization of industrial processes.
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 Transylvania (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.
Designing impactful financial presentations bridges the gap between complex data and executive communication via PowerPoint. This course explores design strategies including slide structuring, treemap and sunburst visualizations, budget chart layouts, and simplified reporting tables that highlight key financial metrics. Participants will learn to master Excel integration for dynamic data, emphasize critical figures, and deliver confident financial storytelling that secures stakeholder buy-in.
Power Query for Data Automation in Manufacturing is an instructor-led, live (online or on-site) training program designed for intermediate to advanced participants who want to leverage Power Query to automate the collection and processing of production data and KPI reporting.
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 workflows 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 designed for Excel users who wish to consolidate and extend their knowledge to an intermediate-advanced level, with a strong focus on efficient data handling, formula usage, and creating relevant visual analyses.
This course is an advanced Excel program designed for participants who already work consistently with data and reports and wish to increase their productivity and analysis quality by using modern functions in Excel 365 and AI (Copilot). The course reinforces advanced skills in working with data, introduces modern concepts such as FILTER, LET, and an introduction to LAMBDA, and shows how these capabilities can be used to build clearer, more robust, and easier-to-maintain files.
Read more...
Last Updated:
Testimonials (4)
Easy to follow instructions and trainer was very helpfully when I had issues
Richard Kim - Royal Canadian Mounted Police
Course - Microsoft Intune: Modern Endpoint Management and Security
Microsoft email and planner
Shirley - Abhe & Svoboda Inc
Course - Microsoft 365 Productivity Tools: Outlook, OneDrive, Teams, Planner, and Forms
Online Microsoft training in Transylvania, Microsoft training courses in Transylvania, Weekend Microsoft courses in Transylvania, Evening Microsoft training in Transylvania, Microsoft instructor-led in Transylvania, Evening Microsoft courses in Transylvania, Microsoft one on one training in Transylvania, Microsoft instructor-led in Transylvania, Microsoft classes in Transylvania, Weekend Microsoft training in Transylvania, Microsoft trainer in Transylvania, Microsoft coaching in Transylvania, Microsoft on-site in Transylvania, Microsoft private courses in Transylvania, Microsoft boot camp in Transylvania, Microsoft instructor in Transylvania, Online Microsoft training in Transylvania
