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 ability to pull so much data from a database and summarize the data so quickly when the number of records will easily exceed the number of rows Excel can hold is a huge benefit.
One thing I wish Pivot tables would allow is to do vlookups to other data within the workbook. There are many times when I have multiple pivot tables in one workbook and have to summarize pull that data together on one tab and do calculations.
Pivot tables – don’t understand them – no idea how they work, have a faint clue of how they can help me, so – seems like I need to start digging into it considering all of the data I manulipate! As far as improving? You no sey? maybe after I get into them.
Pivot tables have changed the way I think about data and data structure. I am ready to move to the PowerPivot step but just haven’t gotten a chance to put in the study time yet. One thing that bothers me about Pivot Tables in the newer Excel versions is that I learned them in Excel 2003 and so I always go into the options to change it back to the 2003 layout, with the ability to drag and drop items to move them around. I don’t understand why the newer way is better and don’t like the way the data lays out visually. I should note that I have Excel 2010, so I don’t know what changes were made in 2013.
Pivot tables are a great way to quickly summarize data.
It can be tedious retaining formatting.
1. Pivot Tables allows me to organise (for classifications, groups and patterns) and present multidimensional data/information.
2. I want PivotTables to add value in the handling of increased number of rows/columns combination per table.
I need these tips and tools to perform better in Excel. I wish myself good luck.