Course description
Understand how to prepare Excel data through logical functions, nested formulas, lookup functions, and PivotTables.
Upcoming start dates
1 start date available
Training content
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.
Quick stats about Datacamp?
More than 14 Million learners worldwide
80% of the Fortune 1000 use DataCamp
Contact this provider
Datacamp
DataCamp offers a comprehensive platform for learning data skills, specializing in training individuals and teams in data science, analytics, and AI. With a focus on interactive, hands-on learning, DataCamp provides courses across key programming languages such as Python, R, SQL,...
Ads