Watch more How to Use Microsoft Excel videos: howcast.com/videos/487216-Whats-the-Offset-Function-Microsoft-Excel

Hi, my name is Shir and I'm the founder and CEO of shirconsulting.com where we focus on converting the existing data from your business into massive savings and extraordinary profits. Today we're going to learn the basics of Excel. Let's get started.

SO now we're going to talk about the OFFSET Function which is essentially a way of referencing a CELL but move to the side a specific number of ROWS and COLUMNS. So here's what I mean. Let's take a basic way of referencing a CELL using the "=" and then we're going to use the mouse to click on CELL C7 and hit ENTER. That gives me the contents of CELL C7. So if I change this to Jackson, it also changes over here. If we use the OFFSET Function, we type in "=" OFFSET and we do a reference starting with this spot which we know of, comma for the next argument and see how many ROWS do you want to move, either plus or minus, comma, how many COLUMNS do you want to move, either plus or minus and then we'll close parentheses ")" there.

So what we'll do is we'll add in the number of ROWS - so since we're starting from this point - G6 - I want to go down one ROW so I'll put 1 over here and I want to move to the left 1,2,3,4 so I'm going to do -4 and that brings me the same contents as this reference. The difference now is if I insert a new COLUMN here in between these references, the original reference does not change. But because the OFFSET Function is in use it still starts from - let's take a look - the same spot but there's now a new COLUMN in between so it still goes to the left 1,2,3,4 spots which is now a different CELL. And those are some of the basic features of the OFFSET Function in EXCEL.

• What's the Offset Function | Microsoft Excel ( Download)
• Excel OFFSET Function for Dynamic Calculations - Explained in Simple Steps ( Download)
• Excel Tutorial: Using the OFFSET Function in Excel ( Download)
• OFFSET Function in Excel: How to Use Offset Function in Excel ( Download)
• OFFSET Formula in Excel ( Download)
• Excel OFFSET Function - including Common MISTAKES to Avoid! ( Download)
• How to Use Offset Function in Excel ( Download)
• How to use the Offset Function Properly | Microsoft Excel series ( Download)
• OFFSET Function in Microsoft Excel ( Download)
• Microsoft Excel Offset Function for Dynamic Calculations ( Download)
• OFFSET Formula in Excel | How to use offset function in Excel#excel #msexcel #exceltricks ( Download)
• Use Excel's OFFSET Function to SUM Through To a Specified Year ( Download)
• Excel Offset Function (For Static & Dynamic Calculations) ( Download)
• I don't use OFFSET Anymore! I Use Another Function Instead. ( Download)
• OFFSET Function Dynamic Range inside COUNTIFS Function - Excel Magic Trick 1573 ( Download)