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 ReadingWhen 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 ReadingWindows DVD Maker, which ships with Vista Home Premium and Vista Ultimate, guides you through the process of burning a professional-looking DVD that …
Continue ReadingThere 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 ReadingAlthough a flat-rate sales commission is fairly straightforward to calculate, most modern commission plans include tiers and bonus plans. Mr. Excel …
Continue ReadingIs 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 ReadingThe 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 ReadingWindows Vista offers a place to centrally manage your home office network connections. You’ll find the link to Network Connections window in the …
Continue ReadingWhen 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 ReadingIf 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 ReadingUsing Microsoft Excel’s capability of handling relative references, you can quickly copy a formula to an entire row or column. This method can …
Continue ReadingWindows Mail ships with Vista, but Windows Live Mail is a web-based alternative and offers lots more features. Windows Live Mail is a Microsoft Live …
Continue Reading