Saltar al contenido principal
InicioExcelData Analysis in Excel

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 Gratis
3 Horas9 Videos29 Ejercicios
28.854 AprendicesTrophyDeclaración de cumplimiento

Crea Tu Cuenta Gratuita

GoogleLinkedInFacebook

o

Al continuar, acepta nuestros Términos de uso, nuestra Política de privacidad y que sus datos se almacenan en los EE. UU.
Group¿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

Group¿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ás
Pruebe DataCamp Para EmpresasPara obtener una solución a medida, solicite una demonstración.
  1. 1

    Exploring data with PivotTables

    Gratuito

    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.

    Reproducir Capítulo Ahora
    Introduction to data analysis
    50 xp
    Which steps should I take?
    100 xp
    Exploratory data analysis in PivotTables
    50 xp
    Navigating with keyboard shortcuts
    100 xp
    Getting started with PivotTables
    100 xp
    Calculated fields in PivotTables
    100 xp
    Custom grouping in PivotTables
    100 xp
    Slicing data in PivotTables
    100 xp
  2. 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.

    Reproducir Capítulo Ahora
  3. 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.

    Reproducir Capítulo Ahora
  4. 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.

    Reproducir Capítulo Ahora

En las siguientes pistas

Fundamentos de Excel

Colaboradores

Collaborator's avatar
Maarten Van den Broeck
Collaborator's avatar
Jess Ahmet

Requisitos Previos

Introduction to Excel
Nick Edwards HeadshotNick Edwards

Analyst for Mynd

Ver Mas

¿Qué tienen que decir otros alumnos?

Únete a 13 millones de estudiantes y empeza Data Analysis in Excel hoy!

Crea Tu Cuenta Gratuita

GoogleLinkedInFacebook

o

Al continuar, acepta nuestros Términos de uso, nuestra Política de privacidad y que sus datos se almacenan en los EE. UU.