Energy Star, a branch of the U.S. Environmental Protection Agency, has free guides with energy saving tips for businesses.
They even have a fancy Excel workbook to help you get started — Energy Star’s Cash Flow Opportunity (CFO) Calculator.
Excel tips and tutorials
Energy Star, a branch of the U.S. Environmental Protection Agency, has free guides with energy saving tips for businesses.
They even have a fancy Excel workbook to help you get started — Energy Star’s Cash Flow Opportunity (CFO) Calculator.
If you’ve created several charts in an Excel workbook, you might want to line them up and make them all the same size before printing.
Instead of doing this manually, you can download and install Jon Peltier’s free Align Chart Dimensions utility (no longer available).
[Update] The free add-in is no longer available. Instead, you can use Excel VBA code that Jon Peltier posted on his site, in the following two articles:
• Arranging Charts in a Grid
• Resizing and Moving Excel Charts with VBA
__________
If you’re having problems with an Excel file, using the built-in repair feature might fix the problem.
For example, doing this repair procedure can help when:
To repair an Excel workbook, follow the steps below:


I hope the repair was successful, and your Excel file is working correctly now. If so, be sure to make backup copies of your work!
If the repair was not successful, you can follow the same steps, but click Extract Data instead.
You might be able to retrieve all of the data, at least, or parts of the data.
And again, remember to make frequent backup copies of your work!
When working on my laptop, especially with a second monitor plugged in, it’s sometimes hard to find the mouse pointer. Too often, this happens in the middle of a meeting, while I’m trying to demonstrate something to a client.
To make the pointer easier to find, you can use one of the built in features:
The next time you lose the pointer, press the Ctrl key, and circles will flash on the screen, showing its location.
If you frequently type the same responses to email questions, you can use an email response template to make things easier.
Next time you need one of the standard responses, open the Standard Paragraphs draft message, copy a paragraph from there, and paste it into your current email.
Some great advice is found in Getting Real, by 37signals. For example, they advise against holding meetings, whenever possible, but…
“For those times when you absolutely must have a meeting (this should be a rare event), stick to these simple rules:
On my own computer, I like to see the full menus in Excel, so I selected that setting:
However, when visiting a client, I sometimes have to use another person’s machine, and I don’t like to change their settings.
If the full menus option has not been turned on, here’s what happens:
Then, to see the full Excel menu, you can:

And here’s a way to avoid waiting to see those full menus.
I like to do this, if I’m on someone else’s computer, and not sure if full menus are enabled:
While typing a document in Microsoft Word, you usually have your hands on the keyboard. To add a line border, you can reach for the mouse, click on the border tool drop-down, then click on a border.
A quicker way to add the line is to type three hyphens (—), then press Enter.
To add a thick border, use three underscores (___) and to add a double border tpe three equal signs (===).

If this technique doesn’t work, choose Tools â–º AutoCorrect Options. On the AutoFormat As You Type tab, add a check mark to Border Lines, in the Apply As You Type section.