| DataCamp

Aktualisierte 1. Juli 2025 · 3 Min. Lesezeit

=AVERAGE(A1:A10)

=AVERAGEIF(B1:B10, ">50")

=AVERAGEIFS(B1:B10, B1:B10, ">50", A1:A10, "Ford")

=AVERAGEA(A1:A10)

Bringe deine Karriere mit Excel voran

Erwerbe die Fähigkeiten, um Excel optimal zu nutzen - keine Erfahrung erforderlich.

Author

Josef Waples

Themen

Kurs

3 Std.

55.3K

Understand how to prepare Excel data through logical functions, nested formulas, lookup functions, and PivotTables.

Kurs

3 Std.

95.6K

Learn how to analyze data with PivotTables and intermediate logical functions before moving on to tools such as what-if analysis and forecasting.

Kurs

2 Std.

8.8K

Boost your Excel skills with advanced referencing, lookup, and database functions using practical exercises.