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.
Word Best Practice
1-Day Workshop
Automate your entire correspondence using text blocks. Learn the difference between AutoText and Quick Parts, and discover how to use them effectively.
Explore best practices for using structured lists and learn how to tailor the pre-installed lists to your individual needs.
Our seminar offers you valuable tips and tricks that will save you time and effort. Learn optimized procedures for central business topics in Word to improve your workflow and work more efficiently.
Workshop Content
Word Know-how
- Tips & tricks for working quickly in Word documents
- Personalizing the interface with custom tabs
- Valuable field functions for practical use
Blocks for Creating Business Reports and Documents Efficiently
- AutoText vs. Quick Parts
- Using your own documents for text blocks
- Automatically inserting blocks into texts
- How Word handles document and style templates
- Prepare different document sections in business reports using sections
- Best practices for inserting and formatting tables from Excel and PowerPoint
- Using form fields for correct data entry
Optimizing the Creation of Indexes and References
- Creating table of contents with style templates
- Creating table of contents without style templates
- Using built-in referencing functions
Practical Tips and Tools
- How to easily write text into a margin column
- Central building blocks for headers and footers
- Setting up your signature for Outlook with Word
Who Should Attend This Workshop?
- Employees in marketing, PR, sales, HR, quality management
- Staff in administrative roles and assistants
- Trainers, freelancers, and small business owners
- Anyone looking to perfect their PowerPoint knowledge
Who Should Attend This Workshop?
This workshop is for anyone who wants to perfect their Word knowledge and for users who want to deepen their skills with Word templates specifically.
Excel: Macros for Everyone – Automating Daily Tasks with Macros
1-Day Workshop
Do you want to complete recurring tasks in Excel faster and more efficiently – without any programming knowledge? Then this seminar is perfect for you!
Learn how to automate repetitive tasks in Excel using the macro recorder, and execute them with a single click. Don’t worry – Excel will handle the programming for you!
Workshop Content
Basics of Macros
- What can macros do for you?
- Preparing Excel for working with macros
- Using the macro recorder
- Understanding the difference between relative and absolute references
- Adding macros to the ribbon as buttons
Nice to Know About Macros
- Starting macros via buttons
- The advantage of the Personal Macro Workbook
- Configuring security settings
- Protecting macros from unauthorized access
- Sharing macros with colleagues
- Dealing with error messages
- A peek into the VBA editor
Let Macros Work for You
- Design and modify tables with the click of a button
- Assign custom number formats more quickly using macros
- Customize and optimize the Excel interface with macros
- Filter data conveniently with macros
- Calculate subtotals using macros
- Assign conditional formatting faster with macros
- Create, format, and edit pivot tables even faster using macros
Who Should Attend This Workshop?
This workshop is designed for anyone who wants to automate tedious routine tasks and finally understand what Excel macros are all about – all without any programming knowledge.
Visualize PowerPoint ideas
1-day workshop
Content
- Time-saving techniques for drawing
- Create your own form elements
- Systematic creation of your own diagrams
- Set up default settings for form elements
- Make your own design color palette with more than 6 accent colours
- Professional image processing
- Insert the pictures using the right method
- Bring pictures with colors to the point
- To use the command Set up properly to create dynamics in the images
- The use of the golden ratio
- Eyecatcher
- Great agenda slides with multiple points
- Bringing progress beams to all slides
- Generate voltage with a countdown
- Awakening curiosity using animation
- Dynamic and exciting present with the new functions
- During the performance
- Use Hidden PowerPoint commands
- Distributing the handout
- Dealing with questions from viewers
- Tips for online presentation
Look forward to...
- an interesting & varied seminar
- many valuable tips & tricks when using Excel
- a Qualified Lecturer
For whom is the workshop suitable?
- Employees from marketing, PR, Sales/sales, Human Resources, QM
- Users from staff sites and assistants
- Trainers, self-employed and small business owner
- All who want to perfect their PowerPoint knowledge
Power Query Data Preparation Without Macros
1-Day Workshop
Save valuable time and utilize the Power Query add-in for importing external data. Learn how to pull together information from multiple files and clean data without writing a single line of code.
Let Power Query work for you and automate repetitive steps in importing and consolidating data from various sources. Our seminar will provide you with practical methods to optimize your workflows and save time by using Power Query effectively.
Workshop Content
Overview of Power Query
- The power of Power Query
- Installing and activating Power Query
- Power Query interface
Importing and Preparing Data
- Importing data from text files for analysis
- Viewing each import step
- Removing unnecessary columns
- Minimizing the amount of data before importing
- Assigning correct data types and formatting
Consolidating Data and Optimizing Queries
- Importing and processing files from a folder with a single query
- Merging data from multiple Excel worksheets
- Retrieving information from database systems
- Using public data from web-based sources
- Merging multiple Power Query queries
- Duplicating and customizing queries for specific audiences
Transforming Data
- Defining calculated columns
- Linking data without using VLOOKUP
- Unpivoting data (instead of pivoting)
Understanding the Core of Power Query
- The M formula language in the advanced editor
- Creating custom functions in M
- Using program parameters from Excel
Who Should Attend This Workshop?
This workshop is ideal for professionals in finance, management, and controlling, as well as data analysts and staff members in supporting functions, especially those who want to efficiently import, process, and analyze large datasets in Excel.
Professional Reporting with Excel & Power Query
2-Day Workshop
Learn how to combine multiple files in a folder without programming and then analyze the data further in Excel.
Discover how to create a Pivot Table from a CSV file, where the analysis remains dynamic. With just a few clicks, changes and additions to the source file are automatically incorporated.
Learn how to avoid using VLOOKUP() by importing multiple Excel sheets from a workbook and linking them together.
Our seminar offers you practical tips and techniques to make your data analysis more efficient and create meaningful reports.
WorkshopContent
Basics of Power Query
- Efficient introduction to Power Query
- Creating queries to import data
- Working with queries
Importing Data
- Correcting text files during import
- Importing multiple tables from a single Excel workbook in one step
- Importing data from the web
- Importing multiple files from a folder in one step
Editing Imported Data
- Applying data types
- Editing cells and columns
- Transforming data
- Unpivoting columns
- Pivoting columns
Data Analysis
- Creating dynamic tables and presenting data
- Highlighting top values with conditional formatting
- Creating intermediate results and copying results
- Analyzing large datasets with Pivot Tables
- Performing analyses across multiple tables with Power Pivot
- Visualizing complex data with dynamic charts
Who Should Attend This Workshop?
This workshop is ideal for anyone who wants to easily handle large datasets without needing to program in Excel and wishes to make their work in Excel more efficient overall.
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.
