PDF
Increase efficiency in Excel 365 with classic and dynamic array formulas
In this workshop, participants learn how to use Excel formulas and functions professionally. In addition to classic functions such as IF(), VLOOKUP(), or SUMIF(), the focus is on the dynamic array functions available in Excel 365.
Participants discover how to make complex data analyses simpler, faster, and more efficient, how to combine, filter, and evaluate data, and how to apply formulas effectively in PivotTables, charts, or large datasets. Practical exercises provide tips, tricks, and best practices for using formulas in a targeted and professional way.
Ideal for anyone who wants to elevate their Excel skills to a professional level and use formulas effectively for analysis and automation.
Your Benefits at a Glance
- Confident use of classic Excel functions
- Practical application of dynamic array functions
- Efficient data analysis and evaluation of large datasets
- Tips for conditional formatting and professional formula creation
- Participation possible on-site or online
Workshop Content
Fundamental Techniques for Effective Work in Excel
- Dynamic tables and structured references
- Creating and using named ranges (fixed and dynamic)
Conditional Calculations
- IF(), AND(), OR(), IFS()
- SUMIFS(), INDIRECT()
- Using traditional functions as dynamic array formulas
Combining, Linking, and Filtering Data
- VLOOKUP(), XLOOKUP(), FILTER(), MATCH()
- VSTACK(), HSTACK()
- Nesting dynamic array formulas
- GROUPBY(), PIVOTBY()
- Referencing dynamic arrays in PivotTables or charts
- Speeding up analysis and lookup operations in large datasets
Working with Date and Time Values
- Calculating date differences with DATEDIF()
- Calculating, summing, and converting time values into decimals
Conditional Formatting with Formulas and Functions
- Automatically highlighting threshold and peak values
- Automatically marking date and time values
Prerequisites
Basic knowledge of Excel is helpful. No prior experience with dynamic array functions is required.
Target Audience
Users who want to apply classic Excel functions effectively. Participants who want to use dynamic array formulas efficiently. Anyone who analyzes, filters, and visualizes large datasets.
