Microsoft Excel: Refresher for advanced users
Get back into Excel quickly and efficiently!
.svg)
Machine Learning Engineer
Refresh of basic Excel skills (table logic, references, structured references)
Formulas & functions for everyday work (e.g., IF logic, XLOOKUP or modern lookup approaches, SUMIFS/COUNTIFS, text/date functions)
Data verification, cleansing, and preparation for analysis (duplicates, validation, typical format pitfalls)
Pivot Table Basics: Structure, Fields, Filters, Groupings, Display, Best Practice
Solutions for typical challenges encountered in everyday work
- The most important shortcuts / key combinations
- Working with Smart Tables / Table Objects
- Quick wins for everyday Excel use
- Tips and tricks from the expert
In your online learning environment, you will find useful information, downloads and extra services for this training course once you have registered.
experts, practical tasks, and exercises.
Please use a laptop/PC with Microsoft Office (version 2016/2019/2021/2024/O365 or newer) for Windows installed.
We recommend working with two screens so that you can participate in the training in the best possible way.
Anyone who works with Microsoft Excel 2016/2019/2021/2024/O365 or the corresponding Microsoft Office versions for Windows, already has basic knowledge of Microsoft Office Excel, and now wants to refresh their knowledge in a compact and efficient way—while also wanting to be able to confidently use the newer Excel developments (e.g., XLOOKUP instead of VLOOKUP).
.svg)