Microsoft Office

View:  
Sorted by:  

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…]

How to Add a Background Image to an Excel 2007 Worksheet

You can add a graphic image to the background of an Excel 2007 worksheet. The background image (sometimes called a watermark) should be very light in color or use a greatly reduced opacity in order for [more…]

Pushing Your Access 2003 Data onto the Web

Now that Access 2003 contains all your coolest information, why not share your stuff with others in your company — or even publish it for the world? Whether you're building a commercial site geared toward [more…]

How to Adjust Paragraph Margins in Word 2007

You can change the left and right margins around paragraphs in your Word 2007 documents. The secret is found in the Page Layout tab's Paragraph group: the Left control sets the indentation for the paragraph's [more…]

Word 2007 Mail Merge — Step 4: Inserting Fields into the Main Document

Once you have built the necessary records for your Word 2007 mail merge, you need to place the fields into the main document, by replacing the ALL CAPS placeholders you inserted earlier. [more…]

How to Add Notes to a PowerPoint 2007 Slide

PowerPoint lets you create speaker notes to help you through your presentation. You can write a complete script for your PowerPoint presentation or just jot down a few key points to refresh your memory [more…]

Document Recovery in Excel 2007

Excel 2007 offers a document recovery feature that can help you if a computer crashes due to a power failure or some sort of operating system freeze or shutdown. Excel's AutoRecover feature saves your [more…]

Filtering an Excel 2007 Pivot Chart

Just as you can filter an Excel 2007 pivot table to display a subset of data, you also can use the PivotChart Filter pane to filter a pivot chart so that it shows just the information you want it to show [more…]

How to Insert Symbols and Special Characters in Excel 2007

Excel 2007 makes it easy to enter symbols, such as foreign currency indicators, as well as special characters, like trademark and copyright symbols, into Excel's cells. These symbols are available in the [more…]

Figuring Out the Excel 2007 Formula Bar

The Formula bar in Microsoft Office Excel 2007 displays the cell address and the contents of the current cell. Use the Formula bar to enter or edit formulas and cell entries and assign names to cells. [more…]

Calculating Loan Payments with Excel 2007's PMT Function

Excel 2007's PMT function calculates the periodic payment for an annuity, assuming a stream of equal payments and a constant rate of interest. The PMT function uses the following syntax: [more…]

Working with the Comma Style in Excel 2007

The Comma Style format (also known as the thousands separator) in Excel 2007 often accompanies the Accounting number format. Like the Accounting format, the Comma format inserts commas in larger numbers [more…]

Using Functions in Excel 2007 Formulas

In Excel 2007, functions are like built-in formulas that perform simple to complex tasks. For example, the SUM function sums up numbers, the COUNT function counts, and the AVERAGE function calculates an [more…]

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

To create a two-variable data table to perform what-if analysis in Excel 2007, you enter two ranges of possible input values for the same formula: a range of values for the Row Input Cell in the Data Table [more…]

Fixing Broken Formula Links in Excel 2007

Formulas in Excel 2007 can reference external workbooks. Links become broken when external workbooks are moved, deleted, or renamed. When a workbook that contains an external reference is opened but cannot [more…]

Adding and Removing Tables in Microsoft Access 2007

The simple interface in Microsoft Access 2007 enables you to add or delete database tables — after all, even seasoned experts forget things now and then. [more…]

Getting to Know Views in Outlook 2007

In Outlook 2007, every Outlook module has its own selection of views. Each type of view is organized to make a particular feature of your information obvious at first glance. You can change the way that [more…]

Naming a Cell or Range in Excel 2007

Assign a descriptive name to a cell or range in Excel 2007 to help make formulas in your worksheets much easier to understand and maintain. Range names make it easier for you to remember the purpose of [more…]

Sharing ACT! 2005 and Outlook Address Books

A common misconception among potential ACT! users is that they don't need ACT! because they're using Outlook. You might snicker at that suggestion if you realize that Outlook is a PIM [more…]

Creating a Visual Report in Microsoft Project 2007

If you just love the capabilities that PivotTable reports in Excel and Visio offer, you'll be glad to know that the same capability has come to Microsoft Project 2007 in the form of Visual Reports. Pivot [more…]

Paragraph Alignment and Justification in Word 2007

In Word 2007, paragraph alignment refers to how the left and right edges of a paragraph align on a page. You can left-align, center, right-align, and justify a paragraph. The paragraph formatting commands [more…]

Powers and Roots in Excel 2007: The POWER and SQRT Functions

In Excel 2007, you use the POWER function to raise a number to a certain power, and SQRT to find the square root of a number. These functions are located with the Math & Trig functions on the Ribbon’s [more…]

Planning Ahead with Excel 2007's TODAY, DATE, and DATEVALUE Functions

Excel 2007 contains a number of built-in date functions that you can use in your worksheets. Three common date functions are TODAY, DATE, and DATEVALUE, and they can come in very handy when you're trying [more…]

Shortcuts for Moving the Cell Cursor in Excel 2007

Microsoft Office Excel 2007 offers a variety of keyboard shortcuts for selecting a new cell. When you use one of these keystrokes, the program automatically scrolls a new part of the worksheet into view [more…]

How to Add Text or Pictures to AutoShapes in Word 2007

You can use certain AutoShapes as frames to enclose a picture or even some text, which can spruce up a boring Word 2007 document. When creating your AutoShape, choose a shape that can be used as a frame [more…]

Sign Up for RSS Feeds

Computers & Software

Inside Dummies.com

Dummies.com Sweepstakes

Win $500. Easy.