Saltar al contenido principal
InicioReportingIntroduction to Excel

Introduction to Excel

Master the Excel basics and learn to use this spreadsheet tool to conduct impactful analysis.

Comience El Curso Gratis
4 Horas13 Videos36 Ejercicios
38.735 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

Getting started with Excel

In this Excel course, you’ll learn the fundamentals needed to have you analyzing data in spreadsheets before you know it. This course focuses on helping you navigate Excel and prepare your data for basic analysis. You’ll learn how to manage tables and apply calculations to your data to provide new insights.

Working with Functions

You’ll learn about the many available functions in Excel that can help you to perform calculations, analyze data and, in some cases, automate tasks. We’ll start your journey into understanding the full potential of Excels functions and leverage built-ins such as SUM, AVERAGE, COUNT, UPPER, LEFT, and more.

Visualizing data

We’ll finish this course by explaining the basics of using Excel to effectively communicate data through compelling visuals. You’ll explore the versatility of area, column, and pie charts to help tell a story to bring your analysis to life.
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, reserve una demostración.
  1. 1

    Getting started with Excel

    Gratuito

    In this chapter, you’ll learn how to navigate Excel and understand how best to work with tables. You will cover topics such as navigating the grid layout, importing data, manipulating data with tables, and creating basic formulas.

    Reproducir Capítulo Ahora
    Introduction to Excel
    50 xp
    The possibilities of Excel
    100 xp
    Navigating Excel
    50 xp
    Loading workbooks
    100 xp
    Working with data
    100 xp
    Creating first formula
    100 xp
    Working with tables
    50 xp
    Referencing cells
    50 xp
    Managing data with tables
    50 xp
    Working with structured cell references
    100 xp
    Filtering data
    100 xp
    Formatting tables
    100 xp
  2. 2

    Managing data and applying aggregate functions

    In this chapter, you’ll learn how to work with data in a tabular layout. You will cover topics such as creating named ranges, using subtotals to summarize groups of data, and applying data validation rules. Additionally, you’ll learn how to use aggregate functions in Excel to help summarize your data.

    Reproducir Capítulo Ahora
  3. 3

    Other functions and visualizing data

    Finally, in this chapter, we’ll finish by looking at the various functions available within Excel and learn how to start visualizing basic data. You will cover text, date and time, statistical functions, and learning to use built-in Excel features to visualize your data.

    Reproducir Capítulo Ahora

En las siguientes pistas

Fundamentos de Excel

Colaboradores

Collaborator's avatar
Maarten Van den Broeck
Collaborator's avatar
Carl Rosseel
Collaborator's avatar
Iason Prassides
Jess Ahmet HeadshotJess Ahmet

Content Developer at DataCamp

Ver Mas

¿Qué tienen que decir otros alumnos?

Únete a 13 millones de estudiantes y empeza Introduction to 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.