It is limited, however, to using a single lookup criterion when trying to find information in a data table.
So instead of finding items by name only, using multiple lookup criteria would allow you, for example, to find those with a certain name that were purchased from a specific supplier, or are a certain color.
To find out more read the step by step tutorial on Lookup Formula with Multiple Criteria in Excel.
By itself, the OFFSET function, like many other Excel functions, can have limited uses. Its value lies in combining it with other functions to create flexible lookup formulas.
To find out all the details about this function, read this short tutorial on the OFFSET function.Related Tutorials
What the INDIRECT function does is allow you to change the start and end points of the formula's range without editing the formula itself.
To find out all the details, read this tutorial on the Excel SUM - INDIRECT Formula.Related Tutorials
The INDIRECT function, as its name suggests, can be used to indirectly reference a cell in a worksheet.
This is done by entering a cell reference as text string into the cell that is being read by the function.
INDIRECT converts this text string into a real cell reference, and then reads and displays the contents of this new cell.
Like many other Excel functions, on its own INDIRECT has limited usefulness. It is most effective when combined with other functions to create more complex formulas.
INDIRECT can be used with a number of functions that accept a cell reference as an argument, such as the SUM Function.
By combining the two, you can create a formula that lets you dynamically adjust the range of the SUM function without having to edit the formula itself.
To find out all the details of using this function, read this tutorial on the Excel INDIRECT Function.Related Tutorials
One recent addition to Excel's list of date functions is the WORKDAY.INTL function.
This function does pretty much the same job as the WORKDAY function except WORKDAY.INTL allows you to choose which days are designated as weekend days rather than automatically assuming them to be Saturday and Sunday.
In addition to excluding weekend days, specific holidays can also be omitted.
To find out all the details, read this tutorial on the Excel WORKDAY.INTL Function.
The mode, like the average and median, is a measure of central tendency and can be used for such things as finding the most frequently picked show on television or the most popular time for people to attend a certain event.To find out the details of using this function, read this tutorial on Google Spreadsheets MODE Function.
The median, another method of finding central tendency in your data, shows you the middle value in a list of numbers.
Finding the median is sometimes preferable to finding the average value in a range. One reason for choosing the median is that it gives you a number that is close to the middle of your data.
The average, on the other hand, can be skewed by unusually large or small values so that it gives you a number close to one end of your data range.
To help find the median value, this tutorial on Google Spreadsheets MEDIAN Function will give you all the necessary details.
There are a number of ways of measuring central tendency or, as it is more commonly called, the average, for a set of values.
Google Spreadsheets has a number of functions that make it easy to find some of the more commonly used average values. One of these is the AVERAGE function which is used to find the arithmetic mean.
The function is handy for finding things like average temperature; average speed; or, if you're a teacher, a student's average mark.
To find out all the details, read this short tutorial on Google Spreadsheets AVERAGE Function .
Excel's WORKDAY function can be used to calculate the start or end date of a project for a given number of working or business days.
The function automatically excludes weekend days from its calculations and it also allows you to specify holidays that you would like to omit.
To find out the details of using this function, read this tutorial on the Excel WORKDAY Function.
Another of Excel's functions that can be used to calculate the number of days between a start and end date is DATEDIF.
Not only can this function help you find the number of days between dates, it can also be used to find the number of months or years as well.
One thing however, DATEDIF is undocumented - which means you won't find it listed with other functions in Excel.
To find out the details of using this function, read this tutorial on the DATEDIF Function.
Related Excel Date Tutorials