From the course: Learning Data Analytics Part 2: Extending and Applying Core Knowledge
Join today to access over 25,300 courses taught by industry experts.
Build basic pivot tables
From the course: Learning Data Analytics Part 2: Extending and Applying Core Knowledge
Build basic pivot tables
- [Instructor] When using a pivot tool on data, it's important to remember the pivot you build is going to use the data you provide. It will not change the underlying dataset. And speaking of datasets, pivot tools expect a clean dataset, similar to what you see in our pivot data file in our exercise folder. So you need to do those cleaning steps before you actually pivot. Pivot tools use column headings to create your available fields, and because you'll be calculating values, you want to make sure your fields have the correct data type. For example, dates are dates and numbers are numbers, not text. If you need a refresher on cleaning data and making meaningful headers, check out the previous course, "Learning Data Analytics, Part One" in the library. Now let's insert our first pivot. I'll go to insert, tables, pivot table. It automatically detects my range and I do want it to be on a new worksheet. I'll go ahead and click OK. One of the first things I want to show you is that on the…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.