Microsoft Excel Help: 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 …
Continue ReadingShowing items from home
Microsoft Excel Help: 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, …
Continue ReadingExcel Help: How To Calculate Sales Over Quota, By Mr. Excel
Problem: In the spreadsheet shown in Fig. 253, enter a formula to calculate the excess of sales over quota on a record-by-record basis.
Continue ReadingLearn How to Combine Two Columns in Excel - Join Two Text Columns with Ampersand (&) Operator
If you have data in two columns that you’d like to combine into one single column in Excel, you can do so by using the ampersand (&) to …
Continue ReadingMicrosoft Excel Help: Count, Average, Etc. Without Using A Formula
You don’t need to construct a formula to determine certain measures, like an average, in Excel. Read on to learn a quicker way.
Continue ReadingMicrosoft Excel Help: How To Isolate Everything Before A Dash In A Column By Using Functions
Problem: A vendor provides an Excel worksheet. As shown in Fig. 268, one field has a manufacturer code, a dash, and a part number. The manufacturer …
Continue ReadingMicrosoft Excel: How to Isolate the Middle Portion of a Cell with MID Function
Problem: Your company assigns an account ID in the format of SSS-XX-YYYY as shown in Fig. 266. You need to isolate the XX portion of the account ID in …
Continue ReadingDiscover How To Assign A Formula To A Name With This Excel Tutorial
Problem: You have thousands of identical formulas on 20 worksheets, as shown in Fig. 223. Every time that you want to change the formula, you have to …
Continue ReadingLearn How To Total Without Using A Formula With This Microsoft Excel Tutorial
Need to quickly and easily sum up a total in Excel? With this trick, you don’t even need to enter a formula.
Continue ReadingThe Best Extensions for Firefox 3 - and one for Firefox 2
Firefox 3 supports extensions, which are features you can add to the browser to make your online sessions faster and more productive. This article …
Continue ReadingBetter Pay Per Click Advertising with Google Keywords and Excel
How do you pick keywords and how can you organize the information in a clear and coherent way? Microsoft Excel can help you.
Continue ReadingHow 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 Reading