Work More Efficiently with Word in Business

In this workshop, you will learn how to use Word effectively for everyday professional tasks. You will discover how to automate recurring processes, design professional business reports, and make optimal use of Word’s built‑in features. Hands‑on exercises demonstrate how to use text blocks, styles, and tables efficiently to save time and create consistent documents.

Your Benefits

• Automate business letters and standard documents using AutoText and Quick Parts
• Create professional reports, tables, and references
• Practical tips and tricks for fast, structured work
• Optimized workflows for recurring Word tasks

Course Content

Word Know‑how and Tips & Tricks

• Work quickly and efficiently in Word
• Customize the interface with your own tabs
• Use field functions effectively

Text Blocks and Document Templates

• Differences between AutoText and Quick Parts
• Use your own documents as building blocks
• Insert building blocks automatically into texts
• Use document and style templates optimally

Sections, Tables, and Form Fields

• Prepare sections to structure business reports
• Insert and format tables from Excel and PowerPoint
• Use form fields for accurate data entry

Directories and References

• Create tables of contents with and without styles
• Use integrated cross‑reference functions

Practical Tools and Tricks

• Insert text into margin columns
• Design headers and footers centrally
• Use Word functions to create Outlook signatures

Requirements

Solid basic knowledge of Word is required to actively participate in the workshop.

Target Audience

• Users who want to deepen their Word skills in a business environment
• People who work professionally with Word templates, business reports, and mail merges

Efficient Data Analysis and Dynamic Reports Without Programming

In this two‑day workshop, participants learn how to efficiently analyze large datasets in Excel — without any programming. Using Power Query, multiple files from folders, tables from workbooks, or CSV files are automatically combined, cleaned, and prepared for PivotTables or dynamic evaluations.

Participants will learn hands‑on how to avoid using VLOOKUP, create data relationships between tables, and design meaningful reports. The seminar provides tips, tricks, and best practices for analyzing Excel data quickly, clearly, and dynamically.

Ideal for anyone who wants to efficiently manage large datasets, create automated analyses, and build professional reporting solutions.

Your Benefits at a Glance

• Automatically combine multiple files or tables
• Create dynamic PivotTables from CSV or Excel data
• Transform, analyze, and visualize data efficiently
• Tips and tricks for professional reporting
• Attend in person or online

Seminar Contents

Power Query Fundamentals

• Efficient introduction to Power Query
• Creating queries for imports
• Working with and managing queries

Importing Data

• Correctly formatting text files during import
• Importing multiple tables from one Excel workbook in a single step
• Importing data from the web
• Automatically importing multiple files from a folder

Editing Imported Data

• Applying data types correctly
• Editing and transforming rows and columns
• Pivoting and unpivoting columns

Analyzing and Visualizing Data

• Creating dynamic PivotTables and presenting data
• Highlighting top values using conditional formatting
• Creating subtotals and copying results
• Analyzing large datasets with PivotTables
• Using Power Pivot to create analyses across multiple tables
• Visualizing complex data with dynamic charts

Prerequisites

• Solid basic knowledge of Excel, regardless of the version

Target Audience

• Anyone who wants to efficiently handle large datasets
• Users who do not program but want to automate data analysis
• Anyone looking to create professional and dynamic Excel reports

Use Excel smartly – from task lists to Gantt charts

In this hands‑on Excel workshop, you will learn how to optimize your work processes, manage task lists efficiently, and automate project planning — all without programming.

Discover how to manage multiple people and tasks in a single cell, create Gantt charts, automatically calculate start dates and durations, and highlight the current date.

You will receive practical tips on how to structure, calculate, and visualize large datasets clearly — from Treemap charts to presenting your Excel data in PowerPoint. You will also get an introduction to Power BI, enabling you to extend your analyses within Microsoft’s Business Intelligence platform.

Your Benefits at a Glance

