Microsoft Excel: Intermediate Pivot Tables

This lesson is part of the following series:

Microsoft Access & Excel: Concept Video Series (14 lessons, $217.80)
Microsoft Excel: All Concept Videos Series (9 lessons, $148.50)
Microsoft Excel: Using & Manipulating Pivot Tables (3 lessons, $69.30)

This is the second video in a series that covers the nuts and bolts of Pivot Tables in Microsoft Excel. This series is designed for students and coaches seeking to learn access to compete in the UIL High School Computer Applications contest but has proven to be useful for anyone seeking to learn or brush up on their Excel skills. In this lesson, we focus on intermediate level features and capabilities of pivot tables in Excel.

In this video, among other things, you'll learn:
- duplicating or copying existing pivot tables
- grouping manually to create new fields within a pivot table
- using subtotals - adding them, determining where they'll show, picking what math function to use for them, etc
- formatting values within pivot tables
- displaying values in alternative way (as a percentage of row totals, as a percentage of column totals, as a percentage of grand totals, etc)
- sorting and filtering fields by values (of that field or other fields) to order data in more useful ways
- utilizing filtering to show top 10 (or any other count) or bottom 10 (or any other count) of items

To illustrate these things, we'll work with a pivot table that we create off of a provided data set. Note that a starting point worksheet is attached as is the ending point worksheets (in the attached Excel workbook) in order to allow you to work off of the starting document and compare your results to the ending document.

This video is screencasted. To watch it in the resolution in which it was recorded (which will offer a crisper screen resolution than the player here), move your mouse over the player and click the 100% (Actual Size) button.

This video was recorded using Microsoft Excel 2010. There are very minor differences between Excel 2007 and 2010, but the content covered here is virtually the same across versions.

• Once you purchase this lesson you will have access to these files:
• Pivot_Table_Intermediate_-_Starting_File.xlsx
• Pivot_Table_Intermediate_-_Ending_File.xlsx

Academic publishing company for 28+ years offering instructional videos, books, software, virtual flashcards, workshops, spelling coaching, and geographic coaching. Most products are geared for competitive academics and home schooling to include materials to study for the Scripps' National Spelling Bee, National Geographic Bee, Texas University Interscholastic League (UIL), North South Foundation, TAPPS, SAT, and more. The 2010 National Spelling Bee champion, Anamika Veeramani was the 11th champion in a row to use our products. Studio Hexco at MindBites is a collection of course material and live presentations by experts in a variety of popular topics. We welcome and appreciate your...

This lesson has not been reviewed.

Please purchase the lesson to review.