In our seminar rooms or comfortably from home!
Our bestseller workshops
PDF
Seminartermine nach Kategorien
You can rent our seminar rooms!
Your booking with us is transparent and flexible, without hidden costs. Our seminar rooms in Cologne not only offer pleasant air conditioning, but are also equipped with high-quality technology such as PCs, flat screens and projectors.
Excel: Power BI Desktop
2-Day Workshop
In this expert seminar, you will get to know Power BI Desktop. You will learn how to load data from a variety of sources and combine them in your data model. With a wide range of visualization options, you will be able to present your results in a report and gain entirely new insights into your data.
Additionally, we will show you how to publish your reports via Microsoft Cloud and present them in PowerPoint.
This seminar provides you with the essential know-how to use Power BI Desktop effectively and present your data in an engaging and meaningful way.
Workshop Content
An Overview of Power BI Desktop
- Settings & options in Power BI
Creating the Data Model
- Importing and editing data from different sources
- Setting relationships between tables
- Creating additional columns
- Creating a date table and using time intelligence functions
- Using DAX functions
Creating Reports
- Introduction to various visuals
- Selection pane & bookmarks
- Formats & templates
- Filtering with slicers
- Applying drillthroughs
Publishing Reports
- Uploading and publishing reports to the cloud
- Embedding reports into PowerPoint presentations
- Viewing dashboards on mobile devices
Who Should Attend This Workshop?
- Individuals from finance, management, and controlling
- Data scientists & business analysts
- Anyone looking to expand their knowledge of business intelligence
Power Apps
1-Day Workshop
Design custom applications for your business processes with Power Apps—no programming knowledge required. These applications can be executed on mobile phones, browsers, Microsoft Teams, or SharePoint. You can quickly and easily make them available to other users in your organization, automating your daily workflows.
Workshop Content
Introduction to Power Apps
- What is Power Apps?
- What can Power Apps do?
- Overview of the user interface
Power Apps Environment
- Getting started with Power Apps
Components of Power Apps
- Quick overview of app creation
Creating Your First App
- Building apps
- Generating an app
- App formulas
- Layouts for mobile and tablet apps
- Creating apps for SharePoint
Data Connections
- Excel, SharePoint, Common Data Service, Collections
Managing Apps
- Sharing apps
- Version control of apps
Who Should Attend This Workshop?
Participants who want to improve their daily work routine and automate recurring tasks and processes, all without technical or programming experience.
Microsoft 365: Time & Task Management with Outlook, To Do, Loop & Planner
1-Day Workshop
Outlook has always been a tool for effective time and task management, and Microsoft 365 continues this focus on scheduling, coordination, and visualization of appointments and tasks. For this purpose, Outlook 365 has been expanded with several apps: To Do is fully integrated into Outlook and handles individual task management, Loop is also part of Outlook and enables real-time communication via chat or email. Assigned tasks in Planner are synchronized with To Do and can be accessed in Outlook. This seminar covers both these apps individually and how they work together.
Workshop Content
M365 Groups
- What are M365 Groups & what role do they play?
- How do the apps work together?
Outlook
- Organizing emails
- Using templates & quick parts
- Creating surveys
- Creating & analyzing scheduling surveys
Loop Components in Outlook 365
- Inserting Loop components
- Co-editing Loops
- Starting & organizing Loops in M365
To Do in Outlook 365
- Displaying To Do in Outlook 365
- Creating tasks
- Organizing tasks with smart lists
- Starting To Do in M365
Tasks from Planner & To Do
- Usage
- Creating a Planner plan in Teams
- Displaying Planner & To Do in Teams
- Starting & editing Planner in M365
Who Should Attend This Workshop?
Project managers, team owners, and users who want to structure and optimize team collaboration and their own workflows.
Microsoft 365: Organizing Files with Teams, SharePoint & OneDrive
1-Day Workshop
In this course, you will learn how Teams, SharePoint, and OneDrive are interconnected, how to collaborate on file editing with others, and the benefits of organizing files using Microsoft 365.
Workshop Content
Creating Files in Teams
- Create or upload new files
- Collaboratively edit files in real-time
- Edit files in Teams, browser, or desktop app
- Copying/moving files
- File workspace in the navigation bar
Cloud Storage
- What is SharePoint?
- What is OneDrive?
- Structure of a team site
File Management in SharePoint
- Using version history
- Setting up notifications
- Creating a file directory with Excel
- Sharing files and managing access
Document Management with SharePoint Online
- Setting up a document library
- Adding and organizing metadata
- Using conditional formatting
- Creating views
Using OneDrive
- Opening OneDrive
- Structure of OneDrive
- Sharing files/folders
- Synchronizing data
- Sync settings in Windows Explorer
Who Should Attend This Workshop?
Project managers, team owners, and users who want to store and organize their files in Teams, SharePoint, and OneDrive.
Microsoft 365: Teams & Channels – Collaboration in Teams
1-Day Workshop
In just a few years, Microsoft Teams has become an indispensable part of daily office and project work. While most users are familiar with holding meetings and making calls in Teams, this course introduces you to the many additional possibilities Teams offers for effective collaboration.
Workshop Content
Interface & Navigation
- Elements of the navigation bar
- Your profile/account
- Settings
Communication Options in Teams
- Meetings
- Chat
- Teams
Creating & Structuring a Team
- Team structure & roles within a team
- Creating a team & adding members
- Adding standard & private channels
- Using shared channels
Posts & Conversations
- Basic posts (text, emojis, stickers)
- Creating tasks from posts
- Sending emails to a channel
Managing Teams
- Settings for team owners
- Channel moderation
- Creating and managing tags
Notes Tab
- Getting started with OneNote Online
- OneNote in the desktop app
- Collaborative work in OneNote
Files Tab
- Creating & uploading files in Teams
- Collaboratively editing files within the team
- Basics of working with files in the cloud
Who Should Attend This Workshop?
Project managers, team owners, and users who want to structure and optimize both team collaboration and their own workflows.
Data Centre training for many companies:
These customers already trust us
Maximize the security and efficiency of your data center with our certified Data Centre Training. Our practical training courses provide essential know-how on the design, operation and compliance of data centers. Through continuous training, you reduce downtime, minimize sources of error and meet international standards. Benefit from recognised certifications with the globally accredited training courses from PROKODA GmbH & EPI.
