Excel Weekly News from Contextures Mar 04, 2014
Create colored Harvey Ball icons + more Excel tips
In this week's Excel news, you'll see how to create colored Harvey Ball icons, and other tips. Thank you for reading the Excel news!
- Debra firstname.lastname@example.org
Create Colored Harvey Balls in Excel
In Excel 2010, and later versions, you can use the built-in icon sets for conditional formatting, and choose specific icons from the available options. There are limitations to the color options though, so you can build your own.
This week, you'll see how to create a colored set of Harvey Ball icons, by using a custom number format (available in Excel 2010 and later).
Click here to see the details: Create Colored Harvey Balls in Excel
Accidentally Create Calculated Items
Did you know that you can accidentally create calculated items in a pivot table? In the screen shot below, Formula1 and Formula2 were added with a simple slip of the hand.
Here's how it happens, and how to remove any calculated items that you don't need.
Click here to see the details: Accidentally Create Calculated Items
Show Drop Down With No Blanks
You can create a drop down list in a cell, but if the source list has blank cells, they'll show up in the drop down. Use formulas to create a drop down list with no blanks cells.
Click here to see the details: Show Drop Down With No Blanks
More Excel Tips
Here are a few of the Excel articles that I read last week, that you might find useful:
- You've seen Excel's #DIV/0! error a few times, and Mike Alexander explains why it's mathematically impossible to divide by zero.
- Scott Lyerly lists his favourite books and websites for getting started with Excel programming. What would you add to the list?
- Have you ever built a convoluted workbook, with formulas that make even your head hurt? John Rougeux shares his 3 Excel pro tips for helping others not hate you.
- PowerPoint MVP Geetesh Bajaj gives his recommendations for using Excel and PowerPoint together.
- Finally, for a humorous peek at what other people are saying about Excel, read this week's collection of Excel tweets, on my Excel Theatre blog.
Video: Ignore Blank Setting in Drop Downs
When you create a drop down list in Excel, there is a check box for "Ignore Blank". This video shows an example of how to use that setting to prevent data entry problems.
Is it getting warmer where you live? Here in the Northern Hemisphere, we're looking for signs of spring, and an end to the frigid temperatures. I saw this old fashioned thermometer last week, that uses iodine to show when it's getting warmer. The dark purple crystals turn to a pink gas, when the temperature rises. I hope your forecast is rosy!
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.
- 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.