The Essentials of Working with Charts in Excel 2007
The essentials of creating and working with charts in Excel 2007 will show you everything you need to know to convert your numbers into charts that can help your audience understand the meaning behind [more…]
How to Use Automatic Hyphenation in Word 2007
You can set Word 2007 to automatically hyphenate words at the end of a line. Hyphenating leaves less empty space on each line, which is important when using justified alignment or working with columns. [more…]
How to Record Narration for a PowerPoint Presentation
Adding narration to PowerPoint presentations is easier than it sounds. You can record your voice to narrate your slide show and then link to or embed the sound file to your presentation. This video shows [more…]
The Essentials of Creating a Mail Merge with Word 2007
Merging your mailing lists with documents you want to send via e-mail is easier with essential steps clearly described. The mail merge tool in Word can streamline the process of getting the word out to [more…]
Indenting a Whole Paragraph in Word 2007
Word 2007 can indent every line of a paragraph you type. An indentation is the distance between a margin and the text, not the edge of a page and the text. To have Word indent an entire paragraph, follow [more…]
Securing Your Access 2003 Database as an MDE File
If you make an Access 2003 database for other people — especially people who may be a teeny bit clueless about Access — you may want to lock up your database to prevent other users from making changes [more…]
Getting to Know the Parts of an Excel 2007 Chart
The typical chart (or graph) in Excel 2007 comprises several distinct parts, including the chart area, data series, axes, legend, plot area, gridlines, data markers, and more. The following list summarizes [more…]
How to Create a Pivot Table in Excel 2007
A pivot table is a special type of summary table that’s totally unique to Excel 2007. Pivot tables are great for summarizing values in a table because they do their magic without making you create formulas [more…]
Formatting the X-axis and Y-axis in Excel 2007 Charts
When charting values, Excel 2007 isn’t always careful how it formats the values that appear on the y-axis (or the x-axis when using some chart types, such as the 3-D Column chart or the XY Scatter chart [more…]
Copying Excel 2007 Formatting with Format Painter
Use the Format Painter button on the Home tab of the Excel 2007 Ribbon to save time when copying formatting between cells in your worksheets. You also can use Format Painter to quickly copy the width of [more…]
Using Logical Functions in Excel 2007 Formulas
Excel 2007 uses seven logical functions — AND, FALSE, IF, IFERROR, NOT, OR, and TRUE — which appear on the Logical command button’s drop-down menu on the Formulas tab of the Ribbon. All the logical functions [more…]
How to Change Column Width and Row Height in Excel 2007
In Excel 2007, you can change any column widths or row heights in your worksheets to improve the readability and appearance of data. For example, if your worksheet contains many numbers, you can widen [more…]
The Essentials of Creating and Using Styles in Word 2007
Create styles that you can use to customize your Word 2007 documents by having a look at these essential steps in the customization process. In addition to customizing your documents, you can modify styles [more…]
Creating a Calculated Field with Access 2007
A calculated field takes information from another field in your Microsoft Access 2007 database and performs some arithmetic to come up with new information. In fact, a calculated field can take data from [more…]
Creating an Index of a Word 2007 Document
If you want to create an index for your Word 2007 document, the first task is to mark the words or phrases you want to include in the index. The most common way to do that is to insert an index marker [more…]
How to Create a Table of Contents in Word 2007
Creating and updating a table of contents in Office Word 2007 is easier with the step-by-step instruction in this video. Headings and subheadings are listed in a table of contents, also known as a TOC, [more…]The Essentials of Working with Pivot Tables and Pivot Charts in Excel 2007
Collecting and storing data in Excel spreadsheets is only useful if you can make sense of it. By reviewing the essentials of working with pivot tables and pivot charts in Excel 2007, you can organize and [more…]
Filtering and Sorting an Excel 2007 Pivot Table
You can filter and sort the data in an Excel 2007 pivot table to display a subset of data arranged how you want to view it. Excel automatically adds drop-down filter arrows to the Report Filter field as [more…]
How to Insert a Sound into a PowerPoint Presentation
You can embed a sound file into your PowerPoint presentation, to play when your presentation starts or upon each mouse click. You can download sound clips or save your own sounds with a recorder. This [more…]Outlook 2007 E-Mail Formats: HTML, Plain Text, and Rich Text
Microsoft Outlook 2007 offers three formats for sending e-mail messages: HTML, plain text, and rich text. Here's a look at the pros and cons of the different Outlook e-mail formats, and some easy ways [more…]
Setting Up an Outlook 2007 E-Mail Account from Home
After you sign up with an ISP (Internet Service Provider), you can set up Outlook 2007 to send and receive e-mail from your e-mail account at home. Although any individual Internet e-mail account requires [more…]
How to Move or Copy Excel 2007 Worksheets to Other Workbooks
In Excel 2007, you may need to move or copy a particular worksheet from one workbook to another. You can use the Move or Copy dialog box to simplify the process. To move or copy worksheets between workbooks [more…]
Wrapping Text around a Graphic in Word 2007
When you first insert a picture into a document, Word 2007 places it in line with the text. Sometimes, you want the text to wrap around the picture. When you need to change the text wrapping style, select [more…]
How to Add New Layouts to the PowerPoint 2007 Slide Master
If you don’t like the standard layouts that come with PowerPoint’s built-in Slide Master, you can add a layout and customize it for your PowerPoint presentation. To add your own layout, just follow these [more…]
How to Create Labels with Mail Merge in Word 2007
You can use the Mail Merge feature in Word 2007 to create labels. Word prints on labels just as it prints on any sheet of paper, with each cell the same size as the sticky labels. When the sheet is printed [more…]
