Рет қаралды 76,737
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...
Named Ranges
• Identify Named Ranges ...
INDEX/MATCH
• Use the INDEX & MATCH ...
🔔 SUBSCRIBE to my channel ➜ goo.gl/wN3c3p
🏫 Excel Training ➜ www.exceltrain...
📚 Excel Books & Tech Gear ➜ www.amazon.com...
⚙️ Tools: Screencasting ➜ techsmith.z6rj...
⚙️ Tools: Microsoft Office ➜ microsoft.msaf...
⚙️ Tools: TubeBuddy ➜ www.tubebuddy....
📝 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 www.buymeacoff...
#excel
#msexcel
#doughexcel
~-~~-~~~-~~-~
Please watch: "Convert Table in a PDF File to Excel"
• Convert Table in a PDF...
~-~~-~~~-~~-~