Inicio ReportingData Preparation in Excel

Data Preparation in Excel

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

Comience El Curso Gratis

3 Horas9 Videos28 Ejercicios

16.568 AprendicesDeclaración de cumplimiento

Crea Tu Cuenta Gratuita

Google LinkedIn Facebook

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

Starting data preparation in Excel

In this course, you’ll learn how to prepare and clean raw data in Excel worksheets. This course focuses on helping you utilize the numerous features in Excel that allow you to bring in data from different sources and prepare the data by filtering, deduping, and organizing your columns and rows to ensure subsequent analysis tasks are done as efficiently as possible.

Useful functions to prepare data

As well as the built-in features Excel offers, you will learn to use different functions to handle and manipulate dates and text strings.

Nesting logical functions

You will be introduced to logical functions that will allow you to create new flags and categories within your raw data while understanding how different logical functions can be combined in nested formulas.

Lookups and new table types

You will also understand how to use lookup functions in Excel to bring in data from different sheets and identify specific results within large datasets. Finally, you will get your first glimpse of PivotTables - a powerful Excel feature that allows you to summarize and analyze large volumes of data using dynamic tables.

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ás

En las siguientes pistas

Fundamentos de Excel

Ir a la pista

1
Starting Data Preparation in Excel
Gratuito
In this chapter, you’ll learn different ways to source and import your raw data into Excel. You will then start your preparation of raw data by removing duplicates added in error and filling in the missing parts of your data that will help you prepare the best dataset for analytical use.
Reproducir Capítulo Ahora
The data preparation journey
50 xp
Data preparation steps
100 xp
Load and clean data
50 xp
Importing files
100 xp
Deduping
100 xp
Flashy filling
100 xp
Series filling
100 xp
2
Functions for Data Preparation
In this chapter, you’ll learn how to use text category functions to combine text strings with useful variables for better analysis. You will also utilize some of Excel's date and time functions, taking simple date columns to a new level.
Reproducir Capítulo Ahora
Text and date functions
50 xp
Which function category?
100 xp
More functions, better preparation
50 xp
Equal length
100 xp
Joining together
100 xp
Dates and more
100 xp
3
Conditional Formulas
In this chapter, you’ll learn how to use logical functions to create conditional formulas for new flags and filters for your data. You will combine the logical operators to create nested formulas, specifically using the IF function to create new category data. Additionally, you will understand how to differentiate between notes and comments in Excel and use them effectively to share information with others.
Reproducir Capítulo Ahora
Using logical functions in formulas
50 xp
Which conditional formula is right?
50 xp
Logical data preparation
50 xp
To be, or NOT to be
100 xp
Functions two by two
100 xp
Well nested IF functions
100 xp
Notes and comments
100 xp
4
Lookups and Data Transformation
In this chapter, you’ll finish by looking at some important lookup and reference functions available within Excel, specifically the VLOOKUP and HLOOKUP functions. Additionally, you’ll be introduced to the powerful world of PivotTables, which helps you summarize and analyze large volumes of data through dynamic tables.
Reproducir Capítulo Ahora
Lookups and PivotTables
50 xp
Good arguments
50 xp
Referencing and summarization
50 xp
Look up, not down
100 xp
Pivot. Pivot!
100 xp
A category of products
100 xp
Grand total percentages
100 xp
Congratulations!
50 xp