Computers & Software

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

Java Programming: Telling the Computer to Do Something

In Listing 1, below, you get a blast of Java code. Like all novice programmers, you're expected to gawk humbly at the code. But don't be intimidated. When you get the hang of it, programming is pretty [more…]

Crystal Reports 10: Adding a Hyperlink to a Report

One of the most valuable features of Web-based content is the capability to quickly move between pages by using hyperlinks. By clicking a hyperlink associated with a word, a phrase, or an image, you can [more…]

Install a Wired Network

Installing a wired network comprises assembling the proper components. To install a wired network, assemble the cables, network adapter, and router, among other components. Follow these steps to install [more…]

Contrasting Single and Double Quotes in Perl

To summarize the main difference between single and double quotation marks: Single quotation marks do not interpret, and double quotation marks do. That is, if you put something in single quotation marks [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 Edit a Picture in Paint Using Windows Vista

Although the Windows Vista version of Paint is usually used to create simple drawings, you can also use it to edit picture files. In Paint, you can crop your pictures, edit their colors, draw objects on [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…]

Working with the Paths Palette in Photoshop CS2

Working hand-in-hand with the Pen tool in Photoshop CS2 is the Paths palette. You can think of it as a kind of Command and Control Center for your paths. Although it isn't mandatory, opening up your Paths [more…]

Using DOS to Write-Protect and Reformat Disks

You can protect floppy disks in such a way as to prevent yourself or anyone else from modifying or deleting anything on the disk.

When a disk is write-protected, you cannot alter, modify, change, or delete [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…]

How to Use the Scanner and Camera Wizard in Windows XP

The Scanner and Camera Wizard in Windows XP allows you to scan in old photos or other documents to make them digital. Scanning is simple, and once you make files digital, you can e-mail them or share them [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…]

Defining VBA and Its Uses

VBA, which stands for Visual Basic for Applications, is a programming language developed by Microsoft — you know, the company run by the richest man in the world. Excel, along with the other members of [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…]

Placing Charts in Excel

In Excel, making charts is most of the work, but that's not all of it. You still have to decide where to put the charts. First, you need to figure out whether to put a chart on a separate chart sheet. [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…]

Creating Event-Handling Procedures with Visual Basic .NET

Whenever the user takes any action, such as clicking the mouse, pressing a key, passing out on the keyboard, or putting a bullet through the monitor, the action is called an [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 Add a Cooling Pad to Your Laptop

The ideal accessory for any laptop is the laptop cooling pad. This is a device, similar to the one shown here, on which your laptop sits. [more…]

Sign Up for RSS Feeds

Computers & Software

Inside Dummies.com

Dummies.com Sweepstakes

Win $500. Easy.