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/

Видео Excel INDEX Function - 5 Secret Features - do you know them all? канала MyOnlineTrainingHub