While working on a project, such as creating a database, or programming an Excel file, I make notes about the changes I'm making.
Before quitting for the day, I add a few notes on what steps should be taken next. For example, "Create a data entry form" or "Add project codes list".
This makes it easier to get up and running the next time I resume work on the project.
If you use this technique, you won't have to spend several minutes reviewing your work to figure out where you left off -- your "Next Steps" notes will jog your memory. Well, most of the time!
While working in Excel 2003 (or earlier versions), you might open several files, to compare them, or copy and paste from one to another. When you're finished with those files, you can quickly close all of them, and leave Excel open. (Note: This tip also works in Word)
- On the keyboard, press the Shift key.
- In Excel, click on the File menu
- Click on the Close All command
In Excel 2007 you can add the Close All command to the Quick Access Toolbar.
There are instructions for adding a command on the Microsoft web site, or look in Excel 2007's Help
Here are three quick data entry tips for Excel -- use these shortcuts to enter data in a cell:
To enter today's date in a cell: Ctrl+;
To copy the data from the cell above: Ctrl+'
To create a line break within a cell: Alt+Enter