Excel OFFSET Function - including Common MISTAKES to Avoid!

The OFFSET function is the magic ingredient for writing formulas that automatically adjust as your data grows or summarise data based on criteria you set on the fly. Download the Excel file here: https://www.myonlinetraininghub.com/excel-offset-function-explained View my comprehensive courses: https://www.myonlinetraininghub.com/ Connect with me on LinkedIn: https://www.linkedin.com/in/myndatreacy/ 0:00 How to use the OFFSET function 0:49 OFFSET Function Syntax 1:30 Basic OFFSET Examples 4:46 Dynamic SUM with OFFSET 6:09 Dynamic ranges with OFFSET 7:49 Dynamic named ranges with OFFSET for charts 11:35 Common Mistakes and How to Fix Them