How would you like to MASTER graphic design by next week?
Click here to find out how
Featured Photoshop templates - professional ready to use designs for your next project
View all templates
Offset Function - Excel tutorial
The OFFSET function in Excel has a wide variety of capabilities. It can be thought of as similar to the VLOOKUP and HLOOKUP functions, but with additional flexibility.
More cool Excel tutorials:
Easy video examples for using conditional formatting in Excel: highlighting the highest and lowest values, finding duplicates, copying and removing it, and much more.
Shading cell color vary with the objective number (Microsoft Excel)
Let you see this tutorial of Micresoft Excel.
AND & OR in Excel
These functions allow you to check multiple criteria that they either all meet the criteria (AND) or at least some of them do (OR).
GROUP and UNGROUP in Excel
Learn how to group and ungroup rows and columns so that you can easily hide or unhide the rows and columns you are interested in.
Sort by More Than Three Columns
Excel's Sort feature is limited in that it enables you to nominate no more than three data fields by which to sort.