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:  

How to Protect an Excel 2007 Workbook

Excel 2007 includes a Protect Workbook command that prevents others from making changes to the layout of the worksheets in a workbook. You can assign a password when you protect a workbook so that only [more…]

Word 2007 Shortcuts for Inserting Accents and Symbols

You can use shortcuts to insert accented characters and common symbols into your Word documents. For example, you can type deja vu or get fancy and type [more…]

How to Repeat Row and Column Headings When You Print in Excel 2007

Excel 2007’s Print Titles command enables you to print particular row and column headings on each page of the report. Print titles are important in multipage reports where the columns and rows of related [more…]

How to Show Nonprinting Characters in Word 2007

Seeing nonprinting characters in Word 2007 documents can be a great help when formatting text; creating tables; and editing documents, newsletters, and brochures. Nonprinting characters include spaces, [more…]

Keeping Records with the Outlook 2007 Journal

The Journal in Outlook 2007 can be enormously helpful, whether you choose to use it regularly or rarely. You don't have to limit yourself to recording documents or Outlook items. You can keep track of [more…]

How to Delete a Section Break in Word 2007

In Word 2007, you can use the Delete key to delete a section break. The following steps show how to delete a section break with the Delete key. [more…]

How to Create a Table in Excel 2007

You can create a table in Excel 2007 (a list or database in previous Excel versions) to help you manage and analyze related data. The purpose of an Excel table is not so much to calculate new values but [more…]

Adding Up with Excel 2007's SUM and SUMIF Functions

In Excel 2007, you use the very familiar SUM function to total values in your worksheets. Use the SUMIF function when you want to total only the numbers in a range that meet a criteria you specify. These [more…]

How to Add Data Labels to a Chart in Excel 2007

You can add data labels to an Excel 2007 chart to help identify the values shown in each data point of the data series. Excel provides several options for the placement and formatting of data labels. [more…]

Counting Cells with Excel 2007's COUNT Functions

Excel 2007 offers an assortment of counting functions — including COUNT, COUNTA, COUNTBLANK, and COUNTIF — in the Statistical category that enable you to count the number of cells that contain numeric [more…]

Editing a Chart’s Data Source in Excel 2007

After you create a chart in Excel 2007, you may need to change the range of the source data that is the basis for the chart. The Select Data Source dialog box lets you choose a different source range for [more…]

Taking Shortcuts with Macros in Office 2003

Many people dream of the day they can give orders to a computer by talking to it; the current reality is that you still have to type on a keyboard if you hope to use your computer at all. Because most [more…]

Archiving Outlook Folders

In some cases, Outlook puts email messages, tasks, and appointments older than six months into the Archive folder — a special folder for items that Outlook thinks are stale or not worth keeping. Outlook [more…]

Editing in Word 2007: Track Changes and Review

Writing is a lonely art . . . that is, until editors show up. They'll make revisions by adding to your carefully written work, moving stuff around, and deleting text [more…]

Applying Conditional Formatting in Excel 2007

Excel 2007's conditional formatting lets you change the appearance of a cell based on its value or the value of another cell. You specify certain conditions, and when those conditions are met, Excel applies [more…]

Get to Know the Word 2007 Mail Merge Feature

Mail Merge is a feature in Word 2007 that allows you to take a single document, like a letter, stir in a list of names and data, and combine (merge) everything into a final set of documents, each of which [more…]

How to Use Excel 2007’s Scale to Fit Printing Options

Use the Scale to Fit settings in Excel 2007 if you need to make a worksheet fit to get a few last rows or columns on a single page. You can use the Width, Height, and Scale options in the Scale to Fit [more…]

Comparing Two Excel 2007 Worksheets Side by Side

You can use the View Side by Side command button on the View tab in Excel 2007 to quickly and easily do a side-by-side comparison of any two worksheet windows that you have open. When you click this button [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 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…]

Setting Task Duration in Microsoft Project 2007

Most tasks in a project have a duration, whether it's ten minutes or a year or something in between. Deciding how finely to break down your tasks can affect how efficiently you use Microsoft Project to [more…]

How to Set the Macro Security Level in Excel 2007

Security is an important issue when you're working with Excel 2007 macros. If you open worksheets containing macros from outside sources, these macros could be harmful to your computer. By default, Excel [more…]

How to Create a One-Variable Data Table in Excel 2007

To create a one-variable data table to perform what-if analysis in Excel 2007, you enter a series of input values either across columns of a single row or down the rows of a single column. The formulas [more…]

How to Display All Formulas in an Excel 2007 Worksheet

In Excel 2007, it can be difficult to view your formulas without accidentally editing them. That’s because anytime you are in “edit” mode and the active cell has a formula, the formula might incorporate [more…]

Using Absolute and Relative References in Excel 2007 Formulas

You can use three types of cell references in Excel 2007 formulas: relative, absolute, and mixed. Using the correct type of cell reference ensures that formulas work as expected when you copy them to another [more…]

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

Sign Up for RSS Feeds

Computers & Software
Win $500. Easy. Enter to win now.

Inside Dummies.com

Dummies.com Sweepstakes

Win $500. Easy.