Excel Formeln und Funktionen für 2021 und 365, 2019, 2016, 2013, 2010 und 2007: - neueste Version.

Excel - Formulas and Functions

This comprehensive manual offers a top-notch collection of over 600 formulas, functions, and tips for dedicated Excel users, suitable for all Excel versions from 2007 to 2021 and Microsoft 365. You will learn how to construct formulas and incorporate functions into them. Whether you are conducting complex what-if analyses, combining multiple chart types, or working with controls and forms: each formula or function is explained clearly and illustrated with easily understandable practical examples. You will utilize the new technology of dynamic arrays for your calculations and implement Power Query queries and DAX measures in Power Pivot. Additionally, the new and modified functions of Excel 2019, 2021, and Microsoft 365 are presented in detail, making it easier for you to transition to the current version.

Excel files for practice are provided for each tip and example. From financial mathematical functions, date and time functions, Power Query, Power Pivot, array functions, matrix functions, to statistical functions, everything is included. A complete reference work on the topic of Excel - a must-have for every Excel user.

Contents include:

• Skillfully applying formulas and functions
• Easily managing errors
• The principle of spreadsheet calculation
• Calculating with functions
• Editing, evaluating, and analyzing data for daily practice
• Professional charts, graphs, and presentations
• Utilizing internal and external interfaces
• Text and database functions
• Array functions: Lookup and reference
• Date and time functions
• Information functions
• Financial mathematical functions
• Logic functions and technical functions
• Microsoft Office Online - Excel in the browser
• Automating routine tasks with macros
• New and modified functions
• Power Query: M functions.