Create a Dynamic Chart with Named Ranges, INDEX and MATCH

This video show you how to create a dynamic range selection and create a dynamic chart based on a start and end date. There are different advanced concepts presented here like dropdowns with a data validation list, named ranges and using INDEX & MATCH functions to perform lookups. To see other videos on these topics see the URLs below:

Data Validation
   • Excel tutorial: Create a drop-down li...  

Named Ranges
   • Identify Named Ranges on an Excel Wor...  

INDEX/MATCH
   • Use the INDEX & MATCH Functions to Pe...  



🔔 SUBSCRIBE to my channel ➜ https://goo.gl/wN3c3p

🏫 Excel Training ➜ https://www.exceltraining101.com/p/tr...

📚 Excel Books & Tech Gear ➜ https://www.amazon.com/shop/dough

⚙️ Tools: Screencasting ➜ https://techsmith.z6rjha.net/5Qe53

⚙️ Tools: Microsoft Office ➜ https://microsoft.msafflnk.net/rKL0G

⚙️ Tools: TubeBuddy ➜ https://www.tubebuddy.com/et101

📝 This description may contain affiliate links and we'll receive a small commission if a purchased is made using the links (but at no additional cost to you). It'll support the channel and so more videos like this can be made. Thanks for your support!

🎁 If you find these videos useful and want to support my channel go to https://www.buymeacoffee.com/dough

#excel
#msexcel
#doughexcel

~-~~-~~~-~~-~
Please watch: "Convert Table in a PDF File to Excel"
   • Convert Table in a PDF File to Excel  
~-~~-~~~-~~-~