Search Contextures Sites
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 firstname.lastname@example.org
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
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.