Excel 2010/2013
Excel 2007
Excel 2003
Tips & Tricks
Excel Forum
Course Index CIG Excel Book
Home   News   Tips   Glossary   Templates   Forums   Help   Logon   Order   Contact Us  

News      User Comments     History     Notify Me

6/14/2011 3:01:27 PM
Excel 2010 Expert 7
By Richard Rost   Richard Rost on Facebook Richard Rost on Twitter Richard Rost on Google Plus Richard Rost on LinkedIn Email Richard Rost

The focus of this course is working with PivotTables and PivotCharts in Excel. Topics covered include:
- What is a PivotTable? Why use them?
- Creating a PivotTable
- Set Values, Row & Column Labels
- Editing a PivotTable
- Sort, Filter, Expand, Collapse, Pivot Data
- PivotTable Layout, Slicers, Multiple Values
- Subtotals, Styles, Data Subsets
- Creating & Editing PivotCharts
- Grouping Data by Month, Value Ranges
 - Lots More!

Permanent Link
Course Link: Excel 2010 Expert 7
Keywords: pivottables pivotcharts pivot tables slicers pivot charts
Page Tag: whatsnew
Post Reply

When you select Multiple Items within Managers Comment from Rajiv Dass @ 11/25/2015
When you select "Multiple Items" within Managers (07:37), how do see the Managers Name correlating with their sums?

Reply from Alex Hedley:

You'd need to add it in the row or column
Show Just This Thread        Post Reply
blank column Comment from Rajiv Dass @ 11/25/2015
Hi Richard, How do I get the "blank" column? I have everything else, but the "blank" column and what is it's significance? (04:06)

Reply from Alex Hedley:

Thats dependant on there not being a value in the year column
Show Just This Thread        Post Reply
Job Interview Comment from Anonymous @ 9/11/2015
Hi Richard,
I am preparing for a job interview and was advised to be familiar with how Pivot Tables work. I considered going to Youtube, but after looking at a few videos there, I knew I had to come to your site and get the Pivot Table course. Having an actual Excel file to work with is the way to go! Thank you, I feel way more prepared. Ross

Reply from Alex Hedley:

Glad to hear you're well prepared, good luck and hope it goes well.
Show Just This Thread        Post Reply
Comment from Anonymous @ 4/30/2014
Hi Richard,
For Pivot Tables, in the Options Menu's Totals & Filters Tab, what does "Allow multiple filters per field" mean? Wouldn't 1 be enough?
Show Just This Thread        Post Reply
several PivotTables on their own sheet Comment from Laurie J. @ 5/2/2013
Is it possible to create a workbook that includes several PivotTables on their own sheet that calculate different data? I would like to create a workbook where I can plug in the data and have the information automatically populate. Thank you.

Reply from Richard Rost:

Sure. When creating the PivotTable you can choose to insert it in a new sheet or in a location in an existing sheet. You can in Excel 2013. I'm pretty sure you can in 2010 as well.
Show Just This Thread        Post Reply
PivotTables in Access Comment from Jennifer Hull @ 4/1/2013
Hi    Am using access.  I need to look at data with a 3rd dimension.    
1.  Can you enter data into a pivot table
2. Can you use a pivot table as part of access.

I need to look at 15 fields  ( blood results) for each week,for each patient over a 25 week period.

Reply from Richard Rost:

1. No you cannot enter data directly into a PivotTable
2. PivotTables have been DISCONTINUED in Access 2013. I never liked using them in Access anyway. They were always much better in Excel.

If you explain to me more about what you're trying to do, perhaps I could help you come up with a better solution.
Show Just This Thread        Post Reply
Search for Topics in Lessons Comment from steve jordan @ 12/15/2012
hello, can you install a search option for your lessons. i am looking for the lesson that shows how to do sticky notes.i have bought alot of lessons but find it difficult to remember in which lessons certain tips are found. a search would help me locate itmes i need rather than trying to hunt through all the lessons i bought trying to find some small item.

Reply from Richard Rost:

Yep. See that SEARCH BOX in the upper-right corner of every page on my site? You can use that to search for lesson topics. You do have to know what you're searching for, however. In this case, you're looking for COMMENTS.

