Excel 2021 - Stufe 2: Aufbauwissen

Professional Knowledge in Practical Use

What-if analyses, pivot tables, macros, and much more.

Selected functions from A for COUNT to Z for RAND

Are you successfully working with Excel? Then you are also familiar with the most important functions. However, Excel offers much more, including many lesser-known useful tools like Power Query or PivotTables!

This book shows you how to make your workflows significantly more efficient. Discover helpful and new functions and apply them for complex calculations. In addition to evaluation, logical, date, text, and lookup functions, you will also explore pivot tables, importing external data, conditional formatting options, data analysis tools (what-if), as well as macros and special chart types. With easy-to-follow instructions, clear images, and many practical examples, this book guides you on your journey to becoming an Excel professional. Look forward to numerous tips from the author and benefit from her extensive experience as an instructor in adult education!

Contents include:

• Entering formulas and functions, including nested ones
• Avoiding input errors through data validation
• Using evaluation and statistical functions
• Implementing lookup and reference functions
• Selected date, logical, and text functions
• Merging data from multiple tables
• What-if analyses
• Retrieving and processing data from external sources (Power Query)
• Evaluating tables with PivotTable and PivotChart
• Special chart types (histogram, waterfall, geodata)
• Using macros and controls.