Excel Help: Protect Cells With Formulas, By Mr. Excel
Problem: You have to key-in data in a large number of cells in a month end financial statement, as shown in Fig. 608. You don’t want to accidentally …
Continue ReadingShowing items from business
Excel Help: Replace IF Function With Boolean Logic, By Mr. Excel
What if you only need to calculate a formula if the value of a cell satisfies a certain condition? You don’t have to use the IF function.
Continue ReadingHow to Keep Your Office Clean
An unorganized work area can hinder productivity. There are lots of ways to get organized though, and the first thing is to get rid of all of your …
Continue ReadingHow to Order Professional Photo Prints Online
There are hundreds of online photo processing sites, and a few can be accessed directly from the My Pictures folder in Windows XP and the Order Prints …
Continue ReadingHow to Organize Your Home Office - Find the Best Place for Your Printers and Scanners
Printers and scanners are a must-have for today’s savvy computer users. Unfortunately, they are bulky and can be problematic. Printers can stop …
Continue ReadingHow to Successfully Share a Single Windows XP or Vista PC
If you have multiple users on a single PC at home or at work, you know the problems that come along with it. Multiple users on one computer can be …
Continue ReadingHow to Use Excel Functions to Isolate Everything after the Second Dash in a Column
Data in regular formats such as those with multiple dashes can be difficult to segment into parts. Learn how to use Excel formulas to separate data …
Continue ReadingLearn How To Get Total Revenue From Rows That Match A Criterion With This Microsoft Excel Tutorial
Problem: Say that you want to total the sales made by Ben in the dataset shown in Fig. 572.
Continue ReadingLearn How To Match Customers Using VLookup With This Microsoft Excel Tutorial
Problem: You have a list of month-to-date sales by customer. You have a second list with new sales from today, as shown in Fig. 554. How can you add …
Continue ReadingMicrosoft Excel Help: Watch For Duplicates When Using VLookup
Problem: In previous chapters, you’ve used the VLOOKUP function to get sales from a second list into an original list. You need to be aware of how …
Continue ReadingMove your PC Tower to Create More Desk Space
Need some help organizing your home office? Move your PC’s tower off your desk and into a cubby to save desk space. Likewise, move it off the floor so …
Continue ReadingRead Excel Tips Such As How To Count Records That Match A Criteria At BrightHub.com
Learn how to use the COUNTIF function to find out how many items in an Excel list satisfy a certain condition.
Continue Reading