Computers & Software

Sorted by:  

Merging and Splitting Cells in Excel 2007

You can merge and center data horizontally or vertically across multiple cells in Excel 2007. You also can unmerge or split a merged cell into its original, individual cells. A common use of merge and [more…]

How to Find an Available Wireless Network in Windows Vista

To use an available wireless network, your PC must have a wireless networking card. The first step is to find an available wireless network. The second step is to connect to the wireless network. [more…]

Splitting Data into Multiple Columns in Excel 2007

Use the Convert Text to Columns Wizard in Excel 2007 when you need to split combined data into separate columns, such as a first name and last name; or city, state, and zip code. This type of combined [more…]

Sorting Excel 2007 Data on Multiple Columns

If your Excel 2007 worksheet has become quite large, using the Sort dialog box to sort on multiple columns can make it easier to find the data you need. The Sort dialog box lets you tell Excel what column [more…]

Moving Objects in Active Directory

Moving objects around in Active Directory may involve moving objects from one location to another within a domain, or you might have to move objects from one domain to another. You need to know the details [more…]

Inserting Subtotals in an Excel 2007 Worksheet

You can use Excel 2007’s Subtotals feature to subtotal data in a sorted list. To subtotal a list, you first sort the list on the field for which you want the subtotals, and then you designate the field [more…]

How to Modify the Slide Master in PowerPoint 2007

If you don’t like the layout of your PowerPoint slides, call up the PowerPoint Slide Master and do something about it, as shown in these steps: [more…]

Lighting Indoor Spaces in Google SketchUp

Adding shadows to interior views of Google SketchUp drawings presents an interesting problem: There are no lights besides the sun in SketchUp, so how are you supposed to make anything that looks halfway [more…]

Finding Records in Your Access 2003 Tables

When you want to track down a particular record, creating a query is overkill. Fortunately, Access 2003 has a quick way to find one specific piece of data in your project's tables and forms: the Find command [more…]

Modifying a Pivot Table's Summary Function in Excel 2007

By default, Excel 2007 uses the SUM function to create subtotals and grand totals for the numeric field(s) that you assign as the Data Items in a pivot table. Some pivot tables, however, require the use [more…]

Organizing Information with Outlook 2007 Categories

A good collection of information has a lot of value. However, you can't squeeze full value from a list of contacts or tasks if you can't get a quick handle on which items are important and which aren't [more…]

Setting Up Norton Parental Control

Child safety is a big issue anywhere, but the online world presents special challenges in the form of virtual bogeymen, pitfalls, and the kind of Web sites that can fluster or enrage a mature adult. Parental [more…]

Fixing Things with Disk Utility in Mac OS X

An important application in your maintenance toolbox is the Disk Utility, which is located in the Utilities folder within your Applications folder. When you first run this program, it looks something like [more…]

Adding Footnotes and Endnotes in Word 2007

Word 2007 makes it easy to add footnotes and endnotes when you're creating documents in which you want to credit the original sources of information. [more…]

Adding a Sound to a Flash CS3 Button

For fun, you can add a sound to a button that you create in Flash CS3. Usually, sounds are added to the Over or Down frame — or both, if you want.

Before you can add a sound to a button, you need a sound [more…]

Working with Aliases in Mac OS X

An alias is a tiny file that automatically opens the file that it represents. Although an alias is technically an icon, it's actually an icon that opens another icon automatically. You can put aliases [more…]

How to Create a Section in Word 2007

In Word 2007, you can easily break up your document. You can use section breaks to break up your document. The section breaks are Next Page, Continuous, Even Page, and Odd Page. [more…]

How to Hide and Unhide Rows and Columns in Excel 2007

You can hide and unhide rows or columns in Excel 2007 when you don’t want part of the worksheet to be visible or when you don’t want certain data (such as salary information) to appear in printed reports [more…]

Using Apple System Profiler in Mac OS X

Need hard information about your hardware? You may need to determine precisely what hardware is installed in your Mac for the following reasons: [more…]

Using the Access 2007 Input Mask Wizard

An input mask helps to prevent users from inputting invalid data in an Access 2007 form or report. No doubt, you put a lot of time and effort into creating your Access databases. But all that time and [more…]

How to Change a Cell's Number Format in Excel 2007

Excel 2007 provides a variety of number formats that you can apply to the values (numbers) you enter in a worksheet to make the data easier to interpret. These number formats include currency, accounting [more…]

How to Insert Page Numbers in Word 2007

In Word 2007, you can insert page numbers from the Page Numbers gallery. Just follow three simple steps to insert page numbers into your document. [more…]

Word 2007 Mail Merge — Step 2: Assigning Fields

Once you build your main document in Word 2007, you need to assign fields to perform a mail merge. You should now have a good idea of what type and how many fields you need. [more…]

Adding an Excel Chart to a Word 2007 Document

When you insert a chart in Word, Excel is automatically started, and the data that you chart is placed in an Excel workbook. However, that Excel workbook isn?t stored as a separate document. Instead, the [more…]

How to Start PowerPoint 2007

Microsoft provides several ways to start PowerPoint 2007 so you can start creating slides and presentations. You can launch PowerPoint from the Start menu, from a desktop icon, or from the Quick Launch [more…]

Sign Up for RSS Feeds

Computers & Software