Excel Tip #1
To change the name of a worksheet, double-click on its tab. You can also hit the F2 key if your cursor is over the tab. To prevent errors in formulas that reference sheets, use the underscore symbol instead of a space. For example, 980415_stats would be 1998 April 15 statistics.

Excel Tip #2
If you use Excel for an electronic expense report that tracks YTD expenses weekly, you'll have 53 sheets. Rather than name them 01 through 53, name them Jan1, Jan 2...Feb1, Feb2, etc.  It's hard to correlate week 35 with your calendar, but you can correlate the month easily.

Excel Tip #3
You can format individual characters within a cell. Hit the F2 key, then highlight the character to format (using your cursor). Then, use the FORMAT drop down menu to do what you need to do.

Excel Tip #4
You can format cells so they have wordwrap. You can align their contents vertically. You can shrink them to fit. Explore the options in the FORMAT menu--it'll be worth your while if stale is not what you want.

Excel Tip #5
Can't see everything in your spreadsheet? You can hide columns or rows you don't need (FORMAT "Hide"), you can change the zoom (type in what you want, if the drop down sizes don't cut the mustard with you), or use the WINDOW "FreezePanes" command.

Excel Tip #6
To select noncontiguous cells in a worksheet, hold down the CTRL key and click on the cells you want to select.

Excel Tip #7
To enter a zip code or some other string that begins with a zero, simply type the apostrophe key first.

Excel Tip #8
To enter a series of data (e.g., 1, 2, 3...), find the AutoFill handle and drag on it. This handle is a little square located in the cell's lower right hand corner. Your pointer will turn into a crosshair. Excel will recognize noncontiguous series, also (e.g., 2,4,6,8...).

Excel Tip #9
Don't you hate it when your data are in rows and you want them in columns? Highlight the cells that have your data, then right mouse click. Check the "Transpose" box. Voila!

Excel Tip #10
You can align text in just about any orientation you want. You can rotate it, make it run vertically, angle it right, angle it left, you name it. Use the FORMAT Cells command (the drop down menu or the right mouse button) and explore the options Excel gives you..

Excel Tip #11
Excel does some neat things with formatting, as you can see from Tip #10. In addition to static formatting, Excel also does dynamic formatting. What this means is you can, for example, set conditions for a background color to change when your formula returns a value outside a predetermined range. Highlight a cell (for example, one that stores the sum of a column of prices). Select FORMAT, Conditional Formatting. Choose your conditions. Then set the cell to change borders, background colors, fonts, whatever.

Excel Tip #12
A new editing feature helps you handle those formerly painful formulas. When you first enter a cell, you may see that the cell references in your formula are different colors. The colors of the references  correspond to the border colors of the cells to which they point. This may be marginally helpful, but once you set colors up with specific meanings, you'll be golden.

Excel Tip #13
Use the fill handle. Experiment with the location of your pointer on the edges and corners of cells. Click and drag on ranges of cells, and see what happens. You'll find a ton of timesavings, here.

Excel Tip #14
An even better way to make sense of formulas is to use heading names instead of grid references. Say cell A1 is "Interest" and B1 is "Payment." Under the old way, you'd enter this formula in C1: "=A1+A2".  Easy enough, until you start adding in a dozen cells, or so. Under the new system, you'd enter this formula in C1: "=Interest+Payment ". What is cool about this is that if you change the cell headings, the formulas will automatically rename their references. So, if you shorten "Payment" to "PMT" you won't hose your formulas. Is this way cool, or what? Now, when you go to make a mortgage table or some other table where you need to copy the same formula over and over, just move your pointer over the formula cell's lower right corner until you see a +.  Drag down as far as you need, and the formula will self-replicate, keeping references intact.

Excel Tip #15
You can also name ranges. See Excel's help menu about this trick. It's a way of grouping cells together, and it is really slick. For a complex spreadsheet that does "what if" modeling, this is indispensable. But be careful--Excel's interface on this is confusing and it's easy to mess things up. Just remember, though, you can use "natural language" range names, such as "January's rent." We purists don't do this. We never leave an empty space in a formula or use punctuation in a formula name. We would say, "rent_jan"--all lower case, with no spaces, and the more critical word first.

MY BEST EXCEL TIP:

Buy a book on Excel or Microsoft Office. You can find books and tapes by clicking on the software link at the top of this page. This tip is not a cheap sales trick. The reason I suggest you buy a book is I could list at least 1500 Excel tips and the Internet is just is not the format for that. The capabilities of this program go far beyond what those unfamiliar with it could dream of. It is truly a masterpiece of a program.