| DataCamp

Actualisé 1 juil. 2025 · 3 min de lecture

=AVERAGE(A1:A10)

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

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

=AVERAGEA(A1:A10)

Conclusion

Acquérir les compétences nécessaires pour optimiser Excel - aucune expérience n'est requise.

Author

Josef Waples

Sujets

Cours

3 h

54.7K

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

Cours

3 h

94.6K

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

Cours

2 h

8.6K

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