8 Excel Functions that Return References - Do you know them all?
Most Excel users know OFFSET returns a reference to a range of cells, but there are actually 8 functions that return references. Download the Excel file here: https://www.myonlinetraininghub.com/excel-functions-that-return-references
Chapters:
0:00 OFFSET
5:47 INDEX
10:21 XLOOKUP
11:04 CHOOSE
13:27 SWITCH
14:36 IF
15:38 IFS
16:26 INDIRECT
View my comprehensive courses: https://www.myonlinetraininghub.com/
Connect with me on LinkedIn: https://www.linkedin.com/in/myndatreacy/
Видео 8 Excel Functions that Return References - Do you know them all? канала MyOnlineTrainingHub
Chapters:
0:00 OFFSET
5:47 INDEX
10:21 XLOOKUP
11:04 CHOOSE
13:27 SWITCH
14:36 IF
15:38 IFS
16:26 INDIRECT
View my comprehensive courses: https://www.myonlinetraininghub.com/
Connect with me on LinkedIn: https://www.linkedin.com/in/myndatreacy/
Видео 8 Excel Functions that Return References - Do you know them all? канала MyOnlineTrainingHub
Показать
Комментарии отсутствуют
Информация о видео
Другие видео канала
Amazing Excel FILTER Function + Trick to Rearrange Column OrderExcel OFFSET Function for Dynamic Calculations - Explained in Simple StepsExcel INDEX Function - 5 Secret Features - do you know them all?How to use Excel Index Match (the right way)Return Multiple Match Results in Excel (2 methods)Secrets to Building Excel Dashboards in Under 15 Minutes!Excel Searchable Drop Down List - No VBA and No Formulas!Conditional Formatting Formulas - Mystery Solved with 3 Simple RulesExcel PivotTable Calculated ItemsExciting New Excel LET Function - Comprehensive GuideHow to Use Excel Tables Structured ReferencesExcel Keyboard Shortcuts used by ProsLookup & Return Multiple Values in One Cell in Excel (Easy Formula)INDIRECT Function in Excel - Powerful Range ReferencesLAMBDA and LET for a Robust Single Cell Report - Advanced ExcelHow to easily automate boring Excel tasks with Power Query!Excel Mini Charts - Better than Sparklines!Symbols in Excel Slicers - Fun and Intuitive