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:
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:
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:
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.
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.