Where to Put a Page Number in Word 2007
Word 2007 can automatically number your pages and let you place the page number anywhere on the page (top, bottom, or sides) in a variety of formats. If you delete or renumber a page, Word automatically [more…]
CCNA Savvy: Segmenting a Network with a Router
Segmenting a LAN with a router may not be the least expensive way to go, but it does have its benefits. You can expect to find questions on the benefits of segmenting a network with a router on the CCNA [more…]
Setting Finder Preferences in Mac OS X
You can change a number of settings to customize the Finder itself. From the Finder menu, click Finder and choose the Preferences menu item to display the Finder Preferences dialog box that you see in [more…]
How to Install Wireless PC Network Hardware
All manufacturers of wireless adapter cards (for desktops) and wireless PC Cards (for laptops) include their own installation and setup programs — which also create the necessary wireless connection automatically [more…]
How to Run Windows Update in Windows XP
Windows XP lets you set Windows Update to automatically download the updates you need to keep your computer secure. Running Windows Update ensures that your PC has the latest security patches and changes [more…]
Breaking Into the Basics of Network Security
Network security can be as simple as adhering to a set of rules; technology alone can't thwart hack attacks and other security breaches. The following sections include details of just some of these rules [more…]
Examining Investment Value with Excel 2007's PV and FV Functions
The most common financial functions in Excel 2007 — PV (Present Value) and FV (Future Value) — use the same arguments. The key to using these financial functions is to understand the terminology used by [more…]
Adding a Text Box in Word 2007
A text box is a special type of shape designed to place text in your Word 2007 document without regard to the normal page margins. The most common use of text boxes is to add bits of text to drawings. [more…]
Using Drag and Drop in Excel 2007
Drag and drop is a mouse technique that you can use in Office Excel 2007 to pick up a cell selection and drop it into a new place on the worksheet. Although drag and drop is primarily a technique for moving [more…]
How to Protect Your Word 2007 Document
In Word 2007, you can protect your documents from being modified, or changed, by others. The easiest way to protect your document is to use the Protect Document command button. [more…]
Working in Excel 2007’s Page Layout View
Excel 2007’s new Page Layout gives you an instant view of how the printed Excel page will look. You activate this view by clicking the Page Layout View button [more…]
Write Equations in PowerPoint 2007
Use the Equation Editor to place mathematical equations and expressions on PowerPoint slides. The equations you draw become embedded PowerPoint objects so you can edit them without leaving PowerPoint, [more…]
Adding DVR Functionality to Your Mac mini
The basic function of DVRs is to record TV digitally on your Mac mini and to schedule taping for later viewing without commercials and without the hassles of tapes. You can also burn video to DVDs for [more…]
How to Connect Your Modem
Depending on what kind of modem you have, you connect it to your PC differently. An internal dialup modem needs only a connection to your phone line. If you have an external modem, you have to connect [more…]
Change the Layout of Master Slides in PowerPoint 2007
Changing the layout of a PowerPoint master slide entails changing the position and size of text frames and content frames on your PowerPoint slides, as well as removing these frames. PowerPoint content [more…]
Referring to Values or Formulas in Other Cells in Excel 2007 Formulas
Linking formulas are formulas in Excel 2007 that reference a location in the same worksheet, same workbook, or even a different workbook. When you create a linking formula, it brings forward the constant [more…]
Building Protocol State Machines in UML 2
When you want to show the sequence of events an object reacts to — and the resulting behavior — you use the UML notation that creates behavioral state diagrams [more…]
Page Setup Dialog Box Tabs in Word 2007
Use the Page Setup Dialog box to change the margins in a document, to change the paper size, and to change the layout of the document. After calling up the Page Setup Dialog box, you see three tabs: Margins [more…]
Adding a Watermark in Word 2007
Watermarks in Word 2007 documents can be attractive, but they aren’t just about looks: A watermark can be a way of letting the reader know that the document is confidential. Watermarks are most useful [more…]
How to Add the Stocks Gadget to the Windows Vista Sidebar
You can add the Stocks gadget to your Sidebar in Windows Vista to access the latest stock quotes at a glance. No longer do you have to check out separate Web sites for your stock info; instead, up-to-date [more…]
What Is Jakarta Struts?
Jakarta Struts is incredibly useful in helping you create excellent Web applications. When you use Jakarta Struts, your applications should work more effectively and have fewer bugs. Just as important [more…]
Knowing Just Enough about Relational Databases
Building a system in Oracle or some other relational database product does not automatically make it a relational database. Similarly, you can design a perfectly good relational database and implement [more…]
Customizing the Excel 2007 Quick Access Toolbar
The Quick Access toolbar in Microsoft Office Excel 2007 appears above the Ribbon, to the right of the Office button, and includes buttons for commands you use often. By default, the Quick Access toolbar [more…]
Building SQL Queries
SQL is almost English; it's made up largely of English words, put together into strings of words that sound similar to English sentences. In general (fortunately), you don't need to understand any arcane [more…]
Indenting Cell Data in Excel 2007
In Excel 2007, use the Increase Indent and Decrease Indent buttons in the Alignment group on the Home tab to change the indentation of cell contents. This feature is commonly used to enhance the appearance [more…]
