Advertisement
Online Test Banks
Score higher
See Online Test Banks
eLearning
Learning anything is easy
Browse Online Courses
Mobile Apps
Learning on the go
Explore Mobile Apps
Dummies Store
Shop for books and more
Start Shopping

Microsoft Office

View:  
Sorted by:  

Finding Records in Your Access 2003 Tables

When you want to track down a particular record, creating a query is overkill. Fortunately, Access 2003 has a quick way to find one specific piece of data in your project's tables and forms: the Find command [more…]

Modifying a Pivot Table's Summary Function in Excel 2007

By default, Excel 2007 uses the SUM function to create subtotals and grand totals for the numeric field(s) that you assign as the Data Items in a pivot table. Some pivot tables, however, require the use [more…]

Organizing Information with Outlook 2007 Categories

A good collection of information has a lot of value. However, you can't squeeze full value from a list of contacts or tasks if you can't get a quick handle on which items are important and which aren't [more…]

Adding Footnotes and Endnotes in Word 2007

Word 2007 makes it easy to add footnotes and endnotes when you're creating documents in which you want to credit the original sources of information. [more…]

How to Create a Section in Word 2007

In Word 2007, you can easily break up your document. You can use section breaks to break up your document. The section breaks are Next Page, Continuous, Even Page, and Odd Page. [more…]

How to Hide and Unhide Rows and Columns in Excel 2007

You can hide and unhide rows or columns in Excel 2007 when you don’t want part of the worksheet to be visible or when you don’t want certain data (such as salary information) to appear in printed reports [more…]

Using the Access 2007 Input Mask Wizard

An input mask helps to prevent users from inputting invalid data in an Access 2007 form or report. No doubt, you put a lot of time and effort into creating your Access databases. But all that time and [more…]

How to Change a Cell's Number Format in Excel 2007

Excel 2007 provides a variety of number formats that you can apply to the values (numbers) you enter in a worksheet to make the data easier to interpret. These number formats include currency, accounting [more…]

How to Insert Page Numbers in Word 2007

In Word 2007, you can insert page numbers from the Page Numbers gallery. Just follow three simple steps to insert page numbers into your document. [more…]

Word 2007 Mail Merge — Step 2: Assigning Fields

Once you build your main document in Word 2007, you need to assign fields to perform a mail merge. You should now have a good idea of what type and how many fields you need. [more…]

Adding an Excel Chart to a Word 2007 Document

When you insert a chart in Word, Excel is automatically started, and the data that you chart is placed in an Excel workbook. However, that Excel workbook isn?t stored as a separate document. Instead, the [more…]

How to Start PowerPoint 2007

Microsoft provides several ways to start PowerPoint 2007 so you can start creating slides and presentations. You can launch PowerPoint from the Start menu, from a desktop icon, or from the Quick Launch [more…]

Working with Distribution Lists in Outlook

You can create a Distribution List in your Outlook Contacts module that includes the name of more than one person for those times when you send a message to several people simultaneously. You can also [more…]

Protecting Cell Data in Excel 2007

After you finalize an Excel 2007 worksheet by reviewing formulas and proofing text, you should consider protecting the document to guard against any unplanned changes. Each cell in the worksheet can be [more…]

Hiding and Unhiding Excel 2007 Worksheets

In Excel 2007, you can hide any worksheet in a workbook to remove it from view so that others cannot see the data it contains. You can unhide the worksheet at any time. [more…]

Creating and Formatting a Pivot Chart in Excel 2007

After you create a pivot table in Excel 2007, you can create a pivot chart to display its summary values graphically. You also can format a pivot chart to improve its appearance. You can use any of the [more…]

Customizing the Type and Style of an Excel 2007 Chart

When you add a chart to an Excel 2007 workbook, a new Chart Tools Design tab appears in the Ribbon. You can use the command buttons on the Chart Tools Design tab to customize the chart type and style. [more…]

Switching Vertical and Horizontal Data with Excel 2007's TRANSPOSE Function

Excel 2007's TRANSPOSE function enables you to change the orientation of a cell range (or array). You can use this function to transpose a vertical cell range where the data runs down the rows of adjacent [more…]

How to Use Undo and Redo in Word 2007

The Undo and Redo commands in Word 2007 keep you from having to be afraid of deleting your text, or of doing anything else wrong, while you’re working on your documents. What you can do, you can also undo [more…]

Navigating Excel 2007's Worksheet Tabs

Each new workbook you open in Excel 2007 contains three blank worksheets, although you can add many more. You can easily move between the worksheets in an Excel workbook by using the sheet tabs, the Sheet [more…]

How to Sort a Table in Word 2007

You can sort the data in your Word 2007 tables. This is useful if you want to present the data in sequence. For example, you might want to show a table that lists employees in order by the employees’ names [more…]

Scrolling through an Excel 2007 Worksheet

You can use the horizontal scroll bar in Microsoft Office Excel 2007 to scroll left and right in a worksheet and the vertical scroll bar to scroll up and down. The horizontal scroll bar appears at the [more…]

Using Paste Special in Excel 2007

Microsoft Office Excel 2007 normally copies all the information in the range of cells you select when you paste the data. Use Excel's Paste Special command to specify other options, such as pasting only [more…]

How to Draw Straight Lines on PowerPoint 2007 Slides

PowerPoint provides a Line button so you can draw straight lines on your slides. With your PowerPoint slide open, choose a location for your line, then follow these steps: [more…]

How to Edit a Header or Footer in Word 2007

In Word 2007, you can edit a header or a footer by using the same technique — just follow a few simple steps. (Substitute footer for header if editing a footer.) [more…]

Listings:1-2526-5051-7576-100more...
Advertisement

Sign Up for RSS Feeds

Computers & Software
Win an iPad Mini! Enter to win now.

Inside Dummies.com

Dummies.com Sweepstakes

Win an iPad Mini. Enter to win now!