Ted's Spreadsheets Blog July 2008 Archive

It gets a bit frustrating, when working with large spreadsheets, if every time you go to read the data in a specific cell the headings at the top of the ... Read More

After discussing Excel’s VLOOKUP function, I thought I should follow that up with the HLOOKUP function that can also be used to find specific data in your spreadsheets. Both ... Read More

If you store large amount in spreadsheets, Excel’s VLOOKUP is a handy function to know. It allows you to easily locate specific data in a database or ... Read More

On occasion there is a need to transfer a row of data into a column. This might be done when re-vamping a spreadsheet or when creating a summary ... Read More

There are a number of functions in Excel that will count cells for you rather than add or multiply the data in those cells. One of these COUNT functions that ... Read More

The COUNTBLANK function, one of Excel's “Count Functions”, can be used to total the number of cells in a selected range that meet specific criteria. All of ... Read More

Creating formulas in Microsoft Excel is not difficult. It's really just a matter of combining the cell references of your data with the correct mathematical operator. Of course, knowing ... Read More

Excel 2007 AVERAGE Function© Ted French The AVERAGE function, one of Excel's statistical functions, is a handy function to know and one that I use frequently when calculating student marks and ... Read More

Excel's MIN function works much the same as the recently mention MAX function. What the MIN function does is find the smallest value in a given list of data. Example ... Read More

The Max function, one of Excel’s statistical functions, is a very useful function that has many applications. What the MAX function does is find the largest value in a ... Read More

When you find yourself repeatedly performing the same actions or tasks in a spreadsheet, it might be time for you to create a macro. A macro is a recording of ... Read More

The PMT function, one of Excel's financial functions, can be used to calculate loan payments or to calculate how much an investment will be worth after a certain amount ... Read More

If you ever need to keep track of a large quantity of information one option is to create a database file in a spreadsheet program like Excel. Whether it’s ... Read More