navigate site menu

Start learning with our library of video tutorials taught by experts. Get started

Excel 2010: Pivot Tables in Depth
Richard Downs

Excel 2010: Pivot Tables in Depth

with Curt Frye

 


In Excel 2010: Pivot Tables in Depth, author Curt Frye provides comprehensive, hands-on tutorials on Excel PivotTables, including more advanced techniques such as using macros and the new PowerPivot add-in. The course shows how to connect and consolidate data sources to power PivotTables, sort and filter records, display data in a PivotChart, print tables and charts, and also introduces the DAX language for performing advanced summaries in PowerPivot. Exercise files are included with the course.
Topics include:
  • Formatting data for use in a PivotTable
  • Connecting to an external data source
  • Refreshing a data source
  • Adding, removing, and positioning subtotals and grand totals
  • Creating a calculated field
  • Grouping PivotTable fields
  • Clearing and reapplying PivotTable filters
  • Applying field styles
  • Formatting cells
  • Creating a PivotChart
  • Printing PivotTables and PivotCharts
  • Creating relationships between tables in a PowerPivot model
  • Using the DAX language for advanced summaries in PowerPivot

show more

author
Curt Frye
subject
Business, Spreadsheets
software
Excel 2010, Office 2010
level
Intermediate
duration
3h 42m
released
Apr 19, 2011

Share this course

Learn more about lynda.com

Start learning today. Lynda explains how.

Ready to join? get started

Keep up with news, tips, and latest courses.

submit Course details submit clicked more info

Please wait...
Curt Frye

Curt Frye

Curt Frye is a freelance writer and consultant who specializes in Microsoft Excel. He is the author of more than 40 books and online training courses, including Microsoft Excel 2010 Step by Step (Microsoft Press), the Excel 2007 Pocket Guide (O'Reilly Media), and over a dozen courses for lynda.com. Curt is also a valued speaker who delivers keynote addresses on Excel as a business intelligence analysis tool and his Improspectives ™ approach to business communication.
Course Title   Level   Duration   Released  
Excel 2007: Financial Analysis Intermediate 2h 18m 08/2009  {8}
Excel 2007: Pivot Tables for Data Analysis Intermediate 2h 45m 11/2009  {8}
Excel 2008 for Mac: Pivot Tables for Data Analysis Intermediate 1h 6m 09/2009  {8}
Excel 2007: Introduction to Formulas and Functions Intermediate 2h 26m 11/2009  {8}
Migrating from Excel 2003 to Excel 2007 Appropriate for all 41m 29s 11/2009  {8}
Excel 2007: Creating Charts with Dynamic Data Intermediate 40m 47s 12/2009  {8}
Excel 2007: Creating and Managing Invoices Intermediate 38m 59s 11/2009  {8}
Excel 2010: Real-World Projects Appropriate for all 25m 0s 01/2010  {8}
Up and Running with VBA in Excel Advanced 3h 0m 06/2010  {8}
Excel 2007: Creating Business Budgets Intermediate 1h 3m 06/2010  {8}
Excel for Mac 2011 Essential Training Beginner 6h 32m 10/2010  {8}
Excel 2007: Business Statistics Intermediate 4h 19m 12/2010  {8}
Excel 2010: Pivot Tables in Depth Intermediate 3h 42m 04/2011  {8}
Excel 2010: Financial Functions in Depth Intermediate 2h 20m 06/2011  {8}
Up and Running with VBA in Access Advanced 4h 38m 10/2011  {8}
Crystal Reports 2011 Essential Training Beginner 3h 25m 05/2012  {8}
Up and Running with Office Web Apps Beginner 3h 23m 01/2013  {8}
Excel 2013: Pivot Tables in Depth Intermediate 4h 15m 04/2013  {8}
Excel 2013 Power Shortcuts Intermediate 3h 16m 02/2013  {8}

Suggested courses to watch next:

Excel 2010 Power Shortcuts (3h 43m)
Dennis Taylor

Excel 2010: Charts in Depth (3h 38m)
Dennis Taylor


Excel 2010: Financial Functions in Depth (2h 20m)
Curt Frye

Excel 2010: Macros in Depth (2h 44m)
Dennis Taylor


Are you sure you want to delete this bookmark?

cancel

Bookmark this Tutorial

Name

Description

{0} characters left

Tags

Separate tags with a space. Use quotes around multi-word tags. Suggested Tags:
loading
cancel

bookmark this course

{0} characters left Separate tags with a space. Use quotes around multi-word tags. Suggested Tags:
loading
cancel

Error:

go to playlists »

Create new playlist

name:
description:
save cancel

You must be a lynda.com member to watch this video.

Every course in the lynda.com library contains free videos that let you assess the quality of our tutorials before you subscribe—just click on the blue links to watch them. Become a member to access all 104,069 instructional videos.

get started learn more

If you are already an active lynda.com member, please log in to access the lynda.com library.

Get access to all lynda.com videos

You are currently signed into your admin account, which doesn't let you view lynda.com videos. For full access to the lynda.com library, log in through iplogin.lynda.com, or sign in through your organization's portal. You may also request a user account by calling 1 1 (888) 335-9632 or emailing us at cs@lynda.com.

Get access to all lynda.com videos

You are currently signed into your admin account, which doesn't let you view lynda.com videos. For full access to the lynda.com library, log in through iplogin.lynda.com, or sign in through your organization's portal. You may also request a user account by calling 1 1 (888) 335-9632 or emailing us at cs@lynda.com.

Access to lynda.com videos

Your organization has a limited access membership to the lynda.com library that allows access to only a specific, limited selection of courses.

You don't have access to this video.

You're logged in as an account administrator, but your membership is not active.

Contact a Training Solutions Advisor at 1 (888) 335-9632.

How to access this video.

If this course is one of your five classes, then your class currently isn't in session.

If you want to watch this video and it is not part of your class, upgrade your membership for unlimited access to the full library of 2,025 courses anytime, anywhere.

learn more upgrade

You can always watch the free content included in every course.

Questions? Call Customer Service at 1 1 (888) 335-9632 or email cs@lynda.com.

You don't have access to this video.

You're logged in as an account administrator, but your membership is no longer active. You can still access reports and account information.

To reactivate your account, contact a Training Solutions Advisor at 1 1 (888) 335-9632.

Need help accessing this video?

You can't access this video from your master administrator account.

Call Customer Service at 1 1 (888) 335-9632 or email cs@lynda.com for help accessing this video.

preview image of new course page

Try our new course pages

Explore our redesigned course pages, and tell us about your experience.

If you want to switch back to the old view, change your site preferences from the my account menu.

Try the new pages No, thanks

site feedback

Thanks for signing up.

We’ll send you a confirmation email shortly.

By signing up, you’ll receive about four emails per month, including

We’ll only use your email address to send you these mailings.

Here’s our privacy policy with more details about how we handle your information.

Keep up with news, tips, and latest courses with emails from lynda.com.

By signing up, you’ll receive about four emails per month, including

We’ll only use your email address to send you these mailings.

Here’s our privacy policy with more details about how we handle your information.

   
submit Lightbox submit clicked