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…]
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…]
PMP Certification: Controlling Risk
Risk Monitoring and Control is the process of keeping track of the identified risks, monitoring residual risks and identifying new risks, ensuring the execution of risk plans, and evaluating the plans' [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…]
