| DataCamp

Actualizado 1 jul 2025 · 3 min de lectura

=AVERAGE(A1:A10)

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

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

=AVERAGEA(A1:A10)

Conclusión

Adquiere los conocimientos necesarios para sacar el máximo partido a Excel, sin necesidad de experiencia.

Author

Josef Waples

Temas

Curso

3 h

55.3K

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

Curso

3 h

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.

Curso

2 h

8.8K

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