Data Analysis in Excel
Learn how to analyze data with PivotTables and intermediate logical functions before moving on to tools such as what-if analysis and forecasting.
Comience El Curso Gratis3 Horas9 Videos29 Ejercicios
Crea Tu Cuenta Gratuita
o
Al continuar, acepta nuestros Términos de uso, nuestra Política de privacidad y que sus datos se almacenan en los EE. UU.¿Entrenar a 2 o más personas?Pruebe DataCamp para empresas
Preferido por estudiantes en miles de empresas
Descripción del curso
Exploring PivotTables
You will learn how to extract valuable insights and uncover secrets hidden within your data using the power of PivotTables. Additionally, you’ll learn how to use keyboard shortcuts to speed up your workflow.Intermediate Logical Functions
You’ll identify your ideal customer profile using logical functions and create targeted marketing strategies. You’ll explore the concept of customer segmentation and gain the skills to maximize customer success, increase revenue and boost business growth.What-if Analysis
You’ll master the art of scenario analysis using Excel’s built-in What-If Analysis tool. You’ll understand how different variables can impact your sales, perform sensitivity analysis and use it to make informed predictions to stay ahead in dynamic business environments.Forecasting
You will unlock the power of forecasting to anticipate future trends and visualize this data for your stakeholders. You’ll leverage moving averages and trendlines to communicate your findings.Empresas
¿Entrenar a 2 o más personas?
Obtenga acceso de su equipo a la biblioteca completa de DataCamp, con informes centralizados, tareas, proyectos y másEn las siguientes pistas
Fundamentos de Excel
Ir a la pista- 1
Exploring data with PivotTables
GratuitoYou will learn how to extract valuable insights and uncover secrets hidden within your data using the power of PivotTables. Additionally, you’ll learn how to use keyboard shortcuts to speed up your workflow.
- 2
Intermediate Logical Functions
You’ll identify your ideal customer profile using logical functions and create targeted marketing strategies. You’ll explore the concept of customer segmentation and gain the skills to maximize customer success, increase revenue and boost business growth. You’ll utilize functions such as Nested IFs, SWITCH, and COUNTIFS.
- 3
What-if analysis
You’ll master the art of scenario analysis using Excel’s built-in What-If Analysis tool. You’ll understand how different variables can impact your sales, perform sensitivity analysis and use it to make informed predictions to stay ahead in dynamic business environments.
- 4
Forecasting
You will unlock the power of forecasting to anticipate future trends and visualize this data for your stakeholders. You’ll leverage moving averages and trendlines to communicate your findings.
Empresas
¿Entrenar a 2 o más personas?
Obtenga acceso de su equipo a la biblioteca completa de DataCamp, con informes centralizados, tareas, proyectos y másEn las siguientes pistas
Fundamentos de Excel
Ir a la pistaSets De Datos
Exercises and DatasetsColaboradores
Requisitos Previos
Introduction to ExcelNick Edwards
Ver Mas
Analyst for Mynd
¿Qué tienen que decir otros alumnos?
Únete a 13 millones de estudiantes y empeza Data Analysis in Excel hoy!
Crea Tu Cuenta Gratuita
o
Al continuar, acepta nuestros Términos de uso, nuestra Política de privacidad y que sus datos se almacenan en los EE. UU.