In our seminar rooms or comfortably from home!
We support you as a consultant, organizer, and implementation partner for IT-qualifications, IT-projects, and Data Centre training
News: EPI joins the TÜV NORD GROUP
This marks a significant milestone in EPI’s 38-year journey, strengthening its position to serve customers while continuing to operate independently under the EPI brand
Our bestseller workshops
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.



Efficiently analyze, visualize, and evaluate large spreadsheets – practical and time‑saving
This hands-on workshop shows you how to professionally edit, analyze, and visualize large Excel spreadsheets. You will learn how to filter data effectively, create subtotals, use conditional formatting, and work with PivotTables efficiently. This enables you to increase both your accuracy and productivity when working with extensive datasets.
Your Benefits at a Glance
- Quickly structure, filter, and analyze large spreadsheets
- Use conditional formatting for clear and meaningful reports
- Create, customize, and calculate PivotTables
- Participate either on-site or online
Workshop Content
Working with Large Spreadsheets
- Freezing rows or columns
- Fast sorting options
- Clear and efficient data filters
- Subtotals based on specific criteria
Creating and Applying Conditional Formatting
- Traffic lights, data bars, color scales
Functions for Effective Data Analysis
- SUMIFS, COUNTIFS
- MIN, MAX, AVERAGE, COUNT
Data Analysis with PivotTables
- Creating PivotTables
- Adjusting table structure
- Changing the data source
- Formatting and calculating PivotTable data
Prerequisites
Participation in an Excel basics course or equivalent knowledge. Practical experience working with Excel spreadsheets.
Target Audience
Users who want to make their Excel spreadsheets more efficient with advanced calculation and analysis functions. Professionals who analyze and visualize data and want to make informed decisions.
Using Microsoft Teams Efficiently in Everyday Work
In this seminar, participants gain practical knowledge to use Microsoft Teams as a central platform for collaboration, communication, and project work. The course is designed for users who already work with Office 365 and use Teams daily to coordinate meetings, chats, and document collaboration efficiently.
Your Benefits
- Use Microsoft Teams effectively for communication, meetings, and project work
- Learn how to structure channels and chats efficiently
- Increase productivity through integration with Planner, SharePoint, and Office apps
- Get practical tips for organizing files, calendars, and tasks
- Apply user knowledge directly in everyday work
Course Content
Introduction to Microsoft Teams
- Features and use cases of Teams
- Creating, managing, and structuring teams and channels
Communication and Collaboration
- Chats, private chats, mentions, and notifications
- Organizing and conducting online meetings
- Calling via VOIP / Skype for Business
- Integrating emails into Teams
Files and Knowledge Management
- Uploading, sharing, and co‑editing files
- Using and configuring channel tabs
- Working with SharePoint and OneDrive documents within Teams
Planner and Task Management
- Creating and managing team tasks
- Content management: integrating external content (e.g., SharePoint)
Calendar Functions and Organization
- Scheduling appointments and coordinating meetings efficiently
- Integration with Outlook and Planner
Prerequisites
Good knowledge of Microsoft Office. Initial experience with Office 365.
Target Audience
Users who work with Microsoft Teams regularly. Employees who want to optimize online meetings, group chats, and collaborative document editing. Team members who want to use modern tools for effective teamwork.
Applying Project Management Methods and MS Project Effectively
This workshop provides practical knowledge for structured planning, organization, and control of projects in the workplace. You will learn how to clearly distinguish between tasks and projects, plan projects systematically, and use MS Project purposefully for implementation. It is ideal for anyone who wants to learn project management methods and apply them efficiently in their daily work.
Your Benefits
- Plan projects in a structured way and implement them efficiently
- Apply project management methods directly to your daily work
- Manage tasks, resources, and schedules effectively with MS Project
- Hands-on workshop with many practical examples and exercises
- Gain confidence in using MS Project
Workshop Content
Workplace Situation / Project Context
- Distinguishing tasks from projects: day‑to‑day operations vs. project work
- Developing ideas for implementing new tasks (e.g., process changes or sales methods)
Project Management as a Method
- Planning as a thoughtful and structured approach
- Characteristics and definition of projects (project classification)
- Defining project objectives
- Deriving individual activities from project goals
MS Project: Features and Practical Application
- Creating a project and entering project information
- Structuring project tasks and activities
- Defining and managing resources / resource pools
- Working with project plans, deadlines, and milestones
- Using views, tables, and project templates
- Multi‑project techniques and monitoring project progress
Prerequisites
Practical experience with Windows applications.
Target Audience
Project managers, team leaders, and all users who want to learn project management methods and apply them practically in MS Project.
Professional Project Management with MS Project
In this advanced seminar, you will gain comprehensive expert knowledge of Microsoft Project and learn best practices, tips, and tricks for using the software confidently in day‑to‑day project work. You will deepen your skills in project planning, resource management, and cost control, and learn how to monitor and manage projects efficiently.
Your Benefits
- Plan, manage, and monitor projects at a professional level
- Manage resources efficiently and resolve conflicts
- Apply multi‑project management and resource projects effectively
- Extend and monitor cost management
- Exchange data between MS Project and other Office applications
- Use automation to increase efficiency
Seminar Content
Views, Tables, and Filters
- Creating custom views, tables, and filters
- Visualizing project information effectively
Formatting and Scheduling
- Adjusting project schedules and resolving scheduling conflicts
- Setting priorities for tasks and resources
Resource Management
- Building and managing resource hierarchies
- Handling resource conflicts and bottlenecks
Cost Management
- Advanced cost planning and control
- Budget monitoring and project evaluation
Multi‑Project Techniques and Network Integration
- Combining projects and managing them via resource projects
- Integration into networks, intranet, or internet environments
Data Exchange and Automation
- Linking MS Project with Excel, Outlook, and other Office applications
- Implementing automated processes and recurring tasks efficiently
Prerequisites
Good knowledge of MS Project is required. We recommend attending the MS Project Basics seminar beforehand.
Target Audience
Project managers, project team members, and users who want to deepen their Microsoft Project expertise and handle typical challenges in planning, controlling, and resource management with confidence.
Introduction to Professional Project Management
In this introductory course, you will learn how to get started with Microsoft Project in a practical and hands-on way, and how to work efficiently with projects. Using a case study, you will create a complete project plan step by step—from initial planning and resource allocation to evaluation and reporting. You will gain an overview of the key features and learn how to plan, visualize, and monitor projects in a structured manner.
Your Benefits
- Confident introduction to Microsoft Project
- Effective planning, controlling, and monitoring of projects
- Insight into common project management methods
- Efficient use of resources and schedules
- Clear visualization of project progress
- Practice-oriented work with realistic examples
Seminar Content
Introduction and Program Structure
- Interface layout and navigation
- Working with the Project Guide
- Basic settings and options
Planning a Project from the Ground Up
- Creating a project plan with deadlines and milestones
- Task types, dependency types, and task constraints
- Scheduling and timeline control
Resource Management
- Creating and assigning resources
- Automatically resolving conflicts using resource leveling
Views, Tables, and Templates
- Working with different views and tables
- Using project templates for recurring workflows
Multi-Project Management and Resource Pools
- Creating and using a resource pool
- Working with multiple projects simultaneously
Reports and Evaluations
- Printing and designing project plans and reports
- Exporting to other Office applications
- Monitoring project progress with baseline and interim plans
- Documenting and commenting on project status
Prerequisites
Basic knowledge of Windows is required.
Target Audience
Project managers, project team members, and beginners in Microsoft Project who want to plan, control, and monitor projects.
- Introduction to Python and Machine Learning – Fundamentals of Programming, Data Analysis, and AI
- Machine Learning with a Mathematics Intro – Fundamentals, Algorithms, and Data Visualization
- Introduction to Python – Fundamentals of Programming and Data Processing
- Java Programming – Fundamentals, Collections, and Functional Concepts
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.