• Efficient project planning with Gantt charts and task lists
• Optimization of workflows and data preparation
• Tips & tricks for calculations, logic functions, and data refinement
• Visualization of key figures with Treemap and other chart types
• Introduction to Power BI fundamentals & data mining with Power Query
• Hybrid workshop: attend on‑site or live online

Seminar Contents

Optimize Work Processes in Excel

• Personalize Excel for more efficient work
• Perfect data entry
• Combine cell contents without formulas
• Unpivot tables and swap rows/columns

Solution‑Focused Use of Essential Excel Functions

• Calculations for numeric and text values
• Sum only visible columns
• Model values with logic functions
• Refine data with special functions
• Determine and visualize the current status

Excel Case Studies

• Auto‑numbering entries within a column
• Automatic seating plan
• Calculate quarters
• Compare two tables
• Project planning with a Gantt chart
• Combine multiple tables into one list
• Convert task lists into people‑based lists
• Visualize proportions with Treemap charts
• Present Excel data in PowerPoint

Business Intelligence with Power BI

• Data mining with Power Query
• Automate recurring analyses
• Create PivotTables across multiple tables
• Introduction to Microsoft’s Power BI strategy

Target Audience

• Business analysts and data scientists
• Anyone who wants to handle large datasets easily and efficiently
• Anyone who works with Excel regularly and wants to deepen their skills and use Excel more effectively in their day‑to‑day work

Prerequisites

• Solid basic knowledge of Microsoft Excel (any version)
• Familiarity with standard functions is helpful for getting started

Learn how to efficiently prepare your Excel data with Power Query – no macros or programming required

Discover how to revolutionize your data preparation workflows in Microsoft Excel (Microsoft 365) with Power Query – completely without macros or programming.

In this 1‑day special seminar, you will learn how to efficiently import, consolidate, and clean external data sources. With just a few clicks, you can merge multiple files from different sources, automate recurring tasks, and save valuable time in your daily work.

Learn how to prepare complex datasets for analysis, avoid sources of error, and create transparency in your Excel processes. Power Query is fully integrated into Microsoft Excel 365 and offers a powerful yet easy-to-use environment for data preparation, transformation, and automation.

Through practical, hands-on exercises, you will learn step by step how to combine data from text files, Excel sheets, databases, and web sources and how to calculate, filter, and transform data without any programming. This allows you to maintain full control of your data at all times—fast, clean, and efficient.

Your Benefits at a Glance

• Efficient data preparation without macros or VBA
• Automated processes for recurring data imports and cleaning
• Practical exercises with examples from Controlling & Reporting
• Time savings through optimized data flows in Microsoft 365
• Direct applicability thanks to experienced IT trainers
• Hybrid workshop: attend on-site or live online

Seminar Contents

Introduction & Fundamentals

• Overview of Power Query in Microsoft 365
• Understanding the “power” behind Power Query
• Getting to know the interface and navigation

Data Import & Preparation

• Importing data from text files, Excel, or databases
• Reviewing and adjusting import steps
• Removing unnecessary columns, assigning correct data types
• Reducing and optimizing data volume before import

Data Consolidation & Queries

• Automatically combining multiple files from a folder
• Merging data from different Excel worksheets
• Accessing database systems and public web data
• Merging, duplicating, and modifying multiple queries

Data Transformation & Calculation

• Creating calculated columns and custom formulas
• Linking data without VLOOKUP
• Changing data structures (pivoting / unpivoting)
• Understanding the M formula language in the advanced editor
• Creating custom functions and parameters in M

Prerequisites

Solid knowledge of Microsoft Excel (Microsoft 365) is recommended.
Participants should be familiar with standard functions, formulas, and data handling in Excel. No programming skills are required.

Target Audience

This seminar is designed for professionals who regularly work with large data volumes in Excel and want to prepare them more efficiently—especially:

• Employees in Controlling, Finance, Management, and commercial departments
• Data analysts, reporting specialists, and BI users
• Users who want to automate extensive Excel data processing and speed up recurring tasks