PDF
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
