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)
Excel Tips
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!
Hello, I recently came across your blog and have been reading along. I thought I would leave my first comment. I don’t know what to say except that I have enjoyed reading. Nice blog. I will keep visiting your site often.That is some inspirational stuff. Never knew that opinions could be this varied. Thanks for all the enthusiasm to offer such helpful information here.