Search Contextures Sites


Newsletter Index





30 Excel Functions in 30 Days




Contextures News

Excel Weekly News from Contextures Feb 12, 2013

Date picker tool, pivot table Index, and other tips, in this week's Excel news from Contextures.

 -  Debra

Date Picker Tool

To make it easy to insert dates in a workbook, you can use this free Date Picker tool, created by Jim Cone.

Select a date in the calendar popup, then click Insert, to add it to the worksheet. You can even add a one month or one year calendar to a worksheet, just by clicking a button.

To see the details, and to download the date picker file, click here: Free Date Picker Tool

New ISFORMULA Function in Excel 2013

Last week we saw the new FORMULATEXT function, and this week we'll take a look at ISFORMULA -- another one of the new functions in Excel 2013.

You can use ISFORMULA for auditing or troubleshooting a worksheet. For example, use ISFORMULA with conditional formatting, to highlight the cells that contain formulas.

To see the details, click here: ISFORMULA Function

Compare Values With Index

In a pivot table, you can show the values summarized by SUM, COUNT, and several other functions. You can also add custom calculations, such as a Running Total.

One of the least used custom calculations is Index, which gives you a picture of each value's importance in its row and column context.

The Index custom calculation gives you an interesting view of your data, and is slightly different from the % of Grand Total view.

Click here, to read the details: Show Value Weight With Pivot Table Index

Will You Buy a Surface Pro?

On his blog, VisiCalc creator, Dan Bricklin, looks at the new Surface Pro tablet from Microsoft, and wonders if Excel might be the reason that people will buy it. When VisiCalc was released for the Apple II in 1979, it prompted thousands of people to buy an Apple II, just so they could use the amazing new spreadsheet program. VisiCalc is recognized as the first "killer application".

The Surface Pro, starting at $899 US, is expensive, but it runs Windows 8, and you can install Excel on it, not just programs that are "Excel compatible".

Is that enough of a reason for you to buy one? The Surface Pro is beyond my budget for now, because I got a new laptop, a couple of months ago. I'll have to save my pennies for a while, before I can start shopping again!

To see Dan's article, click here: Surface Killer App

PowerPivot Online Course

A powerful data analysis tool -- PowerPivot -- was introduced in Excel 2010, and Chandoo is about to start his new online PowerPivot course, to help you learn how to make the most of this amazing tool.

This course 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 only open for a few more days -- 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.

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.



Privacy Policy


Contextures Inc., Copyright 2017
All rights reserved.