Excel Weekly News from Contextures July 15, 2014
Multiple pivot filters + more Excel tips
Now that summer is here, I am sending you the newsletter twice each month, instead of weekly. You will get the next newsletter on July 29th. In this week's Excel news, you'll see how to change a pivot table setting, to allow multiple filters, and other tips. Thank you for reading the Excel news, and I hope that you are enjoying the Excel articles. If you have suggestions for future topics, please let me know.
- Debra - email@example.com
Summer is a great time to learn something new, if your office is a bit quieter than usual. If you'd like to improve your dashboard skills, Mynda Treacy from My Online training Hub is temporarily opening her Excel Dashboard Course, and if you sign up by July 24th, you can get the course for 20% off. Registration closes on July 31st.
I've been through this course, and highly recommend it. The course is video based, delivered online and is available 24/7. You'll receive comprehensive workbooks and sample dashboards to keep, and there's even an option to download the videos.
Bonus: If you sign up for Mynda's course through one of my links, you can have a copy of one of my Contextures products, such as the PivotPower Premium add-in. When you pay for the course, type DebraD in the Referral code box, just below the Buy Now button.
If you're working with dates or numbers, you might need to add an amount to the existing values. For example, when working on your To Do list, you can add 7 to a group of date cells, to move the tasks to next week.
This is something that I do quite often, so I created a macro that lets me quickly add a number to a group of cells. Maybe it's something that could save you some time too.
Click here to see the details, and download the sample file: Add Number to Multiple Cells in Excel
If you create a calculated item, extra items might appear in the pivot table, with zero amounts in some rows. To hide these zero items, use a Values filter. If you want to apply more than one type of filter, change a setting in the pivot table options, to allow that.
Click here to read the details, watch the video, and download the sample file: Hide Zero Items; Allow Multiple Filters
If you've bought a copy of my PivotPower Premium add-in, make sure you got my email with a link to download the latest version. It's got a few new features, and you can read about them in this article.
If you have suggestions for the next version, please let me know!
Here are a few of the Excel articles that I read last week, that you might find useful:
Use conditional formatting in Excel 2010 and 2013, to show the appropriate currency symbol when selling products in a different country. For example, show USA sales in dollars, UK sales in pounds and Italian sales in Euros.
The garden store had a half-price sale on annual plants, so I couldn't resist buying a few new items for the garden. Unfortunately, none of the flowers had information labels, so I'm not sure what this is, but it certainly is pretty!
In addition to all the free Excel tips and tutorials, there are other Excel tools that you can invest in. To learn more about the products listed below, click on the links to take a look at their features, and decide if they're right for you.
Note: I am an affiliate for some of the products mentioned in this newsletter, and earn a commission on the sales.
Contextures Inc., Copyright ©2017
All rights reserved.