Computers & Software

View:  
Sorted by:  

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

Understanding Java's Object-Oriented Programming (OOP)

Java is object-oriented. What does that mean? Unlike languages, such as FORTRAN, which focus on giving the computer imperative "Do this/Do that" commands, object-oriented languages focus on data. Of course [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…]

Macromedia Flash: Symbol Types

Flash offers a way to simplify your work, called symbols. A symbol can be any object or combination of objects, animation, or a Web button. When you create a symbol, the objects [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…]

Exploring NFS in UNIX

If your computer is on a LAN, the computer is probably set up to share files with other computers. Quite a few different schemes enable computers to use files on other machines. These schemes are named [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…]

Using the Color Replacement Tool in Photoshop Elements 4

The Color Replacement tool in Photoshop Elements 4 enables you to replace the original color of an image with the foreground color. You can use this tool in a multitude of ways: [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…]

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

Configuring a Wireless Access Point

The physical setup for a wireless access point is pretty simple: You take it out of the box, put it on a shelf or on top of a bookcase near a network jack and a power outlet, plug in the power cable, and [more…]

The Math Symbols on Your PC Keyboard

Clustered around the numeric keypad, like yuppies lurking near Starbucks, are various math-symbol keys. You find these math keys come in handy, especially if you’re dabbling with a spreadsheet or other [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…]

The Hidden Numeric Keypad on Your Laptop

The numeric keypad that exists on standard keyboards still exists on laptops. The key to finding a laptop’s numeric keypad is to use the Num Lock key. Follow these steps to see an example of using the [more…]

Avoiding Mistakes in Java

The only people who never make mistakes are the people who never do anything at all. But careful planning can help you avoid some of the most common Java goofs, such as the following. [more…]

Who Goes There? Understanding Permissions in UNIX

Unlike some operating systems, UNIX was designed from the beginning to be used by more than one person. Like all multiuser systems, UNIX keeps track of who owns what file and who can do what with each [more…]

Working with Interface Windows in Cocoa

Perhaps the most important element of any GUI-based application is the window. In fact, it's so important that those guys from Redmond used it to name their operating system. The windows in an application [more…]

Sign Up for RSS Feeds

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

Inside Dummies.com

Dummies.com Sweepstakes

Win $500. Easy.