Will be back posting Excel Video Lessons – Soon!

Hello Friends!

The 50 Best Tips

The 50 Best Tips Series

I have been working on an Excel Training Video project for commercial release – hence, my lack of postings.

This project has required focused attention and research. I have almost completed this project – and I will be back posting additional Excel Video Lessons this week. Thank you for your patience, understanding and continuing patronage.

I have now completed all five of the Microsoft Office 2007 Training DVD-ROMs. You can purchase The 50 Best Tips for – Excel, PowerPoint, Word, Outlook and Access 2007 online using my secure shopping cart. Click here to begin shipping.

Sincerely,

Danny Rocks

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.

Trust Your Sources but Verify Your Data’s Accuracy

You may be familiar with the expression, “Trust but Verify!” President Reagan used this phrase when referring to the Soviet Union’s agreement to disarm their missiles. It is also a good approach to follow when you receive Excel data from someone else:

  1. Never open up a data file unless you trust the source.
  2. Never make a decision on the data until you verify the accuracy of the formulas and the structure of the spreadsheet.

In this Excel Video Lesson, I demonstrate how to use the GoTo Special Dialog box to verify the accuracy of your data.

Here are the steps to follow in this lesson:

  1. Choose Edit – GoTo – Special – Formulas to highlight all of the cells containing formulas in the worksheet.
  2. The Keyboard Shortcuts for “GoTo” are Ctrl+G or the F5 Key.
  3. In the “Special” dialog box, you can also choose “Constants.” This may make it easier to spot the cells that are “hard-coded” with a constant value when they should contain a formula.
  4. You can narrow your selection to “Text,” “Logical,” Numeric,” etc. formulas.
  5. Use the Ctrl+~ (Tilde) Shortcut to show the actual formulas in your worksheet.

NEW! Download the Practice File Used in This Excel Training Video

Find the Excel Video Lesson that you want – Index to all Excel Topics

News! My DVD, “The 50 Best Tips for Excel 2007” is now availabe to purchase. I invite you to visit my online bookstore for more details.

Related Videos

My 50th Free Excel Training Video is On-line!

Wow! In just under two months’ time, I have posted 50 free Excel Training Videos!

I hope that you have been enjoying them half as much as I have in creating them. Please drop me an email – danny@thecompanyrocks.com – to give me your feedback. Tell me what you like. Tell me what you don’t like – and why not. And, also tell me what you would like to see more of (or less of, for that matter!)

I will answer your questions as quickly as possible. Either privately or in a public Excel Video training lesson (no names mentioned!)

To celebrate, this milestone, I have added a short ( 3 1/2 minute) video introduction to The Company Rocks Excels. I explain my training process and teaching style. I also – “hint, hint” – demonstrate how you will benefit when you engage me to train you and/or your staff!

I love training people to master the “Tips & Time-savers” in Excel! I would love to train you!

Please call me @ (310) 215-0678 or email me – danny@thecompanyrocks.com – so that I can start to design the best Excel training program to meet your present needs!

Thank you for your support.

Danny

News! My DVD, “The 50 Best Tips for Excel 2007” is now availabe to purchase. I invite you to visit my online bookstore for more details.