Spreadsheets August 2012 Archive

Excel CONCATENATE Function© Ted French Names, addresses, and other data are often split between two or more cells in an Excel database file. If you need to combine such data into ... Read More

Excel MIN IF Array Formula© Ted French The MIN function will find the smallest value in a given list of data. The IF function lets you set conditions so that you ... Read More

Sometimes, when you import data you'll find that it contains extra spaces between the words or numbers that were not visible in the original. When this happens Excel's TRIM ... Read More

Excel SUBSTITUTE Function © Ted French Excel's SUBSTITUTE function lets you replace existing text data in one or more worksheet cells with new words, blank spaces, or other text. Uses for ... Read More

When importing data into Excel extra characters can sometimes be brought along with good data, and these extra characters can cause problems if the data is to be used in ... Read More

Wrap Text with Shortcut Keys© Ted French One handy formatting feature in Excel is Wrap Text. Wrap text allows you to control the look of labels and headings in a ... Read More

Sum Cells with SUMPRODUCT© Ted French In addition to counting cells that meet multiple conditions set by the user, SUMPRODUCT can also sum the contents of those cells. Even though ... Read More

Count Cells Between Two Values© Ted French SUMPRODUCT is not as well-known as some of Excel's other conditional functions such as the SUMIF or COUNTIF functions but that doesn't make ... Read More

Yet another of Excel's database functions is DAVERAGE. Like the other functions in this group, DAVERAGE lets you specify one or more criteria which act as data filters ... Read More

Ignore Zeros when Finding the Average© Ted French While the AVERAGE Function is very useful when it comes to finding the arithmetic mean for a range of data, it does ... Read More

Another of Excel's database functions is DSUM. How DSUM differs from the regular SUM function is that DSUM lets you specify one or more criteria which act as data ... Read More

Excel Freeze Panes Tutorial© Ted French It gets a bit frustrating, when you scroll over to column X, Y, or Z in a worksheet only to find that the headings ... Read More