Stop! Think! Consider! Develop a plan!
Before you enter any data in your spreadsheets.
Ask yourself questions about your data. Why?
- To save yourself time
- To maintain consistency in data entries
- To prevent GIGO (Garbage in equals Garbage out)
In this video lesson I demonstrate the advantages you will obtain when you:
- Stop – before you start to enter data
- Pre-plan your data list
- Format your data fields / columns BEFORE you make your 1st entry
Here are the steps to follow in this video lesson:
- Set up and Format your Column / Field Headers for each data field.
- For each Column / Field Header, select the columns and format the cells (Ctrl+1) BEFORE you enter any data.
- On the NUMBER tab, choose “Special” to select formats for Social Security #, Phone #, and Zip Code
News! My DVD, “The 50 Best Tips for Excel 2007” is now available to purchase. I invite you to visit my online bookstore for more details.
Find the Free Excel Training Video that you want – Click here to go to my Index of Excel Video Lessons
Link to this post!