How to Burn a Data DVD in Windows Vista - DVD-R, DVD+R, DVD-DL and more
In Windows Vista, you can burn a data DVD from almost any open window using the Burn button on the toolbar. But what format should you choose when you …
Continue ReadingShowing items from business
How to Make a Multiplication Table in Excel - Example Using Mixed Cell References
One way to make a multiplication table in Excel is to perform each calculation individually, but that method takes a lot of time. Instead, read on to …
Continue ReadingHow to Simplify Entry of Dollar Signs in Formulas in Microsoft Excel - Using the F4 Key and More
When creating an Excel formula, you can use the dollar sign to indicate an absolute or a mixed cell reference. In this tip, Mr. Excel explains a …
Continue ReadingHow to Use Windows DVD Maker to Create Professional Looking DVDs For Your Small Business.
Windows DVD Maker, which ships with Vista Home Premium and Vista Ultimate, guides you through the process of burning a professional-looking DVD that …
Continue ReadingIs Windows Vista's Public Folder Sharing or Private Folder Sharing Best In a Home Office Setting? Read this Vista Tips Article To Find Out!
There are two ways to share data. You can put the data you want to share in Windows Vista’s Public folders, or, you can share personal folders you …
Continue ReadingLearn How to Calculate Sales Commission in Excel
Although a flat-rate sales commission is fairly straightforward to calculate, most modern commission plans include tiers and bonus plans. Mr. Excel …
Continue ReadingLearn How to Use Named Constants to Store Numbers in Microsoft Excel
Is there a particular constant number, such as a sales or commission rate, that you use in Excel formulas on a regular basis? Mr. Excel explains how …
Continue ReadingLearn R1C1 Referencing to Understand Formula Copying in Excel - Have All Your Column Letters Changed to Numbers?
The R1C1 reference style is an alternate way to designate worksheet cells. Read on to find out how to switch between this style and the standard A1 …
Continue ReadingManage Your Network Connections in Vista's Network and Sharing Center
Windows Vista offers a place to centrally manage your home office network connections. You’ll find the link to Network Connections window in the …
Continue ReadingUse Vista's Network & Sharing Center to Set Up, Troubleshoot, and Manage a Network
When a Vista PC is connected to a network, the Network and Sharing Center makes it easy to share data, view a network map, view networked PCs, and …
Continue ReadingHow to Copy a Formula with a Fixed Cell Reference in Excel
If part of an Excel formula references one fixed cell, you’ll need to make some adjustments to that formula before copying and pasting it to …
Continue ReadingLearn How to Copy a Formula in Excel - Shortcut for Copying Excel Formulas with Relative References
Using Microsoft Excel’s capability of handling relative references, you can quickly copy a formula to an entire row or column. This method can …
Continue Reading