Learn Excel online https://www.udemy.com/excel-2010-superhero-course/?couponCode=Excel2010YouTube Create dependent drop down lists in Excel to select items based on another list selection. Create lists that are dependent on other lists to limit options and help validate entries. VISIT COMPUTERGAGA FOR LOTS MORE TIPS http://www.computergaga.com CONNECT WITH US! Google+ ► https://plus.google.com/+Computergaga Facebook ► http://www.facebook.com/computergaga Twitter ► http://www.twitter.com/computergaga1
Learn how to dynamically change selections in one drop-down list based on value selected from another drop-down list. example of that could be selecting department in the first drop-down list and the second drop-down list immediately start showing only employees in that department. The way we are doing it, adding new items to the master list make the new item available immediately in the drop-down menu selection without having to change the range inside the name manager! it is a big time saver! Hope you Like it!
I created this video lesson in response to a viewer request. She knew that there was a function that Excel uses to join two "Pick-From" lists in Data Validation. She just could not remember the Function - the =INDIRECT() function - nor could she remember how to do it. Perhaps you have the same question. Or a different question. Simply write to me and I will try to solve your problem with a new video lessons. I wish all of my viewers a happy new year in 2009! Danny Rocks
In this video, I show you how to insert a drop-down box in an order form in Excel and use VLookup to auto-fill the contact info fields. This is a great way to select a customer number and have all of the address fields auto-fill. It's pretty simple once you get the hang of it! Don't forget to subscribe to my channel for more tutorials! Check out my website at http://www.sallyu.com Video recorded using Screencast-O-Matic (http://www.screencast-o-matic.com) Thanks for tuning in!
http://5minuteguide.net This lesson will explain how to use the INDIRECT function and the VLOOKUP function to create two dependent drop down lists that have different information, but that both change based on a master drop down list in Microsoft Excel. This video was created using Screenflow by Telestream - https://store.telestream.net/order/product.php?PRODS=4578129&QTY=1&AFFILIATE=54365 Forum for Viraj's question: http://www.excelforum.com/excel-formulas-and-functions/937664-massive-data-validation-with-dropdown-lists.html?p=3314892#post3314892 Multiple selections with VBA & Data Validation: http://blog.contextures.com/archives/2011/04/29/how-to-set-up-multiple-selection-excel-drop-down/ Amazon Affiliate link to Excel 2016 For Dummies (Excel for Dummies) https://www.amazon.com/gp/product/111929343X/ref=as_li_tl?ie=UTF8&camp=1789&creative=9325&creativeASIN=111929343X&linkCode=as2&tag=indelible01-20&linkId=23a5da3d4a16e3423d809a92e09a5fbe
Excel Power Tips: Learn these useful Techniques for creating Lists, setting up Drop Down Menus and doing Data Validation in Excel. Do you want to become an Excel expert? Learn how to use Excel more powerfully than ever before. Then you should take a look at the Excel Expert course by Mynda Treach: Go to this link - http://www.launchexcel.com/moth-excel-expert Download sample workbook to follow along at: http://www.launchexcel.com/excel-dropdown-list-data-validation In this 20 minute episode we'll look at lists, drop downs and data validation. These are very important areas of Excel that you should master if you want to take your Excel skills to the next level. Read the accompanying article and download the sample workbook at www.launchexcel.com: http://www.launchexcel.com/excel-dropdown-list-data-validation Video Highlights: --- Excel Built-in Lists --- 0:10 Excel's Built-in Lists (Days of week, Months of year) --- Excel Custom Lists --- 1:06 Three use cases for Custom Lists 3:57 How to create a Custom List (instructions for Excel 2010) --- Dependent Drop-down Lists (Country, City) --- 5:08 Drop Downs for Data Entry 6:47 How to create Dependent Drop Downs with Data Validation and Named Ranges 9:38 TIP: How to define multiple Named Ranges 10:02 The "Slow" Way using the Name Manager 11:24 The "Fast" Way using CTRL + SHIFT + F3 14:09 Why do we need "Helper" columns? --- Data Validation (E-mail, Date of Birth) --- 15:40 Data Validation of Email addresses 18:20 Data Validation of Date of Birth (you must be at least 15 years old) 19:48 Warning: Data validation can be easily overwritten by Copy ➜ Paste and what to do about this
Learn to quickly lookup different pictures based on the value of a cell. Some people call this VLOOKUP on images. You can use this technique for company logos, employee pictures, flags - basically anywhere where you need to show different images based on the value of a cell. You'll also learn a few other techniques here. For example: 1. How to work with Excel's picture tools (Crop images, align etc) 2. How to use Name Manager to assign names to cells and how to do it quickly with "Create from Selection" option 3. A little bit about the INDIRECT function (find out more with the below link) 4. How to link pictures to cells 🡻 Download the workbook here 🡻 The steps are explained in 5 simple steps in this blog post: http://www.xelplus.com/excel-lookup-on-pictures/ Scroll down to the bottom to get the Excel file. ★★ Links to related videos: ★★ World Cup 2018 Sweepstake (with free template link): https://youtu.be/a2IXn1FQU3A INDIRECT function: https://youtu.be/GUClkvJ7Gag Data validation basics: https://youtu.be/FRiFfKb_B_A Custom Data validation: https://youtu.be/bDXQy60BcT4 ➹ ➹ ➹ My Online Excel Courses ➹ ➹ ➹ Excel VBA & Macros ► http://bit.ly/LeilaVBA Excel Dashboards ► http://bit.ly/LeilaDashboards Excel Charts ► http://bit.ly/LeilaCharts Advanced Excel ► http://bit.ly/LeilaAdvancedExcel Excel Waterfall Charts ► http://bit.ly/LeilaWaterfall 🕮 Recommend Excel Resources 🕮 https://www.xelplus.com/resources/ ⚙ Gear used to make the video https://www.xelplus.com/resources/#gear ✉ Subscribe & get my Excel top 10 tips and formulas e-book for free ✉ https://www.xelplus.com/free-ebook/
This video will show you step by step how to create a searchable dropdown list in Excel. This technique uses data validation and some formulas. SEARCH, VLOOKUP, MAX, IF, IFERROR, COUNTIF, ROWS, OFFSET & ISNUMBER. Create a searchable drop down list in excel.
Tori Cushing from BlueGlass Inc will show users how to do three different types of Excel drop down lists. She will walk through creating drop downs with data validation, form controls, and activex control combo boxes.
Check out my Blog: http://exceltraining101.blogspot.com How to create a dynamic drop down list in Excel. #exceltips #exceltipsandtricks #exceltutorial #doughexcel