Microsoft Office

View:  
Sorted by:  

How to Automate Tasks with Macros in Excel 2007

You can use macros in Excel 2007 to save time by automating tasks that you perform frequently. A macro is a series of commands grouped together that you can run whenever you need to perform the task. [more…]

Querying an Access Database Table in Excel 2007

Excel 2007 can import data from an Access 2007 database table into a worksheet, a process known as making an external data query. After importing the data into Excel, you can then use the Filter buttons [more…]

How to Make Odd and Even Headers or Footers in Word 2007

In Word 2007 documents, you can make odd and even headers or footers by following the same simple steps (just substitute footer for header if editing a footer). [more…]

How to Run an Excel 2007 Macro

After you record a macro in Excel 2007, either by using the macro recorder or by creating it in Visual Basic for Applications (VBA), you run the macro to have it carry out the commands and keystrokes that [more…]

Using Word 2007's Thesaurus (and Other Proofing Tools)

One of the nifty Word 2007 features is a built-in thesaurus that can quickly show you synonyms for a word that you type. Using it is easy:

1. Right-click a word that you typed and choose Synonyms from the [more…]

How to Apply Slide Masters in PowerPoint 2007

If you have created multiple Slide Masters for a PowerPoint presentation, you can select which Master to use for each slide in your presentation. To apply a Master to one or more slides, follow these steps [more…]

How to Start a PowerPoint 2007 Slide Show

You’ve put hours into creating a great PowerPoint presentation. PowerPoint is designed to display slides present on a screen. PowerPoint can show your presentation on your computer’s own monitor, a projector [more…]

How to Import Online Data into Excel 2007 with a Web Query

In Excel 2007, you can use Web queries to import data directly from various Web pages that contain financial and other types of statistical data that you need to work with in a worksheet. To create a new [more…]

Filtering a Datasheet in Access 2003

Filtering an Access 2003 datasheet is a way to focus on specific records, rather than all the records in a table. You can filter out records that aren't relevant to what you're trying to do at the moment [more…]

Relegating Your Relics to Archiving in Outlook 2003

It doesn't take long to accumulate more e-mail messages than you can deal with. Some people just delete messages as they read them. Others hold on to old messages for reference purposes. [more…]

How to Add a Header or Footer in Word 2007

In Word 2007, you can add a header or a footer by using the same technique. To add a header or footer, simply follow these steps (substitute footer for [more…]

How to Add Records to an Excel 2007 Table

After you’ve created an Excel 2007 table (using the Table button on the Insert tab), you can choose from several methods for adding records to the table. Before you add records, the range must already [more…]

How to Use Automatic Hyphenation in Word 2007

You can set Word 2007 to automatically hyphenate words at the end of a line. Hyphenating leaves less empty space on each line, which is important when using justified alignment or working with columns. [more…]

How to Build Excel 2007 Formulas with the Insert Function Dialog Box

The Insert Function dialog box in Excel 2007 is designed to simplify the task of using functions in your worksheets. The dialog box not only helps you locate the proper function for the task at hand but [more…]

Saving and Using an Excel 2007 Macro-Enabled Workbook

When you're working with macros in Excel 2007, you save and open workbooks in a new macro-enabled workbook format (.xlsm) that provides added security. When you create a macro, you must use this format [more…]

Saving Time with the Embedded Fax in Outlook 2003

The old way of sending faxes is to print the documents and a cover page, retrieve them from the printer, go to the fax machine, insert the documents, and then send them. The time wasted during this process [more…]

How to Print Formulas in an Excel 2007 Worksheet

A basic printing technique you may need in Excel 2007 is how to print the worksheet formulas instead of printing the calculated results of the formulas. You can check over a printout of the formulas in [more…]

How to Apply a PowerPoint 2007 Template to an Existing Presentation

If you created a PowerPoint 2007 blank presentation or applied a PowerPoint template and don’t like the results, it’s easy to apply a different PowerPoint template. [more…]

Creating a Primary Key in Access 2002

A table's primary key is a special field in your tables. Just about every table you create should have a primary key. Why? [more…]

Viewing Outlook Contacts by Group

Contact lists can get pretty long after awhile; you can easily collect a few thousand contacts in a few years. Sorting a list that long means that if you're looking for stuff starting with the letter [more…]

Adding a Standard Header or Footer in Excel 2007

Headers and footers typically appear on every page of a report. In Excel 2007, a header is printed in the top margin, and a footer is printed in the bottom margin. Headers and footers are often used to [more…]

Finding Commands on the Excel 2007 Ribbon Tabs

The Ribbon in Microsoft Office Excel 2007 contains seven tabs. Contextual tabs also appear when you’re working with a particular object that you select in the worksheet, such as a graphic image, chart, [more…]

Deconstructing Dates in Excel 2007 with DAY, WEEKDAY, MONTH, and YEAR

The DAY, WEEKDAY, MONTH, and YEAR date functions in Excel 2007 all return parts of the date serial number that you specify as their argument. You can access these functions on the Date & Time command button’s [more…]

Freezing Panes in an Excel 2007 Worksheet

The Freeze Panes command in Excel 2007 enables you to freeze portions of a worksheet, typically column and row headings, so that you can view distant parts of the worksheet while the headings remain in [more…]

Choosing the Right Chart Type in Excel 2007

When you display your data visually in Excel 2007, choosing the right type of chart is just as important as deciding to use a chart at all. Different charts display the data in very different ways. Using [more…]

Advertisement

Sign Up for RSS Feeds

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

Inside Dummies.com