Subscribe
Tutorial search

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.
Category: Excel > Functions - Difficulty:


More cool Excel tutorials:



How to Merge Columns in Excel
How to Merge Columns in Excel
You're probably used to merging cells , but did you know that merging or concatenating columns for combining data is just as easy and useful.
Difficulty:
And Function
And Function
Learn to use the And Function in Excel. The And Function is used to display True or False depending on certain conditions.
Difficulty:
How To Use The Format Painter
How To Use The Format Painter
This video tutorial shows how to use the formatting painter in Excel.
Difficulty:
Removing #DIV/0! errors from your spreadsheets
Removing #DIV/0! errors from your spreadsheets
Shows how to remove #DIV/0! errors from your spreadsheets permanently using the AssumeIT macros
Difficulty:
How to Create a Simple Macro in Excel
How to Create a Simple Macro in Excel
Learn to create a simple macro in Excel using step by step instructions with screenshots.
Difficulty: