Home Archives for Tips and Time Savers
September 6, 2008 5 Comments

2 reasons to format cells before you enter data in Excel

Stop! Think! Consider! Develop a plan!

Before you enter any data in your spreadsheets.

Ask yourself questions about your data.  Why?

  1. To save yourself time
  2. To maintain consistency in data entries
  3. To prevent GIGO  (Garbage in equals Garbage out)
50 Best Tips for Excel 2007

Excel Tips

In this video lesson I demonstrate the advantages you will obtain when you:

  1. Stop – before you start to enter data
  2. Pre-plan your data list
  3. Format your data fields / columns BEFORE you make your 1st entry

Here are the steps to follow in this video lesson:

  1. Set up and Format your Column / Field Headers for each data field.
  2. For each Column / Field Header, select the columns and format the cells (Ctrl+1) BEFORE you enter any data.
  3. 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!
Filed Under: Excel Data Tables and Lists, Excel Training Tagged: , , , , ,
July 2, 2008 Leave a Comment

Welcome to my MS Excel Blog!

Welcome! This is my new blog  “The Company Rocks Excels” – devoted exclusively to sharing “tips & time-savers” when you use Microsoft Excel.

I train individuals and groups to get the most out of MS Excel for Windows. My clients range from students to Fortune 500 executives. I have trained clients in a variety of industries; in the United States, Canada and Australia.

Most of my clients realize that they use only a fraction of Excel’s powerful features. And… they want to learn how to tap into Excel’s power in order to:

  • Save time
  • Be more productive
  • Gather and analyze data from remote sources
  • Link data sources to produce consolidated reports
  • Analyze data to spot trends and opportunities
  • Present data in a clearly understood, professional manner

On this blog, I share my best tips with you. Each lesson is brief (between 3 and 8 minutes) and  to the point (1 concept per video).

Many of these tips will show you how to transition from your familiar work in MS Excel 2003 to the dramatically different Excel 2007 interface.

The current version, 2007, is quite different – to say the least! Many clients are initially intimidated by the radically different interface. I will help you to transition to the new version – when you are ready.

So, check in often to see the latest tips that I add to the blog. And… please feel free to share your own “tips and time-savers” with our readers.

Ask questions. I will answer them individually as quickly as I can.

Sincerely,

Danny Rocks

Learn how to “Master Excel in Minutes – Not Months!”

Find the video lesson that you want – Index to all Excel Tips

Link to this post!
Filed Under: Excel Training Tagged: , ,
« Previous Page