Excel INDEX Function - 5 Secret Features - do you know them all?

Most people only know one way to use the INDEX function, but there are 5 tricks that will blow your mind. Download the Excel file here: https://www.myonlinetraininghub.com/5-excel-index-function-secrets Chapters: 0:00 How to use the INDEX Function 1:00 1. Row_Num argument quirk 1:32 2. Returning a Range 3:47 3. Return a Whole Column/Row 5:04 4. Operators 7:14 5. Referencing Non-contiguous Ranges View my comprehensive courses: https://www.myonlinetraininghub.com/ Connect with me on LinkedIn: https://www.linkedin.com/in/myndatreacy/