These 5 Advanced Dropdown List Methods and Become Excel Expert | Stop Making Basic Drop-Downs!

You learn in this video 5 ways to build dop-downs in excel that update themselves, pull data form anywhere, and change depending on what you select. Microsoft excel for beginners to advance #computergyanguruji #computergyan #excel Practice file here: https://drive.google.com/uc?export=download&id=1ePe-rnnegljIY6gXXspNBsbwiRfOAfyJ Timestamp: 00:00 Intro 00:54 Simple Drop-Down list 01:45 Auto updated drop-down list 03:00 Auto updated drop-down list from another worksheet 04:45 Sort and Ignore blanks in drop-down list 07:06 Depending dropdown list 11:31 Formula listed drop down list 15:09 Pick only Active product/Items in Drop-Down list Our second channel @ComputerGurujiTechnical @GurujiComputerCourse Follow us on Telegram https://t.me/computergurujitechnical instagram https://www.instagram.com/computergurujitechnical/ Twitter https://twitter.com/C_G_Guruji Facebook https://www.facebook.com/Computer-Gyan-Guruji-161495347911109/ MS Excel Videos https://www.youtube.com/watch?v=fJt6sXCJ61E&list=PLHjOos34ty4HWuG--qXHmt_G-TLOXYVKv MS Excel for Beginners https://www.youtube.com/watch?v=JV2nkmUWarI&list=PLHjOos34ty4G2CICgC8l9n_SCMS-wo9yg Excel VBA https://www.youtube.com/playlist?list=PLHjOos34ty4EUTi72_ZYJPeemqCBG9elq Excel Conditional formatting https://www.youtube.com/playlist?list=PLHjOos34ty4G66jP_MndoOcZhQGnMYjoH MS Word https://www.youtube.com/playlist?list=PLHjOos34ty4Grr1fiV9THwqr5GhWXlvTJ MS PowerPoint https://www.youtube.com/playlist?list=PLHjOos34ty4Eq2HdcFcKf779fiRSH68wd MS Access https://www.youtube.com/watch?v=4y7lK6bLWkk&list=PLHjOos34ty4G5rABG_KWz1xZBamyELhiX MS Paint https://www.youtube.com/playlist?list=PLHjOos34ty4EeunznbEMBezHQoDs3iD-3 MSW Logo https://www.youtube.com/playlist?list=PLHjOos34ty4HfeXX-XoPAdxNbR7AlxtPD Notepad & HTML https://www.youtube.com/watch?v=54YiEFXzmRk&list=PLHjOos34ty4GGXiWZ0vg4qtOp22WCO-3W CSS https://www.youtube.com/watch?v=W4GdoQm-7eE&list=PLHjOos34ty4EowLyHfp2HhE-1NFyAsfsE JAVA https://www.youtube.com/playlist?list=PLHjOos34ty4G_T46z7fya0pPgf2gifT3k PHP https://www.youtube.com/playlist?list=PLHjOos34ty4FJpLHeIqp5kb0FmthwR8mh Python https://www.youtube.com/playlist?list=PLHjOos34ty4GYwKO-CFTdJKfVNd50tajF Photoshop https://www.youtube.com/playlist?list=PLHjOos34ty4EpiaieJnNWDf0FPuKxo-M4 Full Tutorial https://www.youtube.com/playlist?list=PLHjOos34ty4GoeB2uYl_7bZUzts1ATywm Computer Education https://www.youtube.com/playlist?list=PLHjOos34ty4HV59zfO4q4g6xc2zZ3A065 Other https://www.youtube.com/playlist?list=PLHjOos34ty4FI-h8Dk1GeKnORnweJRQua Tally https://www.youtube.com/playlist?list=PLHjOos34ty4G5Jqdsi5tzyB4xAaYYQ5MH Internet https://www.youtube.com/playlist?list=PLHjOos34ty4HPW82u849ead6MgjCSXICp Computer GK https://www.youtube.com/playlist?list=PLHjOos34ty4HU58rR3CI6Z8qmLrY-PNAL Google Sheet https://www.youtube.com/playlist?list=PLHjOos34ty4FBWZTm6Go_25hba_d5ztJJ Invoice in Excel https://www.youtube.com/playlist?list=PLHjOos34ty4GCzb1mLmiVrSLxwq1-wS0Z Reasoning https://www.youtube.com/playlist?list=PLHjOos34ty4FxID9_h7qrn_1B1PpGj5WE Airthmatics https://www.youtube.com/playlist?list=PLHjOos34ty4ENjy49vrfA_6l7Cfohd_E3