Join Curt Frye for an in-depth discussion in this video What you should know before watching this course, part of Excel for Mac 2011: Pivot Tables in Depth.
- View Offline
- [Voiceover] Before I dive into the details of using pivot tables in Excel 2011 for Mac I'd like to give you an overview of some things that you should know before you jump in. First is that you should have good familiarity with Excel 2011. While this isn't strictly necessary you'll certainly find that it helps. First you should be familiar with analyzing data using Excel tables. I teach you how to create and use Excel tables but I don't go into all the details. They're extremely useful so I encourage you to learn all about them.
Second is formula creation. You'll be using different types of constructs within the Excel pivot tables. So having a good handle on creating formulas will be very useful. Also, it will help if you know a lot about sorting and filtering. Sorting and filtering is a task that again I teach you in detail when it comes to pivot tables. But I find that these items are much easier to learn if you're familiar with these tasks working with regular worksheets. Also, you should be familiar with creating and manipulating styles and formats.
You won't be creating cell formats specifically or workbook themes but you will be doing related tasks and having some background in creating and manipulating styles and formats will certainly be helpful. And finally I'd just like to note that pivot tables have a bad reputation because they're dynamic and everyone thinks that they're extremely difficult. Pivot tables aren't hard. They're just different. And once you understand how they work, taking data from a data list and putting them into a dynamic format you'll find that you have a powerful and relatively easy to use tool that you didn't have before.
- Creating a PivotTable
- Refreshing PivotTable data
- Managing totals
- Creating calculated fields
- Grouping PivotTable fields
- Sorting and filtering PivotTable data
- Printing PivotTables