EXCEL TIPS
50 essential Excel tips
ABSOLUTE TIME-SAVERS
Automatically timestamp Excel worksheets
Better Lists in Excel
03/25/2004
Collection of Excel tips
11/09/2001
COPY FORMATTING FROM ONE CHART TO ANOTHER
Designing a foolproof data entry form in Excel
DRAW BORDERS IN EXCEL WORKSHEETS
Easily create multiple sums in Excel at once
Excel macro makes
consistency a snap
Fastest way
to parse text in Excel
Forcing new lines within
worksheet cell
Future dates
How
to build a function
How to create macro buttons in Excel and Word
How to Perform a Two-Dimensional Lookup
MAKE ROWS AND COLUMNS EQUAL
Maximize Excel's screen real
estate
PLAY THE NAME GAME
Power-formatting Excel spreadsheets
Printing multiple sheets
A quick lesson in nested IF tests
REPEAT ROWS AND COLUMNS IN PRINTOUTS
Simplify tracking down Excel formula errors
Translating
codes into meaningful terms
Two-Dimensional Lookup
Update
external data on a timed basis
VALUE ODD
OR EVEN
Use these
little-known functions to make your formulas more useful than ever. 03/25/2004
Useful Shortcut Keys in Excel 2000
WATCH WITH PRECISION
Created Date: 12/27/2001 Last Reviewed: 12/27/2001 Rev.
Date: 03/25/2004 |