# Software Tips & Reviews

• #### Microsoft Excel: Total Revenue From Rows That Match A Criterion

Problem: Say that you want to total the sales made by Ben in the dataset shown in Fig. 572.
By  July 6, 2011

• #### Microsoft Excel: Total Minutes That Exceed An Hour

Problem: You have a series of cells with minutes and seconds from a number of experiments. The times are in the format of 123:45, meaning 123 minutes and 45 seconds. You want to be able to total the time and express it in minutes and seconds,...
By  July 6, 2011

• #### Microsoft Excel: Three Methods of Entering Formulas

Problem: There are three basic ways of entering simple calculations in Excel. Knowing all three ways will allow you to enter formulas faster, according to the situation. Consider the worksheet shown in Fig. 336.
By  July 6, 2011

• #### Microsoft Excel: Temporarily See A Hidden Column Without Unhiding

Problem: You have data hidden in column E, as shown in Fig. 1231. You want to quickly view data in the hidden column without actually unhiding it.
By  July 6, 2011

• #### Microsoft Excel: Sorting With A Formula

Problem: In the previous example, you used the RANK function to find the relative rank order of four writers, as shown in Fig. 377. Now you want to use a formula to produce a sorted list of the writers in high-to-low sequence.
By  July 6, 2011

• #### Microsoft Excel: Round Prices to Next Highest \$5

Need to round numerical values in a non-standard manner in Excel? Read on to learn how.
By  July 6, 2011

• #### Microsoft Excel: Rotate an Autoshape

You can customize Excel AutoShapes in many ways -- rotating them is one option.
By  July 6, 2011

• #### Microsoft Excel: Replace IF Function With Boolean Logic

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.
By  July 6, 2011

• #### Microsoft Excel: Rank A List Without Ties

Problem: The RANK function behaves strangely when there are ties. It is possible to have a list where two people are ranked second and no one is ranked third. In Fig. 383, Dora and Jerry are ranked second with 90 units produced. Next is Harry with...
By  July 6, 2011

• #### Microsoft Excel: Raise a Number to a Fraction to Find the Square or Third Root

Problem: Excel offers a SQRT function to find the square root of a number. What if you need to figure out the third root or the fourth root?
By  July 6, 2011
showing 31-40 of 198 < Previous   |   page: 2   3   4   5   6  ...   |   Next >