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...

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:   / myndatreacy