API Mini Course – Dynamic Ranges This video explains how to create dynamic named ranges with the INDEX function in Excel to make the new data automatically populate the ranges in the Calculated Data tab. Table of Contents