Excel Formeln und Funktionen: Profiwissen im praktischen Einsatz

Discover and master the many practical Excel tools!

For Microsoft 365 and Office 2019 + 2016 versions

With downloadable sample files

The functions SUM and AVERAGE are likely familiar to all Excel users. In addition, the program provides an extensive catalog of functions that is continuously expanded with new versions, catering to (almost) every application.

This manual imparts a wealth of professional knowledge in Excel through numerous illustrations. Learn to understand and master data and text functions, logical, lookup, reference, and evaluation functions, as well as selected functions from the fields of statistics, financial mathematics, and mathematics, along with their applications. Additionally, the author addresses topics such as conditional formatting, visualization with charts, error handling in formulas, and the often-overlooked Solver. With its practical examples, the book serves not only as a reference work but also provides tips on how to find the right function.

Content includes:

• Fundamental techniques related to formulas and functions
• Useful tools, such as controls and conditional formatting
• Data, time, and text functions
• Logical functions and their use (IF, IFS, AND, OR, etc.)
• VLOOKUP & Co., the lookup and reference functions
• Calculating sums, averages, and rankings
• Statistical measures and analyses (distributions, forecasts, and correlations)
• Representing values in charts
• Rounding numbers and applying important mathematical functions
• Calculating interest and depreciation
• Optimizing solutions with the Solver.