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 dropdown 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  
~~~~~~~~~