Learn how to use PivotTables to summarize, sort, and analyze your data in Excel for Mac 2016.
- [Voiceover] Hi, I'm Curt Frye. Welcome to Excel 2016 for Mac: Pivot Tables in Depth. In this course, I'll show you how to use Pivot Tables to gain valuable insights from your organization's data. I'll begin by showing you how to create a Pivot Table from data already in your Excel workbooks. Then, using that knowledge as a base, I'll demonstrate how to create Pivot Tables using data from an external source. Next, I will enhance your ability to analyze your data by showing you how to reorganize, or pivot, a Pivot Table.
After you've organized your Pivot Table's data, you can sort and filter its contents to develop useful insights into your business. I'll also show you how to change your Pivot Table's summary operations, add calculated fields to enhance understanding of your data, and drill down from a Pivot Table value to view the data behind the summary. Finally, I'll show you how to format your Pivot Table using Styles, apply conditional formats to summarize your data visually, and share your Pivot Tables as printed, and PDF, documents.
In short, I'll show you how to summarize and analyze data using one of Excel's most powerful and overlooked features. Thanks again for spending time with Excel 2016, for Mac, Pivot Tables in Depth. Dive right in.
Author
Released
3/19/2016- Name the option you use to limit the data that appears in a PivotTable.
- Explain how to create a PivotTable after clicking a cell in the data set.
- List the steps needed to see the sum of reservations on a PivotTable.
- Recall how to return all the data to the body of a PivotTable.
- Name the contextual menu that allows you to create new PivotTable style.
- Determine the category of the Format Cells dialog that lets you change the decimal places and the money symbol.
Skill Level Intermediate
Duration
Views
Related Courses
-
Excel for Mac 2016 Essential Training
with Curt Frye6h 23m Beginner -
Setting Up a Database in Excel 2013
with Dennis Taylor49m 17s Intermediate
-
Introduction
-
Welcome1m 16s
-
-
1. Creating and Pivoting PivotTables
-
Introducing PivotTables3m 6s
-
Creating a PivotTable3m 12s
-
Pivoting a PivotTable2m 57s
-
Configuring a PivotTable3m 51s
-
Managing PivotTables4m 16s
-
-
2. Summarizing PivotTable Data
-
Creating a calculated field3m 13s
-
3. Sorting and Filtering PivotTable Data
-
Sorting PivotTable data3m 15s
-
Formatting slicers3m 44s
-
-
4. Formatting and Printing PivotTables
-
Applying a PivotTable style3m 30s
-
Creating a PivotTable style4m 32s
-
Printing a PivotTable3m 18s
-
-
5. Applying Conditional Formats to PivotTables
-
Conclusion
-
Next steps1m 46s
-
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.
CancelTake notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.
Share this video
Embed this video
Video: Welcome