Daily tips for using Microsoft Excel.

Wednesday, March 15, 2006

Using Dropdowns in Excel

In the NCAA Bracket Selection form, there were dropdowns where you could select your winning team. Learn how to use Data Validation to set up easy dropdowns in your spreadsheets.

Details are at http://www.mrexcel.com/tip123.shtml

Saturday, March 11, 2006

March Madness Competition

I've been using Excel to track a NCAA March Madness competition for several years. This year, I am opening the competition to all MrExcel readers, with some great prizes donated by Holy Macro! Books.

Details on how to enter are at http://www.mrexcel.com/tip122.shtml, but during the course of the tournament, I will also write some articles about the Excel tricks used behind the spreadsheets.

Monday, March 06, 2006

Formula Auditing in Excel

On today's episode of Call for Help, I show how to use Formula Auditing tools to figure out complex worksheets.

You will learn how to mark all formula cells in a worksheet, how to use Formula auditing to find the cells that make up a formula, and how to watch a formula calculate in slow motion.

Complete details are at http://www.mrexcel.com/tip121.shtml

Sunday, March 05, 2006

John Henry of Spreadsheets

This is a ficticious news article about a modern day John Henry, who tried to take on the mechanical spreadsheet: http://www.theonion.com/content/node/45794