This excel video tutorial provides a basic introduction into the index and match function with drop down lists which is an effective combination for retrieving data from a database.
Excel Tutorial For Beginners: https://www.youtube.com/watch?v=nK-uNYuvcag
Top 30 Excel Tips & Shortcuts:
https://www.youtube.com/watch?v=UMad9_-4rOU
________________________________________
How To Look Up Customer Data In Excel:
https://www.youtube.com/watch?v=HDda6ny40ZM
Excel Vlookup Function:
https://www.youtube.com/watch?v=zV0ah1DPNJ8
How To Create a Data Entry Form In Excel:
https://www.youtube.com/watch?v=_tZLGBgQCYo
Multiple Dependent Drop Down Lists:
https://www.youtube.com/watch?v=NhtsVTeGywc
How To Show & Hide Formulas:
https://www.youtube.com/watch?v=U2P2jgbseK8
______________________________________
Relative & Absolute Cell References:
https://www.youtube.com/watch?v=Yx52CYvR5ao
Lock Cells and Protect Sheets In Excel:
https://www.youtube.com/watch?v=wrOE8fheMR0
Excel Interactive Checklist:
https://www.youtube.com/watch?v=2W06Rmp-UbY
Excel Pivot Tables:
https://www.youtube.com/watch?v=WoR2RhT7AF0
______________________________________
YouTube Channel Growth Accelerator:
https://www.patreon.com/YouTubeChannelGrowthAccelerator
Final Exams and Video Playlists:
https://www.video-tutor.net/
Full-Length Math & Science Videos:
https://www.patreon.com/mathsciencetutor/collections