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
▶︎
XLOOKUP Complete Tutorial in Excel (+ Hidden Tricks)
▶︎
Top 10 Most Important Intermediate Excel Functions
▶︎
The ULTIMATE Index Match Tutorial (5 Real-World Examples)
▶︎
Excel OFFSET Function - including Common MISTAKES to Avoid!
▶︎
STOP Believing These 9 Excel Myths Right Now
▶︎
Advanced Excel Functions | BYROW vs MAP vs SCAN vs REDUCE | Excel Off The Grid
▶︎
How to use Excel Index Match (the right way)
▶︎
Excel FILTER Function incl. Trick to Rearrange Column Order
▶︎
Index Match Advanced: 3 Most Effective Formulas for Multiple Criteria
▶︎
You Don't Need VLOOKUP & XLOOKUP, You Need This | Excel
▶︎
Top Excel Functions for Data Analysts & What NOT to Waste Time Learning
▶︎
INDEX MATCH Excel Tutorial
▶︎
5 Must-Know Excel Formulas: SUM, INDEX, MATCH, SUMIF, SUMIFS
▶︎
How to Use INDEX MATCH with Multiple Criteria in Excel (3 Easy Steps)
▶︎
How To Use Index Match As An Alternative To Vlookup
▶︎
Excel Index Match Tutorial
▶︎
Next level FILTER Function tricks | Excel Off The Grid
▶︎
Create an Interactive Top N Report in Excel (includes duplicate values) with Filter Function
▶︎
The FILTER Function in Excel + Bonus Tips - COMPREHENSIVE TUTORIAL!
▶︎