Ctrl - Shift - Enter - Excel Array Formulas - Dynamic Ranges - INDEX & OFFSET Functions
Offered By: ExcelIsFun via YouTube
Course Description
Overview
Syllabus
min) Dynamic Range: A range that you can use in a formula, chart, PivotTable, etc. that can expand or contract when you add data..
min) INDEX & OFFSET functions can return a range of cells (a type of array) that can be used in formulas, charts & other locations that expect a reference..
min) INDEX function to lookup a range (row or column)..
min) If there is no "Array Operation" (math, comparative, join, function argument) in INDEX formula used to create range, Ctrl + Shift + Enter is not required..
min) Excel Table feature..
min) Reasons you might not want to use Excel Table feature..
min) Defined Names..
min) Keyboards for Defined Names..
min) INDEX to create Defined Name dynamic range formula for text data in column (4 Examples)..
min) INDEX to create Defined Name dynamic range formula for number data in column..
min) INDEX to create Defined Name dynamic range formula for mixed data in column..
min) INDEX to create Defined Name dynamic range formula for rectangular range (3 examples)..
min) VLOOKUP and Data Validation List with Defined Name Dynamic Ranges..
min) Define Name dynamic range formula that can handle an extra space below the data..
min) OFFSET function to create dynamic range formula..
min) Defined Name dynamic range formula For Chart..
min) Dynamic range based on criteria from drop-down list INDEX and OFFSET..
min) INDEX or OFFSET for dynamic range formulas?.
min) Recalculation time in Excel..
min) Add last 5 list with SUM function and Dynamic Range..
min) SUMIF, SUMIFS, COUNTIF and similar functions can handle dynamic ranges created by INDEX function..
Taught by
ExcelIsFun
Related Courses
Introduction to Computational Finance and Financial EconometricsUniversity of Washington via Coursera Excel 2010
Miríadax The Finance of Retirement & Pensions
Stanford Graduate School of Business via NovoEd Einführung in die Wahrscheinlichkeitstheorie
Johannes Gutenberg University Mainz via iversity Introduction to VBA/Excel Programming
Cal Poly Pomona via Open Education by Blackboard