|
msmarieh
|
 |
« on: July 08, 2008, 07:08:52 pm » |
|
There's tons of tips and tricks in Excel!
The afore-mentioned autofill feature is especially useful.
I also adore filters - which allow you to screen rows to see just data that meets your criteria and conditional formatting - which modifies the formatting of your cell when it meets certain criteria (i.e. turning the background red when a date is past due or a budget number is exceeded).
Another extremely useful (and underutilized) feature is GoTo. Not the first screen that comes up which allows you to go to a particular cell, but the link to Special on the GoTo screen that then allows you to select all cells with formulas, all cells with data validation / conditional formatting / etc. Way useful and yet so few people know about it!
Finally, I really love Paste Special which allows you to not only paste links to data but also apply mathematical functions or transpose columns.
Marie
|
|
|
|
|
Logged
|
|
|
|
|
