Search Contextures Sites

 

 

Contextures
Newsletter Index

 

 

 

 

30 Excel Functions in 30 Days

 

 

 

Contextures News

Excel Weekly News from Contextures Sept 11, 2012

 
Troubleshoot a worksheet, select functions from a drop down list, create colour coded maps, and other tips, in this week's Excel news from Contextures.

Change Functions With Excel Drop Down List

Select a function name from a drop down list, to change the formulas in a worksheet summary.

For example, choose COUNT, to see the number of orders and then choose SUM, to see the total amount in the lists of orders



Visit my Contextures blog for a video, and a link to the written instructions and sample file: Change Functions With Excel Drop Down List

Format Excel Worksheet for Troubleshooting

Use colour codes to identify cell contents for #Excel troubleshooting. Where are the formulas? Which cells contain constants?
 

Visit my Contextures blog for a video, and written instructions: Format Excel Worksheet for Troubleshooting

Clear All Fields From a Pivot Table

Occasionally, you might want to tear down a pivot table, and rebuild it. You don't have to delete the pivot table though - you can clear all the fields, and then start adding the ones you want.

In the latest post on my Pivot Tables blog, you'll see how to clear a pivot table manually, or with programming.

 

Visit my Excel Pivot Tables blog for the sample code, and written instructions: Clear All Fields From a Pivot Table

Charting Overview for Office 2013

On Microsoft's Excel blog, they discussed the new charting features that will be included in Excel 2013. One of those new features is Chart Recommendations, which will help you select the best chart type for your data.
 

Read the details here: Charting Overview for Office 2013

Handicap History Chart

On the Daily Dose of Excel blog, Dick Kusleika shows how he created a chart of his golf handicap from the past five years.
 

Even if you don't play golf, you'll find some interesting charting tips and techniques in this two-part article.

Handicap History   and   Handicap History Chart

Colour Map With Conditional Formatting

On his Clearly and Simply blog, Robert Mundigl shares his improved code for coloured shapes in a map. One interesting new feature is the popup comments that appear when you point to the shapes, and those are created with hyperlinks.
 
 

Read the details and download his sample file here: Fast Choropleth Map with Enhanced Features

Recommended Excel Tools

They aren't free, but these Excel tools are a worthwhile investment, so please 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 the products mentioned in this newsletter, and earn a commission on the sales.

 

 

Privacy Policy

 

Contextures Inc., Copyright 2016
All rights reserved.