Channel: Excel Campus - Jon

Category: Education

Tags: excelstatic list using auto-fillcreate number list in exceldynamic list using dynamic array formulasnumbered listexcel campusexcel numberslist using a formula in an excel tableexcel quick tips videolist numbers in exceldynamic list using a formulastatic and dynamic lists

Description: In this video, you can learn 4 different techniques for creating a list of numbers in Excel. These include both static and dynamic lists that change when items are added or deleted from the list. If you’d like to read the accompanying blog post on my website, you can access it here: excelcampus.com/tips/numbered-lists 0:00 1. Create a Static List Using Auto-Fill 1:20 2. Create a Dynamic List Using a Formula 4:05 3. Create a Dynamic List Using a Formula in an Excel Table 6:05 4. Create a Dynamic List Using Dynamic Array Formulas Related Videos: Dynamic Array Formulas and Spill Ranges in Excel Tables: youtube.com/watch?v=irR9bUKzTw8 Excel Tables Tutorial: Beginners Guide for Windows & Mac: youtube.com/watch?v=fJnJTff4Na8&t=124s Prevent Excel from Slowing or Freezing when Deleting Rows: youtube.com/watch?v=o7s_Rx5P8zs #MsExcel #ExcelCampus