Microsoft Training in Prague

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 instructor-led training in Prague empowers advanced professionals to construct enterprise-level knowledge management systems using Microsoft 365. Participants will learn to design SharePoint repositories, automate business workflows with Power Automate, and visualize critical data through Power BI dashboards to drive better collaboration.

This instructor-led session in Prague focuses on the deployment and security of enterprise endpoints via Microsoft Intune. Participants will learn to configure enrollment, compliance, and application management across Windows, macOS, iOS, and Android. It is ideally suited for IT professionals aiming to enhance unified security and acquire hands-on proficiency.

This instructor-led, live training in Prague (online or onsite) targets beginner to intermediate business users who wish to improve their productivity and digital collaboration using Microsoft Teams, OneDrive, and Outlook.

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

• Create, manage, and utilize teams and channels in Microsoft Teams effectively.
• Streamline communication by leveraging tags, mentions, and app integrations in Teams.
• Store, organize, and securely share files in OneDrive following best practices.
• Recover documents via version history and collaborate on files in real time.
• Manage advanced email tasks and shared calendar scheduling using Outlook.

This instructor-led, live training in Prague (online or onsite) is aimed at beginner-level to intermediate-level users who wish to improve team productivity and streamline everyday workflows using Outlook, OneDrive, Teams, Planner, and Forms.

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

• Organize and manage communication effectively with Outlook.
• Store, share, and collaborate on files using 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.

This instructor-led, live training in Prague (online or onsite) targets beginner-level leadership teams eager to effectively manage and coordinate tasks using Microsoft Planner and its associated tools, ultimately boosting productivity and collaboration throughout the organization.

Upon completing this training, participants will be able to:

• Efficiently create, manage, and track tasks and projects using Microsoft Planner, improving team coordination and project visibility.
• Organize and prioritize individual tasks, share task lists, and collaborate on tasks using Microsoft To Do.
• Leverage Microsoft Loop components for real-time collaboration, integrating them smoothly into projects and meetings to enhance communication and information sharing among team members.
• Design and manage custom lists tailored to specific project needs, automate workflows, and integrate Lists with other Microsoft 365 tools for more efficient task tracking.

This live, instructor-led training in Prague (online or onsite) is designed for beginner-level business professionals seeking to master Teams, Word, and Excel for effective management.

Upon completion, participants will be able to:

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

This instructor-led, live training in Prague (online or onsite) targets intermediate IT professionals aiming to manage and secure their organization's IT environment through Microsoft 365.

Upon completion, participants will be equipped to:

• Deploy and administer Microsoft 365 services, including Intune, MDM, and Autopilot.
• Establish and enforce security protocols using Windows Defender and additional Microsoft 365 security utilities.
• Monitor and resolve issues related to devices and applications within a Microsoft 365 setup.
• Comprehend and apply compliance frameworks and data protection strategies in Microsoft 365.
• Oversee Microsoft 365 security services such as Microsoft Secure Score, Exchange Online Protection, Safe Attachments, and Safe Links.
• Deploy compliance solutions utilizing Microsoft Purview, data loss prevention, and sensitivity labels.

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.

This instructor-led, live training in Prague (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 Prague (online or on-site) targets mid-level supervisors and technical officers eager to broaden their knowledge in SharePoint administration and the strategic use of Microsoft 365 Copilot.

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

• Comprehend the fundamentals of SharePoint architecture and administration.
• Configure and manage SharePoint sites and user permissions.
• Implement security and compliance measures within SharePoint.
• Integrate and manage Microsoft 365 Copilot features to enhance organizational productivity.
• Apply best practices for data governance and content management.

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) targets data analysts who want to utilize advanced VBA in Excel for task automation.

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

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

This instructor-led live training in Prague (online or onsite) is aimed at 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 required.
• Write procedures using data from the sheet.
• Create your own functions.
• Handle an event (opening worksheet cell update etc.) by means of the handler.
• Create a form.

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

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.

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.

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 advanced-level training is tailored for IT specialists and SharePoint administrators tasked with overseeing, configuring, and safeguarding SharePoint Online environments within Microsoft 365. Attendees will explore the architecture of SharePoint Online in depth, covering modern site provisioning, permissions governance, content lifecycle management, and integration with Microsoft 365 applications such as Teams, Power Automate, and Viva. The curriculum blends strategic frameworks with practical configuration exercises using the Microsoft 365 admin center, SharePoint Admin Center, and PowerShell. Emphasis is placed on real-world administrative scenarios, automation, compliance, and driving user adoption while adhering to governance standards.

This practical, hands-on course offers a comprehensive introduction to Microsoft SharePoint Online, emphasizing how contemporary organizations can utilize it for collaboration, document management, process automation, and seamless integration within the Microsoft 365 ecosystem. Participants will delve into SharePoint’s core functionalities—including document libraries, lists, permissions, and site architectures—while also acquiring foundational experience with automation tools such as Power Automate and Power Apps.