Tuesday, October 28, 2008

Quick Chart!

This has always been one of my favorite easy crowd-pleasers.

To make a Quick Chart, simply select your table of date, and press F11. Bamm! A full-featured chart will be inserted in your workbook. Don't like the default chart? Just right-click the resulting chart and choose Change Series Chart Type.

Give it a try, and listen to them go "Oooh and Ahhh..."

Sunday, October 19, 2008

Beware: There May be Links in this Workbook!

If you are working within an Excel document that you may not be familiar with, be cautious before deleting or clearing a cell containing a formula. You can use the keyboard shortcut for revealing another cell that it may be feeding by pressing Ctrl + Shift + ] (Closing Bracket).

If it doesn’t reveal any linked cells, you can safely delete the formula (Cool!).