EXCEL - TRUCCHI E SEGRETI: 📑Convalida dati da campo tabella: impossibile? Problema risolto

Use the code MENO10 to get 10% off #Xcamp, the practical course for truly learning Excel: https://experta-bs.it/shop Looking for more EXCEL TRICKS and SECRETS? Easy! You can find all the tutorials in the EXCEL Playlist: Tips and Secrets - #EXCELoltreognilimite (   • EXCEL Trucchi e Segreti - #EXCELoltreognil...  ) and, if that's not enough, there are the LIVE STREAMINGS that make Excel Magic, or almost :) (   • EXCEL Trucchi e Segreti: Dirette Streaming  ) In this video tutorial, I demonstrate how to create a drop-down menu (using #Excel's #datavalidation) that uses a table field as its source (so that any new values ​​are automatically included in the list). At first, data validation seems to fail if we use natural language (or structured references) for tables, but there is a solution (or rather, two)! Support our channel with a donation: https://www.paypal.com/donate?hosted_... Here are some interesting titles: ITA - My Name Is Excel, I Solve Problems (Flexible) https://amzn.to/3I0fwq2 ITA - My Name Is Excel, I Solve Problems (Kindle) https://amzn.to/2ZWIk1m ENG - Power Pivot and Power BI: The Excel User's Guide to DAX https://amzn.to/3xtu0tG ENG - The Definitive Guide to DAX https://amzn.to/3Efejsi ENG - Analyzing Data with Power BI and Power Pivot for Excel https://amzn.to/3D9Ro0b ENG - Power Query for Power BI and Excel https://amzn.to/3xsxzQs ENG - from May 17, 2022 – Excel 365 Bible https://amzn.to/3ev8cVQ _________________________________________ #EXCELoltreognilimite #EXCELoltreognilimiteTRUCCHIeSEGRETI #EXCEL #emmanuelevietti ____________________________________________ Author: Emmanuele Vietti Video created with: Camtasia Studio v.9.2.1 Software: Microsoft Office 365 Excel All rights reserved: © 2021 Experta Business Solutions srl ______________________________________________ EQUIPMENT: Microsoft 365 Family - https://amzn.to/3JquVAH Microsoft 365 Business - https://amzn.to/3yVASAL Webcam - https://amzn.to/3D79ikd Webcam support - https://amzn.to/2ZKWUce LED Table Lights - https://amzn.to/31mbeYQ Green Screen - https://amzn.to/3d5vCQM Green Screen and Lights - https://amzn.to/3xSmSqT Graphics Tablet - https://amzn.to/3Ic67M4 ____________________________________________ LINKEDIN: Microsoft Excel Professional Use Group (  / 2279096  ) FACEBOOK: Microsoft Excel Professional Use Page (  / utilizzoprofessionaledimicrosoftexcel  ) TELEGRAM: Microsoft Office Professional Use Group (https://t.me/utilizzoprofdimicrosofto...) TIKTOK: upmsexcel Profile (  / upmsexcel  ) INSTAGRAM: upmsexcel Profile (  / upmsexcel  ) If you enjoyed this video, please like it, check out our other content, and subscribe to our channel. If you have suggestions for new posts, please leave them in the comments section or fill out the contact form on our website www.experta-bs.it, and we'll do our best to accommodate your requests. Your satisfaction is our greatest achievement.