Search Contextures Sites
Excel Weekly News from Contextures Sept 11, 2012Troubleshoot 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 ListSelect 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 TroubleshootingUse 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 TableOccasionally, 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 2013On 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 ChartOn 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 FormattingOn 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 ToolsThey 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.
- Contextures 30 Excel Functions in 30 Days
- Excel Charting Tools
- Excel Dashboard Kits
- Excel Project Management Templates
- Excel VBA School
- Excel Pivot Table Intro Course
Note: I am an affiliate for the products mentioned in this newsletter, and earn a commission on the sales.
Contextures Inc., Copyright ©2014
All rights reserved.