Oct 11

MICROSOFT OFFICE TUTOR: Tired Of Blue? Give Excel 2007 A New Color Scheme

Excel 2007 gives you a lot of new visual options when it comes to building a spreadsheet. You can apply themes to your data and use new shape effects and conditional formatting looks. But what about your Excel application itself? Believe it or not, you don’t need to stick with Microsoft’s traditional blue color scheme.

To change your Excel application’s color scheme:
Continue reading

For more specialized tips on leadership subscribe to our
monthly newsletter now!
Feb 22

MICROSOFT OFFICE TUTOR: Kick your PowerPoint text into high gear with a unique formatting effect

The majority of your slides probably use text, so you have plenty of opportunities to use it to add visual interest to your presentation. WordArt is an option, and you can kick it up a notch with AutoShapes and unique coloring techniques, as shown in Figure A.

To create our effect, we simply selected the AutoShape and WordArt and applied a color fill to both simultaneously. To do so:
Continue reading

For more specialized tips on leadership subscribe to our
monthly newsletter now!
Feb 01

MICROSOFT OFFICE TUTOR: Accelerate Word’s Find And Replace process (2000/2002/2003/2007)

Most savvy Word users already know how to use Word’s Find And Replace dialog box to locate instances of specific text or formatting. But you may not know that there’s something you can do to speed up your Find or Replace command before you even access this dialog box.

To accelerate your Find:
Continue reading

For more specialized tips on leadership subscribe to our
monthly newsletter now!
Jan 04

MICROSOFT OFFICE TUTOR: Let Excel format your PivotTable so you can concentrate on the data (2000/2002/2003/2004/2007)

PivotTables have a job to do; they don’t always have to look pretty. As long as they’re helping you get to the bottom of your data, that’s all you need. However, there are situations when you want your PivotTable to look presentable and appealing, such as when you need to show your supervisor the latest budget figures.
Continue reading

For more specialized tips on leadership subscribe to our
monthly newsletter now!
Oct 19

MICROSOFT OFFICE TUTOR: No blank line needed — instantly insert space between your paragraphs

Instead of pressing [Enter] to insert a blank line of space between your paragraphs, press [Ctrl]0 ([command]0 on the Mac), using the zero key at the top of the regular keyboard (not the one on the number pad).

This keyboard shortcut changes the current paragraph’s formatting to include 12 points of blank space at the beginning of the paragraph. When you press [Enter] to begin a new paragraph, Word carries this formatting over to the new paragraph as well so that 12 points of space appears between the original paragraph and the new one.
Continue reading

For more specialized tips on leadership subscribe to our
monthly newsletter now!