Last week, we had a giveaway for the new Excel Tips Workbook from Vertex42. Thanks to Jon Wittwer for donating the prizes, and here are the winners:
- Tim, with comment 5
- Ute-S, with comment 34
Congratulations, and I will email you later today, to arrange sending your copy of the file.
PivotPower Premium
We’ve been fortunate to have some great prizes for the summer giveaways, and I really appreciate the generosity of my Excel colleagues.
Now it’s my turn to provide the prizes. This week, you’ll have a chance to win a copy of my Excel add-in for working with pivot tables – PivotPower Premium (Ribbon Version). There will be 2 winners, so be sure to enter!
[Update: This product is no longer available]
The add-in is easy to install, and is designed for Excel 2007 and later (Windows only). One of its time-saving features is Set Defaults, which lets you store your favourite pivot table settings. Then, select any pivot table, click Apply Defaults, and all those settings are applied.
More Tools for Pivot Table Work
There are many more tools in the PivotPower Premium add-in, including number formats, and a button that changes all the fields to Sum. That’s handy when Excel decides that half of your fields should be “Count of”.
There are even a few tools for changing your workbook and worksheet settings, so your pivot tables can look their best. The screen shot below shows the Ribbon in Excel 2010, and the one above is in Excel 2013.
Enter the Giveaway
I’m picking 2 winners for this giveaway. If you’d like a chance to win a copy, please read the rules, and then make a comment below.
- In your comment, tell me one thing that you love about pivot tables, AND/OR one thing that pivot tables should do better.
- Include your email address, so I can contact you if you win. Your contact information won’t be publicly visible, and it won’t be used for any other mailings.
- The deadline is Wednesday, August 21st, 2013, at 12 noon Eastern Daylight Time.
- One entry per person.
- The 2 winners will be announced on Thursday, August 22nd, 2013.
- Each winner will have 24 hours to claim the prize, and if not claimed, another name will be selected.
__________________________
The best thing about Pivot tables, is that they make me look a lot cleverer than I really.
I love Pivot tables and found half the time when I add more for display (not calculate) I convert them so they are not nested under go across and set it so the column repeats down.
In many cases I am counting as much as summing. I think some forget about counting. I don’t even like to make a pivot table with out a slicer next to it.
One feature I would like to see is when an Excel Pivot table is linked to an Access query is to have the ability to alter the query directly from the Pivot.
I love how quickly and flexible I can analzye data with a pivot table. As a beginner I dont know, what Excel pivot table should doe better
Its easier to create relationships between tables and manage them easily.
One of the best features is using the power of pivot tables to filter down really complex data ranges and then outputting just those results to a separate worksheet tab that can then be easily emailed or exported for someone else to review or action depending on content, great for simplifying large database results.
Something that would be a huge benefit in my organisation would be if Pivot Tables could be used on shared workbooks. It seems they can not be changed and will not update when shared.