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 - firstname.lastname@example.org
- Add Number to Selected Cells
- Allow Multiple Filters in Pivot Table
- PivotPower Premium Update
- More Excel Tips
- Video: Conditional Format Currency
- Weekly Photo: The Mystery Flower
- Excel Tools
Excel Dashboard Course
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.
Add Number to Selected Cells
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
Hide Zeros and Allow Multiple Filters
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
PivotPower Premium Update
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!
More Excel Tips
Here are a few of the Excel articles that I read last week, that you might find useful:
- Do you agree with these 10 common spreadsheet mistakes? I'm not even sure what some of them mean!
- On Microsoft's MSDN Blog, Eric Ligman shared a list of free ebooks, including Excel shortcuts and quick start guide.
- Chandoo announced the winners of his state migration dashboard contest. He said the winner, Roberto Mensa, was Messi, but apparently that's a compliment. ;-)
- The FrankensTeam has created another interesting chart in Excel, and you can download the sample file. It's based on a vintage chart that shows occupational distribution.
- If you'd like to learn about the new Power BI features in Excel 2013, the MSDN blog has started a free series of lessons.
- Finally, for a humorous peek at what other people are saying about spreadsheets, read this week's collection of Excel tweets, on my Excel Theatre blog.
Video: Conditional Format Currency
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 Mystery Flower
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!
Recommended Excel Tools
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.
- Charles Williams has released a new version his add-in, FastExcel V3, and you'll get 50% off the bundle price, if you use Coupon Code FXLV3Intro (valid until July 31 2014)
- Contextures Excel UserForm Course
- Contextures Excel Tools Add-in
- Contextures PivotPower Premium Add-in
- Contextures 30 Excel Functions in 30 Days
- Excel Online Course
- Excel Charting Tools
- Excel Dashboard Kits
- Excel Project Management Templates
- Excel VBA School
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.