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.
From Macro Recording to Custom VBA Procedures
Make your daily work easier with Macros and VBA in Excel 365!
In this intensive 2-day workshop, you will learn how to automate routine tasks, develop your own functions and procedures, and significantly extend Excel’s capabilities.
You will discover how to work effectively with simple programming rules, properties, methods, and events, structure macros professionally, and create user-friendly solutions for your everyday work.
Whether it’s data processing, formatting, or automated reports – your own macros and VBA scripts will save you a lot of work in the future.
Your Benefits at a Glance
• Efficient introduction to macro and VBA programming
• Step-by-step explanations of macros, procedures, and functions
• Best practices for formatting, data preparation, and user interfaces
• Numerous macro solutions for immediate practical use
• Hybrid seminar: participation possible in person or live online
Seminar Content
Know-how on Macros and VBA
• Accelerate your VBA learning curve with clear basic rules
• The essentials of macro programming: properties, methods, and events
• What to record – and which commands you need to know
• Program with clear structure: clean VBA code structure
• Overview of the Excel object model
• Create custom tabs and menu extensions
Extend Excel’s Command Range
• Macros for formatting, sorting, and filtering large data sets
• Develop custom functions and procedures for business applications
• Automate recurring tasks
Routine Tasks for Lists and Tables
• Optimize data preparation of large data sets with macros
• Control processing with parameters
• Integrate file and folder selection dialogs
• Use automation to prevent errors
• Automatically delete empty rows and specific rows
• Distribute rows across multiple sheets
• Merge data ranges from different files
• Advanced filtering with VBA
• Set up automatic data import
User-Friendly Interface
• Best practices for usability in Excel
• Design and implement user-friendly UserForms
Target Audience
• Users who want to deepen and expand their macro knowledge
• Advanced Excel users who want to implement typical solutions with VBA
• Professionals who want to automate data processes and make Excel more efficient
Prerequisites
• Knowledge of macro recording and working with the VBA editor is desirable
Get Better at Your Job with Excel
2-Day Workshop
Based on a participant list, an automatic seating plan consisting of form elements will be created.
Numbering is often used in Excel, and these automatic numberings work even when rows are deleted.
A waffle chart can be used to present a value convincingly, whether it is a whole number or a percentage.
Workshop Content
Efficient Work with Excel:
- Personalize the interface
- Use cell names for faster function creation
- Expert tips for using the Name Manager
- Create dynamic range names
Pro Tips for All Areas:
- Optimize number display
- Navigate complex workbooks with hyperlinks
- Automatic and sequential numbering
- Use watermarks as copyright notice
Excel Highlights:
- Conditional formatting adds color
- Complex filtering with wildcards
- Automatically display filter results on other sheets
- Mirror two tables
- Create a dynamic seating plan
- Create waffle charts to present a value
Analysis with Pivot Tables:
- Define data for analysis
- Create pivot tables and adjust layouts
- Calculate percentages without writing a formula
- Create calculations in pivot tables
Optimizing Workflows with Macros:
- Step-by-step guide to your first macro
- Create macros for formatting
- Methods to start a macro
Who Should Attend This Workshop?
This workshop is aimed at data scientists, business analysts, and anyone who works with large datasets, processes them efficiently and in a structured manner, and wants to improve their work with Excel.
Excel & PowerPoint – Perfectly Present Excel Data in PowerPoint
1-Day Workshop
A perfect combination: Transfer your Excel tables and charts directly into PowerPoint and create clear and compelling PowerPoint presentations from your Excel data. Learn how to animate these tables and charts to convey your messages even more effectively.
Make your charts eye-catching with just a few tweaks by discovering creative ideas for presenting charts. Our seminar will show you how to design visually appealing presentations that will impress your audience and present your data in an outstanding way.
Workshop Content
Transferring Data from Excel:
- Insert Excel tables as images into PowerPoint
- Edit inserted Excel tables in PowerPoint
- Embed Excel tables
- Create links to Excel tables
- Edit links in PowerPoint
- Insert charts into PowerPoint
- Choose the chart format when inserting
- Best practices for transferring tables & charts
Editing and Designing Tables:
- Creative ideas for your tables
- Use custom border formats
- Create decision tables with symbols
- Highlight table elements with animations
Modifying and Formatting Charts:
- Overview of different chart types
- Clever tips for presenting charts
- Format charts expressively
- Permanently save your own chart templates
- Highlight the informational value of charts with animation
During the Presentation:
- Start Excel during the presentation and directly display the desired worksheet
In Excel:
- Start a presentation within Excel
Who Should Attend This Workshop?
This workshop is ideal for anyone who wants to seamlessly transfer data from Excel into PowerPoint and present numerical data clearly, convincingly, and professionally.
Excel Pivot and PowerPivot
1-Day Workshop
Learn how to create a task list with multiple people in a single cell and convert it into a list of people with tasks — all without programming! Discover how to implement automatic project planning with a Gantt chart. Simply input the start date and the number of days, and let Excel do the rest. The current date will automatically be highlighted. This seminar provides practical insights into how you can use these functions to work more efficiently and plan complex projects in an organized manner.
Workshop Content
Introduction to Pivot Tables:
- Preparing and organizing data
- Working with dynamic formatted tables from Excel 2010 onward
- Understanding the differences between lists and formatted tables
- Basic techniques for using pivot tables (building, structuring, and displaying results)
- Expanding pivot tables with calculated fields, filters/slicers, and grouping
- Analyzing pivot data as charts or passing results within Excel
- Understanding the limitations of pivot tables
Introduction to PowerPivot:
- Installing PowerPivot
- The structure and interface of PowerPivot
- Using PowerPivot as a replacement for VLOOKUP, linking worksheets
- Merging data from different sources (Excel tables, text files, databases) within PowerPivot
- Linking data from various sources through relationships
- Accessing databases using PowerPivot
- Adding additional data sources to existing PowerPivots
- Selecting and filtering data for analysis in PowerPivot; hiding irrelevant data and information
- Creating multidimensional PowerPivot reports and charts
Learning Basic Calculation and Analysis Functions:
- Creating links, analyses, and calculations
- A look at some of the 133 additional DAX functions such as CALCULATE, SUM, IF, AND/OR, DATE, ALL, RELATED, ...
- Visualizing results
- Creating dynamic and versatile charts
- Visualizing multiple charts in one analysis
- Visualizing key figures with KPIs (Key Performance Indicators)
- Creating dashboards for graphical data analysis
Who Should Attend This Workshop?
This workshop is aimed at employees in the commercial sector, management, and controlling, as well as users in administrative departments, staff functions, trainers, freelancers, and small business owners. In short, anyone looking to deepen and perfect their MS Excel skills.
Excel Charts Best Practice
1-Day Workshop
In our seminar, you'll learn how to effectively use Tornado charts to visually compare data series. You'll also discover how Competitive charts can be used to graphically represent your company's position. Furthermore, we will show you how to present widely varying numerical values using line and bar charts with two axes. This enables a clear presentation of different data and trends for your management. With this knowledge, you will be able to create meaningful reports and present complex data in a simple and understandable way. Our hands-on tips and practical examples will help you unleash the full potential of your data visualization.
Workshop Content
Basics of Working with Charts:
- Overview of different chart types
- Creating and editing charts
- Getting to know the elements of a chart
- Saving charts as templates
Column and Bar Charts:
- Column chart with an image in the background
- Columns with differently colored negative values
- Waterfall chart for cost control
- Gantt chart for project monitoring
- Bar chart with images in the bars
- Tornado chart for comparing data
- Line / bar chart with two axes to compare different numerical values
Line and Area Charts:
- Line chart with AutoShapes
- Competitive comparison with a line chart
- Line and area chart with arrows
Bubble Charts:
- Creating traffic lights from a bubble chart
Preparing Data for Charts:
- Filtering data based on specific criteria
- Further processing filtered data
- Creating, copying, and processing partial results
Who Should Attend This Workshop?
This workshop is ideal for users who want to professionally analyze data in Excel and present numerical data in an appealing and convincing way.
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.
