Microsoft Office

View:  
Sorted by:  

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

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

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

How to Draw a Table Line by Line in Word 2007

The Draw Table command lets you draw complicated tables in your Word 2007 documents by using a simple set of drawing tools. This command is ideal for creating tables that aren’t a simple grid of rows and [more…]

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

Create Greeting Cards in Microsoft Word 2003

If you want to create something in Word that will just dazzle someone, try your hand at customized greeting cards. To set up Word to create a greeting card from a single sheet of standard letter-size paper [more…]

Using Built-in Add-In Programs in Excel 2007

Add-in programs are small modules that extend the power of Excel 2007 by giving you access to a wide array of features and calculating functions not otherwise offered in the application. There are three [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…]

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 Customize Bullets in Word 2007 Bulleted Lists

The quickest way to create a custom bulleted list in Word 2007 is to change the formatting of an existing (or automatically created) bulleted list. Word automatically formats text as a bulleted list when [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…]

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 Print Envelopes in Word 2007

Word 2007 includes a special Envelopes command that can quickly and professionally print a mailing address (and your return address) on an envelope. You can send the envelope directly to your printer, [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…]

Splitting an Excel 2007 Worksheet Window

In Excel 2007, you can split the worksheet window into separate panes and scroll the worksheet in each pane so that you can easily compare data from two separate worksheet locations. You can make the panes [more…]

Looking Up Data in Excel 2007 with HLOOKUP and VLOOKUP

The most popular of the lookup functions in Excel 2007 are HLOOKUP (for Horizontal Lookup) and VLOOKUP (for Vertical Lookup). These functions are located in the Lookup & Reference category on the Formulas [more…]

Creating a Table of Contents in Word 2007

Word 2007 assembles a table of contents (TOC) for you by listing the headings (each with the page number) you designate throughout your document beforehand. Word takes care of counting pages, and even [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…]

How to Draw an Action Button Hyperlink on Your PowerPoint 2007 Slide

PowerPoint’s Shape gallery offers 11 action buttons (12 if you count the Custom button). As soon as you draw an action button shape, a dialog box appears to help you direct PowerPoint where to go when [more…]

How to Remove a Word 2007 Document Header and Footer from the Entire Document

In a Word 2007 document, you can remove a header or a footer. To remove a header, choose Header→Remove Header. To remove a footer, choose Footer→Remove Footer. [more…]

How to Make a Hanging Indent in a Word 2007 Paragraph

Word 2007 can hang the indentation of every paragraph you type. A hanging indent is an indentation where the first line sticks out to the left and the rest of the paragraph is indented. To have Word hang [more…]

How to Install the Excel 2007 Analysis ToolPak

The Analysis ToolPak is an Excel 2007 add-in program that adds extra financial, statistical, and engineering functions to Excel's pool of built-in functions. The tools included in the Analysis ToolPak [more…]

Using Logical Excel 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 Excel Formulas tab of the Ribbon. All the logical [more…]

How to Set up a Trigger to Start a PowerPoint Animation

To set up a triggered animation in a PowerPoint presentation, set up the animation you want to play when the trigger is clicked and decide which element on your PowerPoint slide you will click to trigger [more…]

How to Use Multilevel Lists in Word 2007

Not all lists are simple one-level lists. Sometimes you want multiple levels with different formats showing different levels of detail. Word 2007 can manage lists with up to nine levels; here’s one with [more…]

Sign Up for RSS Feeds

Computers & Software

Inside Dummies.com