Through instructor-led live Microsoft Office training courses, available either online or onsite, participants explore the fundamentals and practical applications of Microsoft Office via interactive discussion and hands-on practice.
Microsoft Office training can be delivered as "online live training" or "onsite live training". Online live training (also known as "remote live training") is conducted via an interactive, remote desktop. Onsite live training can take place locally at customer premises in Prague or at NobleProg corporate training centers in Prague.
From Prague Main Train Station (Praha hlavní nádraží)
Take tram 9 from Hlavní nádraží toward Sídliště Řepy.
Get off at Újezd.
Walk about 10 minutes toward Malostranské náměstí / Prokopská.
Continue along Prokopská to 296/8.
Alternative: Take the metro C from Hlavní nádraží → Muzeum, change to metro A → Malostranská, then walk across Malá Strana. This involves more walking.
From Prague Bus Station — Florenc
Take metro B from Florenc toward Zličín.
Get off at Můstek.
Change to metro A toward Nemocnice Motol.
Get off at Malostranská.
Walk approximately 10–15 minutes to Prokopská 296/8.
This instructor-led, live training (online or onsite) is aimed at beginner to intermediate business professionals, educators, and marketers who want to combine DeepSeek with PowerPoint to automate and optimize their presentations.
By the end of this training, participants will be able to:
Automate the generation of text-based content for PowerPoint slides using DeepSeek.
Create data-driven visuals and infographics powered by DeepSeek models.
Utilize AI to summarize lengthy reports and convert them into presentation-ready slides.
Integrate DeepSeek with PowerPoint for efficient, dynamic presentations.
This guided Excel training in Prague takes users from fundamental data entry to sophisticated automation techniques. Through hands-on exercises, participants will master formulas, PivotTables, and VBA. It is ideal for enhancing professional reporting and analytical capabilities.
This instructor-led, live training in Prague (online or in-person) targets beginner to intermediate-level professionals who wish to master Microsoft Word, Excel, and PowerPoint to enhance document creation, data analysis, and presentations.
By the end of this training, participants will be able to:
Effectively create, format, and manage documents in Microsoft Word.
Utilize Excel for data entry, analysis, and visualization.
Design engaging and professional presentations in PowerPoint.
Leverage collaboration features across Microsoft Office applications.
This live training in Prague is tailored for intermediate Excel users seeking to master inventory control, budgeting, and reporting. Learn to analyze datasets with 5,000+ rows using advanced formulas, pivot tables, and macros. Develop practical skills in a hands-on lab to automate routine tasks.
This instructor-led, live training in Prague (online or onsite) is aimed at beginner-level to advanced-level data analysts who wish to use Excel to perform a variety of tasks such as data entry, formula creation, data analysis, and advanced automation.
By the end of this training, participants will be able to:
Navigate Excel’s interface and perform basic data entry, formatting, and calculations.
Apply advanced formulas, functions, and conditional formatting for data analysis.
Create and manage pivot tables and charts for data visualization.
Use tools like Power Query, Power Pivot, and perform data analysis.
Automate tasks using macros and VBA to streamline workflows.
This instructor-led, live training in Prague (online or onsite) is aimed at beginner-level 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.
Participate in this live Excel modeling training in Prague to develop robust data analysis capabilities. Master structured problem-solving, advanced functions, and core model design principles. Participants will gain practical experience in constructing scalable models for scenario analysis and effective business reporting.
This live, instructor-led training in Prague guides you through mastering Microsoft Word, from foundational basics to advanced automation. You will learn to format documents, manage layouts, and utilize features like mail merge and macros to improve productivity and efficiency.
Excel is a widely used spreadsheet program developed by Microsoft. It is employed for storing, organizing, and analyzing data in tabular form. Below are some key features and functions of Excel:
1. Spreadsheets:
Composed of sheets, where each sheet is a grid of cells arranged in rows and columns.
Allows the creation of multiple sheets within a single file, facilitating the organization of different data sets.
2. Calculations and Formulas:
Enables various mathematical, statistical, and logical calculations using formulas.
Offers a comprehensive 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 fonts, colors, and styles, as well as creating charts, PivotTables, and diagrams.
4. Sorting, Filtering, and Grouping:
Allows sorting data according to specific criteria.
Enables filtering data to display only selected information.
Supports grouping data based on user requirements.
5. Data Analysis:
Provides tools for performing advanced analyses, such as scenario analysis, trend analysis, forecasting, and creating macros.
6. Data Sharing:
Facilitates sharing and real-time collaboration on data, allowing multiple users to work simultaneously on the same data.
7. Task Automation:
Enables the creation of macros and task automation using the VBA (Visual Basic for Applications) programming language.
Excel is extensively used across various fields, from business to science and education. Its versatile features enable data analysis, report creation, budgeting, scheduling, data management, and many other applications.
This instructor-led, live training in Prague (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.
In this hands-on session covering Prague, participants will establish core data analytics competencies using Excel, VBA, and R. The curriculum emphasizes data manipulation, visualization, and machine learning methodologies to enable accurate trend forecasting, process optimization, and the creation of evidence-driven business strategies.
Automate workflows and construct robust desktop applications using VBA in Microsoft Excel and Access. This comprehensive Prague course covers core programming concepts, object-oriented coding, SQL database design, and user interface development through practical exercises focused on data management.
Acquire fundamental Microsoft Excel competencies through this introductory course hosted in Prague. The curriculum addresses data input, styling, formula construction, function application, table management, and visual data representation, thereby establishing a solid groundwork for practical data analysis and reporting scenarios.
Elevate your financial analysis capabilities with this extensive Excel course available in Prague. Gain proficiency in advanced functions, pivot tables, and external data workflows. The course explores real-world applications such as the time value of money, forecasting models, and securities analysis, empowering you to make data-driven decisions.
Gain proficiency in advanced Excel techniques for financial analysis, including INDEX-MATCH, PivotTables, VBA, and Solver, delivered in Prague. Develop skills in using Goal Seek, database queries, and external data integration to streamline workflows, enabling the transformation of raw data into actionable insights and accurate forecasts.
This hands-on Excel course in Prague focuses on fundamental skills including data input, styling, formula creation, function application, and chart generation. Learners will master efficient calculation methods, automate routine spreadsheet tasks, and secure sensitive information against unauthorized modification or accidental edits.
This Excel Advanced with VBA course in Prague focuses on optimizing data management through advanced formulas and VBA automation. It covers building custom functions, designing user forms, and enhancing productivity via macro-based workflows and external data integration.
Discover how to craft clean, professional documents in this MS Word Fundamentals course. Gain mastery over text formatting, styles, and layout tools—such as bullet points, tabs, and tables—to guarantee both clarity and visual consistency. Ideal for beginners looking to build efficient document management skills in Prague.
Instructor-led advanced training in Prague focuses on mastering custom styles, macros, templates, mail merge, and document comparison. Learners acquire practical skills in automated workflows, dynamic tables of contents, and enterprise-grade document control.
This instructor-led training in Prague enables Excel users to progress their VBA capabilities to an intermediate level. Participants will construct custom interfaces, gain proficiency in complex data types, and implement robust error handling and debugging strategies. It is particularly suitable for professionals looking to optimize workflow automation efficiency.
Refine your Excel expertise in this 14-hour session held in Prague. Dive into advanced formula construction, detailed formatting, chart creation, and PivotTable management to significantly boost your productivity. This program is ideal for professionals looking to effectively elevate their data analysis and reporting capabilities from an intermediate to an expert level.
This instructor-led, live training in Prague (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.
Develop advanced PowerPoint capabilities in Prague to craft polished, scalable presentations. Explore slide master customization, apply SmartArt for visual mapping, and utilize deep Excel integration for live data dashboards. Leverage add-in workflows to enhance the efficiency of producing complex presentations.
This course in Prague covers advanced PowerPoint slide design, emphasizing visual storytelling, composition, and chart development. It cultivates practical abilities in image editing and effective element placement, equipping professionals to deliver impactful presentations.
Participate in this instructor-led session in Prague to master the art of delivering impactful presentation decks using PowerPoint and contemporary tools. The curriculum covers slide design, data visualization, and speaker techniques, empowering you to build confidence and connect with your audience effectively.
This instructor-led live training, available online or onsite in Prague, is designed for beginner to intermediate-level business analysts and data analysts who aim to leverage Excel for data analysis and reporting in their projects and daily tasks.
Upon completion of this training, participants will be able to:
Utilize Excel formulas and functions to perform calculations and manipulate data.
Employ 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.
Leverage Excel's data import and export capabilities to connect with external data sources and share data effectively.
This one-day Prague training is purpose-built for power users and SharePoint site owners. It addresses configuring site navigation, customizing lists, overseeing content types, and tracking activity reports. This program is ideal for professionals seeking to enhance their advanced SharePoint administration capabilities.
This one-day SharePoint User training in Prague assists site owners and users in mastering advanced capabilities, including team collaboration, document management, and social tools. Participants will learn to manage sites, configure web parts, control user permissions, and customize site settings to enhance overall productivity.
Develop the ability to create persuasive financial slide decks that connect complex data with executive-level insights. Spanning seven hours, this course focuses on design methodologies, data visualization, and Excel integration to elevate your storytelling capabilities. Acquire practical skills for delivering confident presentations in Prague.
Read more...
Last Updated:
Testimonials (11)
Flexibility in the course delivery and the interactive approach. The trainer was open to questions, clarified doubts clearly and also considered participants suggestions during the sessions. The training was well structured and informative.
Soundarya Mohan - Mizuho Bank Europe N.V.
Course - Financial Analysis in Excel
the trainer's patience,
Agata Halubicka - Sad Rejonowy w Krosnie Odrzanskim
Course - Microsoft Office Excel - poziom średnio zaawansowany
peace of mind of the person presenting
Anna Szper - Sad Rejonowy w Krosnie Odrzanskim
Course - MS Word - poziom podstawowy
well-prepared training, interesting topics
Maciek Boiski - Instytut Energetyki - Panstwowy Instytut Badawczy
Course - Microsoft Office Excel - poziom podstawowy
scope of material
Marcin - Instytut Energetyki- Panstwowy Instytut Badawczy
Course - Visual Basic for Applications (VBA) w Excel - wstęp do programowania
Well structured. Good teaching techniques. Course well documented!
Sorin
Course - VBA For Access & Excel
practicality of advice and attempts to solve problems reported by the group in their companies
Kacper - Instytut Energetyki- Panstwowy Instytut Badawczy
Course - Word dla zaawansowanych
very clear, very good explanation, wishing more teachers would train like this
Mihaela - Phillip Morris
Course - Excel Basics
trainer was expalning everything step by step which was very good as it was easy to follow if there was anything unclear trainer helped
Daria - LKQ Polska Sp. z o. o.
Course - Excel Modelling
What I liked most about the training was the trainer’s knowledge of Excel. I appreciated learning useful things like shortcuts and formulas that I can use every day.
Martin
Course - Visual Basic for Applications (VBA) for Analysts
Online MS Office training in Prague, Microsoft Office training courses in Prague, Weekend Microsoft Office courses in Prague, Evening Microsoft Office training in Prague, MS Office instructor-led in Prague, MS Office on-site in Prague, MS Office coaching in Prague, Weekend MS Office training in Prague, MS Office instructor-led in Prague, Microsoft Office one on one training in Prague, MS Office instructor in Prague, MS Office boot camp in Prague, Microsoft Office private courses in Prague, Evening MS Office courses in Prague, Online Microsoft Office training in Prague, MS Office trainer in Prague, MS Office classes in Prague
