Search Contextures Sites

 

Contextures
Newsletter Index

 

Contextures
Excel news
by email

 

 

 

30 Excel Functions in 30 Days

 

 

 

Contextures News

Excel Weekly News from Contextures Feb 6, 2013

New functions, chart baselines, and other tips, in this week's Excel news from Contextures.

 -  Debra ddalgleish@contextures.com

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

Learn Excel Dashboards

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.

Learn how to create Excel dashboards.

 

Privacy Policy

 

Contextures Inc., Copyright ©2014
All rights reserved.