Powerpoint Tip - Screen Presentation Tips

While running a PowerPoint slide show, you may want to temporarily turn the screen off so that the audience focuses on what you are saying.

Here's a quick way to do so.

Type B to turn the screen Black.

Type W to turn the screen White.

Planning to Lose Weight in '08? Here's a website for you.

If you plan to lose weight in 2008, I have a website for you.


Studies show that many people who are successful at weight loss keep food diaries. Fitday.com offers dieters a way to record weight, activity, and food consumption. You can make your profile public or private, and best of all, it's free.

How yours truly used technology to save $5,000 a year

One of the guiding principles in my business is I show business professionals ways they can use technology to save time, lower costs or generate revenue.

Here's a real life example, based on an Excel project I was working on this morning.

Project overview: This project involves updating a 290 row, 10 column spreadsheet. Just for grins and giggles, I decided to try updating the sheet manually, and then using Excel formulas to get the job done - just to see how much time and money I would save.

The old (expensive) way: It took 1 hour and 57 minutes to update 63 rows, at a typing speed of 80+ words per minute. At this rate, it would have taken another 7.02 hours to complete this project. (I started at 8:36 am and finished 63 rows at 10:33 am).

The smarter way: Through modifying and combining a couple of Excel formulas, I was able to finish the remaining 157 rows in 13 minutes!

This included the time spent:
  • modifying the formula,
  • copying and pasting it throughout the spreadsheet,
  • creating a formula to test my results, and
  • correcting 4 errors.
    Note: I made the errors while updating the report the slow and expensive way. Without formulas, I wouldn't have been able to test my results and catch errors.

The bottom line: Let's assume this report is generated once a month. By properly using Excel, I will save $4,908 of my time each year. If this is a weekly report, the annual savings are a whopping $21,268.

My point: Properly using technology not only saves time and money, it may also save your reputation (by enabling you to check results).

For additional information, see Learn Excel Formulas from A to Z - Atlanta Excel Training Class.

MS Word Tip - Print Keyboard Shortcuts

While recently teaching a Microsoft Word 2003 class in Atlanta, I happened to mention some of the differences between Office 2003 and 2007.


(For a review of two major differences, check out this article on the probiztechnology.com website).


Class attendees were shocked to find out that the menu interface they just learned was not included in the Office 2007 version. There is good news however: (a) some vendors have already issued software add-ons to convert the Office 2007 menu to Office 2003, and (b) the same keyboard shortcuts that work in Office 2003 also work in Office 2007.


Word® 2000 and 2003 offer a simple, easy way for you to print a list of keyboard shortcuts. Go to the Tools menu, point to Macro, and then click Macros. In the Macros in box, click Word commands. In the Macro name box, click ListCommands. Click Run. In the List Commands dialog box, click Current menu and keyboard settings. On the File menu, click Print.