Learn it fast with expert-taught software and skills training at lynda.com. Start your free trial

By Curt Frye | Tuesday, January 27, 2015

How to Create Pivot Tables in Excel 2010

Excel workbooks let you summarize your data using a powerful set of built-in functions and features such as sorting and filtering.

That said, basic worksheets are static and make rearranging data difficult. Fortunately, there’s a way to avoid all that cutting and pasting: Pivot Tables.

You can learn everything you’d ever want to know from my lynda.com courses Excel 2007: PivotTables for Data AnalysisExcel 2010: PivotTables in Depthand Excel 2013: PivotTables in Depth.

But here’s a quick-start guide for you:

By Crystal McCullough | Wednesday, September 23, 2009

Microsoft MVP Curt Frye helps dispel the common fear of Excel’s Pivot Tables

In Excel 2008 for Mac: Pivot Tables for Data Analysis, Microsoft Most Valuable Professional Curt Frye helps dispel the common fear of the Pivot Table feature, demonstrating how to use this powerful tool to discover valuable business intelligence. Curt shows how to create Pivot Table reports from internal Excel data and outside data sources, use filters to focus on the most important data in the sheet, and prepare a Pivot Table report by applying formats and rules.

Get the latest news

  •   New course releases
  •   Pro tips and tricks
  •   News and updates
  
New releases submit clicked

You can change your email preferences at any time. We will never sell your email. More info

Featured articles

A lynda.com membership includes:

Unlimited access to our subscription library courses
Certificates of completion
New courses added every week (almost every day!)
Course history to track your progress
Downloadable practice files
Playlists and bookmarks to organize your learning
Start your free trial

Thanks for signing up.

We’ll send you a confirmation email shortly.


Sign up and receive emails about lynda.com and our online training library:

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.

Sign up and receive emails about lynda.com and our online training library:

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

   
submit Lightbox submit clicked
Terms and conditions of use

We've updated our terms and conditions (now called terms of service).Go
Review and accept our updated terms of service.