For some more accomplished Excel® users, Office 2007 was a shock when it came to Pivot tables. Excel® 2003 had simplified Pivot Table creation by offering us a simple drag and drop operation right on the screen. We’d simply click any cell in the middle of our table and click Data, Pivot Table and Pivot Chart Report, then Finish. Then we had this fairly self explanatory interface telling us to drag items to particular areas of the screen.
Then, 2007. When we finally find that the Pivot Table icon was on the Insert tab (instead of the Data tab, where most of us looked for it first) and clicked it. We were presented with this…
And, what did they want us to do with that?
To use this interface, simply click the boxes next to the data items you want to include. Excel® will automatically place them in the lower part of the task pane. Then you can simply rearrange where those fields lie on the screen. As you do, you’ll notice the changes in the Pivot Table itself.
If wrapping your head around this new interface is too much on Day 1, then Microsoft® has left us an “out.”
1. Right click on the new image of a Pivot table on the screen.
2. Select Pivot Table Options.
3. Then, click on the Display tab.
4. Check the box next to Classic Pivot Table layout.
Now that should look familiar!
Like what you've read? ...Republish it and share great business tips!
Attention: Readers, Publishers, Editors, Bloggers, Media, Webmasters and more...
We believe great content should be read and passed around. After all, knowledge IS power. And good business can become great with the right information at their fingertips. If you'd like to share any of the insightful articles on BusinessManagementDaily.com, you may republish or syndicate it without charge.
The only thing we ask is that you keep the article exactly as it was written and formatted. You also need to include an attribution statement and link to the article.
" This information is proudly provided by Business Management Daily.com: http://www.businessmanagementdaily.com/16172/excel-2007-pivot-tables-something-old-something-new "