You can also drop down that "MORE..." box and go straight to the full outline for all of my Excel class topics. You can use CTRL-F in your browser to search once you're on that page.
Show Just This Thread        Post Reply
Comment from Lois  @ 2/13/2012
I too cannot see the video once I get to Lesson 7. I can only hear the lesson. I cannot find the option in the bottom left corner to switch  

Reply from Richard Rost:

Try downloading the course again. This usually happens if a video didn't completely download 100% successfully. If that doesn't work, try watching the course in the Theater online.
Show Just This Thread        Post Reply
Comment from Becky Young @ 1/13/2012
Do you have self tests for the different levels?

Reply from Richard Rost:

I have tests for SOME of the classes, but we haven't made any new ones in quite some time... it's one of the things on my TO DO list for 2012.
Show Just This Thread        Post Reply
Excel 2010 Expert 7 Comment from Terry Stevens @ 11/11/2011
Excellent Tutorial!

Reply from Richard Rost:

Thank you.
Show Just This Thread        Post Reply
Comment from Bernhard Schmitt @ 10/18/2011
Excel 2010 Expert 7
Why does the vedio player not show a vedio? It just shows a picture.

Reply from Richard Rost:

There's nothing wrong with the video. Try switching to the FLASH player (option in the bottom left corner).
Show Just This Thread        Post Reply
Comment from Mubeezi Micah @ 6/15/2011
Time index: 12:05
The slicer is really a cool feature. Wow!
Show Just This Thread        Post Reply
Excel 2010 Expert 7 Comment from Mubeezi Micah @ 6/15/2011
Dear Richard,

I wonder why i have been afraid to use Pivot tables. You make it look so simple. Thank you for developing this tutorial!


Reply from Richard Rost:

You're very welcome. Glad you enjoyed.
Show Just This Thread        Post Reply

Add Your Comments or Subscribe
If you just want to subscribe to get email updates when the News is updated, then enter your name and email address and check the Notify Me box below. If you would optionally like to add your comments below to be posted, they are welcome.
  Your Name:  Required
  Your Email:  NOT Public


Sorry about this step. It's just to keep the spam bots away:
  Verify: What is 6+1:
  Notify me when the News is updated.
  Remember Me for my next comments
Please do not use this form for Customer Service inquiries! If you have questions about your account, shipping info, courses you've ordered, need passwords, etc. please use the Customer Service Center instead.

I value your comments. They will be displayed on this page (above). Your name will be displayed, but your email address will not be.
As always, I promise to never give away your personal information to anyone else, ever.

NOTE: If you don't leave your name and email address, DON'T expect a reply. I can't promise a personal reply to everyone who posts here. I TRY my best, but I cannot guarantee it. If you don't leave your real name and email address, I won't even bother. I usually just hit DELETE. -Richard



You may want to read these articles from the 599CD News:

5/4/2014Microsoft Access Expert 20
3/5/2013Excel Tip: Price Markups
2/3/2013Signed Copies of my Excel Book
9/27/2012Excel Expert 10 Handbook Ready
9/18/2012Two New Excel Tips: Date/Time Differences
6/20/2012Excel Tip: Sum Cells Between Two Values
6/16/2012New Excel Tip: Paste Link
3/26/2012Excel Tip: 2D Matrix Lookups
11/18/2011Dashboards in Excel
10/6/2011Excel Expert 11 On Hold

Visual Basicindex
Account Login
Online Theater
Lost Password
Free Upgrades
Insider Circle
Student Databases
Change Email
Latest News
New Releases
User Forums
Topic Glossary
Tips & Tricks
Search Our Site
Waiting List
Production Schedule
Collapse Menus
Live Chat
Customer Support
WalkThru Tutorials
Consulting Services
About Us
Affiliate Program
Richard Rost
Free Lessons
Mailing List
Video Tutorials
MYOLP Memberships
Idiot's Guide to Excel
Volume Discounts
Payment Info
Terms of Sale
Gift CDs
Live Chat
General Info
Support Policy
Contact Form
Email Us
Mailing Address
Phone Number
Fax Number
Course Survey
Facebook    Twitter

Google Plus    LinkedIn

Blog RSS Feed    YouTube Channel
Richard Rost Microsoft MVP