Ctrl - Shift - Enter - Excel Array Formulas - Dynamic Ranges - INDEX & OFFSET Functions

Ctrl - Shift - Enter - Excel Array Formulas - Dynamic Ranges - INDEX & OFFSET Functions

ExcelIsFun via YouTube Direct link

min) Dynamic Range: A range that you can use in a formula, chart, PivotTable, etc. that can expand or contract when you add data.

1 of 21

1 of 21

min) Dynamic Range: A range that you can use in a formula, chart, PivotTable, etc. that can expand or contract when you add data.

Class Central Classrooms beta

YouTube videos curated by Class Central.

Classroom Contents

Ctrl - Shift - Enter - Excel Array Formulas - Dynamic Ranges - INDEX & OFFSET Functions

Automatically move to the next video in the Classroom when playback concludes

  1. 1 min) Dynamic Range: A range that you can use in a formula, chart, PivotTable, etc. that can expand or contract when you add data.
  2. 2 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.
  3. 3 min) INDEX function to lookup a range (row or column).
  4. 4 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.
  5. 5 min) Excel Table feature.
  6. 6 min) Reasons you might not want to use Excel Table feature.
  7. 7 min) Defined Names.
  8. 8 min) Keyboards for Defined Names.
  9. 9 min) INDEX to create Defined Name dynamic range formula for text data in column (4 Examples).
  10. 10 min) INDEX to create Defined Name dynamic range formula for number data in column.
  11. 11 min) INDEX to create Defined Name dynamic range formula for mixed data in column.
  12. 12 min) INDEX to create Defined Name dynamic range formula for rectangular range (3 examples).
  13. 13 min) VLOOKUP and Data Validation List with Defined Name Dynamic Ranges.
  14. 14 min) Define Name dynamic range formula that can handle an extra space below the data.
  15. 15 min) OFFSET function to create dynamic range formula.
  16. 16 min) Defined Name dynamic range formula For Chart.
  17. 17 min) Dynamic range based on criteria from drop-down list INDEX and OFFSET.
  18. 18 min) INDEX or OFFSET for dynamic range formulas?
  19. 19 min) Recalculation time in Excel.
  20. 20 min) Add last 5 list with SUM function and Dynamic Range.
  21. 21 min) SUMIF, SUMIFS, COUNTIF and similar functions can handle dynamic ranges created by INDEX function.

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.