You can use your favorite social network to register or link an existing account:
Or use your email address to register without a social network:
Sign in with these social networks:
Or enter your username and password
Forgot your password?
Yes, please link my existing account with for quick, secure access.
No, I would like to create a new account with my profile information.
You need to learn about and use PivotTable reports. Period. If you're a business owner, a parent, a coach, or anyone else who deals with data, you're doing yourself a disservice by not employing this handy tool. So...it's time to jump in and figure out just what the heck this mysterious (and therefore often maligned) PivotTable report is...and why we should care.
Be sure to read my column Pivot, swivel & roll: Data management with the stars; it will explain about PivotTables in more detail. Promise.)
Listen to my podcast about PivotTable reports.
This screen shot is from Excel 2003, not 2007 or 2010. PivotTables have improved a lot in the last 7 years.
You're absolutely right. However, I just wanted to give an idea of what they can do. (But it wasn't a screen shot, actually; just created art). I took it down because if one person mentions something there are likely many others who are thinking the same thing. Thanks for your comment and come back again!
Listen to my podcast about PivotChart reports: [View:blogs.office.com/.../1385.PivotChart.wma:550:0] Here is an example of a PivotTable report and a PivotChart report:
When working with a list of data containing last names, is there a way to group them alphabetically using "Group Field" rather than grouping them one letter at a time by hand?
@ PIvotTable fan: My suggestion to you is that you pose your question at Microsoft Answers (answers.microsoft.com/.../default.aspx) which is a free online discussion group. It's patrolled by experts such as our MVPs (Most Valuable Processionals), some MS employees, and other real "power users." I've never asked a question there that hasn't received an answer.
So: Go to Microsoft Answers, drill down to the application you're needing to ask the question about (Excel), and then find the appropriate category. Search for what you think is similar to the quesitno you have, and if you don't find any other questions like it, go ahead and ask a question yourself. (Be sure to select the box that indicates you want to be notified by email when someone has responded to your post).