How Can Groove 2007 Help Me Collaborate with Team Members?
You may have seen the application in the new 2007 Microsoft Office line up but have you wondered what Groove is all about? Groove 2007 is team …
Continue ReadingShowing items from home
How to Get a 60-Day Free Trial of Microsoft Office Groove 2007
Want to work with Groove 2007 collaboration software but aren’t sure where to get it? This lesson helps you get your own copy of Groove up on …
Continue ReadingDiscover How To Create A CSE Formula To Build A Super Formula With This Excel Tutorial
Problem: Your dataset has a column with quantity sold and another column with unit prices, as shown in Fig. 587. You want one formula to figure out …
Continue ReadingExcel Help: Build A Summary Table To Place Employees In Age Bands, By Mr. Excel
Problem: How can you build a table that will group the employees in age ranges? The COUNTIF criteria cannot handle an argument that combines two …
Continue ReadingExcel 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 ReadingExcel 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 Reading