Search Contextures Sites

 

Contextures
Newsletter Index

 

Contextures
Excel news
by email

 

 

 

Excel UserForms for Data Entry

 

30 Excel Functions in 30 Days

 

 

Contextures News

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 -  ddalgleish@contextures.com

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:

  • On Microsoft’s MSDN Blog, Eric Ligman shared a list of free ebooks, including Excel shortcuts and quick start guide.
  • 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)
  • To raise your pivot table skills to the expert level, I recommend the Xtreme Pivot Table course, with more than 200 videos, along with practice workbooks, finance business cases, and 12 months of personal support.When you buy the course, use the coupon code CONTEXTURES for a 10% discount.

Note: I am an affiliate for some of the products mentioned in this newsletter, and earn a commission on the sales.

________________________

Learn how to create Excel dashboards.

 

Privacy Policy

 

Contextures Inc., Copyright ©2014
All rights reserved.