Description
Data Preparation in Excel, the data preparation training course in Excel has been published by Datacamp Academy. In this course, you will learn how to prepare and clean raw data in Excel worksheets. This lesson will help you use the many features in Excel that allow you to import data from various sources and organize your data by filtering, sorting, and organizing your columns and rows. prepare so that the next analysis tasks are done in the best possible way. In addition to the built-in features that Excel offers, you will learn to use various functions to manage and manipulate dates and text strings. You will be introduced to logical functions that allow you to create new flags and categories on your raw data while understanding how different logical functions can be combined into nested formulas. You will also learn how to use search functions in Excel to import data from different sheets and identify specific results in large data sets. Finally, you’ll look at PivotTables, a powerful Excel feature that lets you summarize and analyze large amounts of data using dynamic tables.
What you will learn
- Data preparation in Excel
- Useful functions for data preparation
- Familiarity with logical functions
- Lookups and new table types
Data Preparation in Excel course specifications
- Publisher: Datacamp
- teacher : Jason Prassides
- English language
- Education level: all levels
- Number of courses: 4
- Training duration: 3 hours to complete the course
Chapters of the Data Preparation in Excel course
Course prerequisites
Pictures
Sample video
Installation guide
After Extract, view with your favorite Player.
English subtitle
Quality: 720p
download link
File(s) password: www.downloadly.ir
Size
72 MB
Be the first to comment