From the course: Managing Data with Microsoft 365
Join today to access over 25,500 courses taught by industry experts.
Using PivotTables
From the course: Managing Data with Microsoft 365
Using PivotTables
- [Instructor] Have you ever been given a table of data and just thought, "Where do I even start to review this?" I know I have. Luckily, PivotTables can help you make sense of your data easily. In this lesson, I'll show you how PivotTables can simplify data and present it in an easy to read format. In the top left corner of office.com, I'll select the app launcher and open Excel. From here, I'll open the Test Sales Order spreadsheet. You can follow along with this document in your exercise files. We have lots of good data in here. Let's see what it looks like in a PivotTable. There are two PivotTables in this workbook, Pivot Table by Product and Pivot Table by Customer. I'll select the Pivot Table by Product tab near the bottom of the screen. This table not only sorts the data by products, but also provides an overview of who purchased each product. Since this table combines the customer and total spending per item data…
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.