Data Preparation in Microsoft Excel

Focused View

Jason Browning, Ph.D.

37:44

0 View

1-Preparing Your Data

1 -Overview.mp4

00:57

2 -Converting Text to Columns.mp4

02:27

3 -Using Autofill to Populate a Column.mp4

02:20

4 -Applying Number Formats.mp4

09:41

2-Cleaning and Transforming Data

5 -Introduction.mp4

00:21

6 -Replacing Values in Your Data.mp4

07:56

7 -Working with String Fields.mp4

05:32

8 -Separating and Combining Fields.mp4

08:30

Description

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.

What You'll Learn?

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!

More details

User Reviews

Rating

average 0

Total votes0

Focused display

Data Science

Jason Browning, Ph.D.

Instructor's Courses

Jason Browning is a data and analytics professional with extensive experience in both the public and private sector. As a Tableau Desktop Certified Professional, Jason loves to build data visualizations that both inform and inspire. He is capable of wrangling messy data both inside and outside of Tableau, and using SQL to perform complex queries. He works in higher education as a data governance and management consultant, and holds a Ph.D. in higher education administration from the University of Wyoming. He loves to interrogate information systems with SQL to answer business questions and satisfy his data consumers. Jason lives in the Seattle area with his wife and two canine companions, and loves to get outdoors or do woodworking. Even in these pursuits, he is looking for the next data viz inspiration!

Pluralsight

View courses Pluralsight

Pluralsight, LLC is an American privately held online education company that offers a variety of video training courses for software developers, IT administrators, and creative professionals through its website. Founded in 2004 by Aaron Skonnard, Keith Brown, Fritz Onion, and Bill Williams, the company has its headquarters in Farmington, Utah. As of July 2018, it uses more than 1,400 subject-matter experts as authors, and offers more than 7,000 courses in its catalog. Since first moving its courses online in 2007, the company has expanded, developing a full enterprise platform, and adding skills assessment modules.