Data Preparation in Microsoft Excel
Offered By: Pluralsight
Course Description
Overview
Microsoft Excel is a very popular spreadsheet program that is often
used to manage data. This course will teach you how to use various
Excel functions to prepare your data for further analysis by cleaning,
transforming, and formatting the data.
As you work with data in Microsoft Excel, you will often encounter data that is messy or incomplete. How do you prepare your raw data to make it easier to use? In this course, Data Preparation in Microsoft Excel, you will learn how to use a variety of Excel functions to prepare your data for further analysis by cleaning, transforming, and formatting the data. First, you’ll learn how to add cells to and delete cells from an existing spreadsheet. Next, you’ll learn how to clean and transform your data. Finally, you’ll look at how to format your data and spreadsheet to make it easier to interpret. When you’re finished with this course, you’ll have the knowledge of Excel needed to ensure that your data is properly prepared for your next analytics project!
used to manage data. This course will teach you how to use various
Excel functions to prepare your data for further analysis by cleaning,
transforming, and formatting the data.
As you work with data in Microsoft Excel, you will often encounter data that is messy or incomplete. How do you prepare your raw data to make it easier to use? In this course, Data Preparation in Microsoft Excel, you will learn how to use a variety of Excel functions to prepare your data for further analysis by cleaning, transforming, and formatting the data. First, you’ll learn how to add cells to and delete cells from an existing spreadsheet. Next, you’ll learn how to clean and transform your data. Finally, you’ll look at how to format your data and spreadsheet to make it easier to interpret. When you’re finished with this course, you’ll have the knowledge of Excel needed to ensure that your data is properly prepared for your next analytics project!
Syllabus
- Preparing Your Data 15mins
- Cleaning and Transforming Data 22mins
Taught by
Jason Browning, Ph.D.
Related Courses
Excel 2010Miríadax Pensamiento algorítmico
Tecnológico de Monterrey via Coursera Statistics for Business – I
Indian Institute of Management Bangalore via edX Excel 2010
Universitat Politècnica de València via EMMA Introduction to Spreadsheets and Models
University of Pennsylvania via Coursera