Datacamp – Data Preparation in Excel 2023-11

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. As well as the built-in features Excel offers, you will learn to use different functions to handle and manipulate dates and text strings. 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. 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.

What you’ll learn

• Starting data preparation in Excel
• Useful functions to prepare data
• Nesting logical functions
• Lookups and new table types

Specificatoin of Data Preparation in Excel

• Publisher : Datacamp
• Teacher : Iason Prassides
• Language : English
• Level : All Levels
• Number of Course : 4
• Duration : 3 hours to complete the course

Content of Data Preparation in Excel

Pictures

Sample Clip

Installation Guide

Extract the files and watch with your favorite player

Subtitle : English

Quality: 720p

Download Links

Download – 72 MB

File size

72 MB