Search Contextures Sites
Excel Weekly News from Contextures Feb 6, 2013
New functions, chart baselines, and other tips, in this week's Excel news from Contextures.
- Debra firstname.lastname@example.org
New FORMULATEXT Function in Excel 2013
There is a new function in Excel 2013 -- FORMULATEXT -- that lets you show the text from a cell's formula.
You can use FORMULATEXT for auditing or troubleshooting a worksheet. For example, combine FORMULATEXT with the INDIRECT function, to check the formula in any cell.
To see the details, and to watch a short video tutorial, click here: FORMULATEXT Function
Hide Drop Down Arrows in Pivot Table
When you add a field to the Row Label or Column Label area of the pivot table, its heading cell shows a drop down arrow. When you click the arrow, you’ll see Sort and Filter options, for the selected field.
If you want to prevent people from doing manual filtering, you can hide the drop down arrows, by using a bit of Excel VBA programming.
Click here, to get the sample code, and to read the details: Hide Drop Down Arrows in Pivot Table Headings
Add Baseline in Column Chart
On his blog, Excel charting expert, Jon Peltier, shows how to add a baseline in an Excel column chart. There is a long list of steps, but the steps are simple, and the result looks great.
To see the instructions, click here: Another Simple Baseline for Excel Column Chart
PowerPivot Online Course
A powerful data analysis tool -- PowerPivot -- was introduced in Excel 2010, and Chandoo has just opened his new online PowerPivot course, to help you learn how to make the most of this amazing tool.
This course is a good investment, and it will show you how to use Power Pivot to analyze data, create advanced reports, and prepare dashboards, all within the familiar interface of Excel.
Registration is open until Feb. 15th, and classes start on Feb. 18th. To enroll in the course, you should be familiar with Excel and pivot tables, and should be using Excel 2010 or Excel 2013.
To learn more about the course, and all that is included, click here: Learn PowerPivot Online
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 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
- 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.