Descriptions
Data preparation in Excel, In The In the course, you will learn how to prepare and clean raw data in Excel worksheets. This course focuses on helping you take advantage of the many features in Excel that allow you to import data from various sources and prepare the data by filtering, deduplicating, and organizing your columns and rows to ensure that subsequent analysis tasks are completed as efficiently as possible. As In addition to Excel’s built-in functions, you will learn to use various functions to handle and edit dates and text strings. You You’ll get an introduction to logical functions that you can use to create new flags and categories in your raw data, and learn how to combine different logical functions in nested formulas. You will You’ll also understand how to use lookup functions in Excel to pull in data from different worksheets and identify specific results in large data sets. Finally, you’ll get a first look at PivotTables – a powerful Excel feature that lets you summarize and analyze large amounts of data using dynamic tables.
What you will learn
- Starting Data preparation in Excel
- Useful Data preparation functions
- Nesting logical functions
- Look up and new table types
Specifications of data preparation in Excel
- Publisher : Data Camp
- Teacher: Jason Prasides
- Language: English
- Level: All levels
- Number of courses: 4
- Duration: 3 hours to complete the course
Contents of data preparation in Excel
Pictures
Sample clip
installation Guide
Extract the files and watch them with your favorite player
Subtitles: English
Quality: 720p
Download links
Password file(s): free download software
File size
72MB