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:  

Understanding Excel 2007's Formula Error Values

If Excel 2007 can’t properly calculate a formula that you enter in a cell, the program displays an error value in the cell as soon as you complete the formula entry. Excel uses several error values, all [more…]

Integrating Access 2003 with Other Microsoft Office Applications

Visual Basic for Applications (VBA) isn't a programming language for Microsoft Access 2003 alone. It's a programming language for all application programs that support Automation. [more…]

How to Set Leader Tabs in Word 2007

There’s only one task that must be done in the Word 2007 Tabs dialog box that you cannot do with the Ruler: Set a leader tab. But what is a leader tab? [more…]

How to Add Titles to Excel 2007 Charts

You can add titles to a chart to help describe its purpose. By default, titles are not added when you create a basic chart, but you can add them later manually. In addition to a main chart title that is [more…]

Formatting a Pivot Table in Excel 2007

Excel 2007 makes formatting a new pivot table you’ve added to a worksheet as quick and easy as formatting any other table of data. The PivotTable Tools Design tab includes special formatting options for [more…]

Managing Range Names in Excel 2007

If you’ve created a number of range names in an Excel 2007 worksheet, you can use the Name Manager to work with these names. The Name Manager provides a list of all names assigned in the current workbook [more…]

How to Add an Excel 2007 Macro to the Quick Access Toolbar

You can assign a macro created in Excel 2007 to a custom button on the Quick Access toolbar and then run it by clicking that button. This provides quicker access to a macro than using the Macro dialog [more…]

How to Apply Fill Colors, Patterns, and Gradients to Cells in Excel 2007

You can add emphasis to selected cells in an Excel 2007 worksheet by changing the fill color or applying a pattern or gradient effect to the cells. If you’re using a black-and-white printer, restrict your [more…]

Rounding Numbers in Excel 2007 with ROUND, ROUNDUP, and ROUNDDOWN

The mathematical functions ROUND, ROUNDUP, and ROUNDDOWN are included in the Math & Trig category in Excel 2007. You'll find these by clicking the Math & Trig button on the Ribbon’s Formulas tab or in [more…]

How to Change Numbering Format in Word 2007 Numbered Lists

Word automatically formats text as a numbered list when you when you type a number and a period followed by a space: Word adds a tab and creates a ¼-inch hanging indent. [more…]

Creating a Sheet of Identical Labels with Word 2007

One of the things Word 2007 does easily and reliably is to print a sheet of identical labels. To do so, just follow these steps:

1. Click the Mailings tab. [more…]

Changing Chart Elements in Excel 2007

The command buttons on the Chart Tools Layout tab in Excel 2007 make it easy to change or customize particular parts of your chart. This customization includes buttons in the following groups on the Layout [more…]

Setting Up E-Mail Reminders in Outlook 2007

In Microsoft Outlook 2007, you can set up a reminder to respond to or follow up on e-mail messages. If you know your way around the Calendar and Tasks windows in Outlook 2007, you know that the Reminder [more…]

How to Build an Array Formula in Excel 2007

Remember that an array formula is a special formula that operates on a range of values. When you build an array formula in a worksheet, you use the Ctrl+Shift+Enter keyboard shortcut to insert an array [more…]

How to Change the Print Margins in Excel 2007

Print margins indicate how much white space Excel 2007 places between the worksheet data and the edge of the page. The Normal margin settings that Excel applies to a new workbook use top and bottom margins [more…]

How to Remove Page Numbers in Word 2007

In Word 2007, you can remove page numbers you’ve inserted. If you used the Page Number menu to insert your page numbers, you can use the Remove Page Numbers command to remove those page numbers. [more…]

Adjusting Page Breaks in Excel 2007

The Page Break Preview feature in Excel 2007 enables you to spot page break problems in an instant as well as fix them, such as when the program wants to split onto different pages information that you [more…]

How to Create a Motion Path for Moving Elements Across a PowerPoint 2007 Slide

You can make elements on your PowerPoint slide behave like cartoon characters by making use of a kind of the PowerPoint animation effect called a motion path. Make your PowerPoint elements travel in a [more…]

Creating PivotCharts in Access 2003

You can display the information from any Access 2003 table, query, or PivotTable as a PivotChart. When you create a PivotChart, you actually create a special view of a form, and the PivotChart is stored [more…]

Word 2007 Mail Merge — Step 1: Creating the Main Document

To use the Word 2007 Mail Merge feature, you begin with a main document. This can be created from a new, blank document, a template, or an existing document. [more…]

Merging and Splitting Cells in Excel 2007

You can merge and center data horizontally or vertically across multiple cells in Excel 2007. You also can unmerge or split a merged cell into its original, individual cells. A common use of merge and [more…]

Splitting Data into Multiple Columns in Excel 2007

Use the Convert Text to Columns Wizard in Excel 2007 when you need to split combined data into separate columns, such as a first name and last name; or city, state, and zip code. This type of combined [more…]

Sorting Excel 2007 Data on Multiple Columns

If your Excel 2007 worksheet has become quite large, using the Sort dialog box to sort on multiple columns can make it easier to find the data you need. The Sort dialog box lets you tell Excel what column [more…]

Inserting Subtotals in an Excel 2007 Worksheet

You can use Excel 2007’s Subtotals feature to subtotal data in a sorted list. To subtotal a list, you first sort the list on the field for which you want the subtotals, and then you designate the field [more…]

How to Modify the Slide Master in PowerPoint 2007

If you don’t like the layout of your PowerPoint slides, call up the PowerPoint Slide Master and do something about it, as shown in these steps: [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!