Join Curt Frye for an in-depth discussion in this video What you should know before watching this course, part of Excel for Mac 2016: Pivot Tables in Depth.
- [Voiceover] Before I go into the details of Excel 2016 for Mac, Pivot Tables and Depth, I'd like to review some of the skills that will help you get the most out of this course. First, of course is that you should have good familiarity with the Mac OS, and also with using programs on the Mac in general. Specifically, you should have a facility creating and managing files as well as storing data in Excel tables. You should also develop the ability as you go through the course to ask good questions.
As you rearrange your data you'll get a lot of insights as we go along. And finally, you should experiment and explore. Pivot Tables are extremely powerful tools within Excel, and the more you use them, the more you'll get out of them.
Author
Curt Frye
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
-
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
-
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
Press 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: What you should know before watching this course