EXCEL - POWER QUERY: 💡 Gestire gli errori con Try...Otherwise (SE.ERRORE)

Use the code MENO10 to get 10% off #Xcamp, the practical course to really learn Excel: https://experta-bs.it/shop Want to learn how to best use POWER QUERY in Excel? Easy! You can find all the tutorials in the EXCEL Power Query - #EXCELoltreognilimite Playlist (   • EXCEL Power Query - #EXCELoltreognilimite  ) While you can find all the channel's COMPLETE GUIDES in this playlist: EXCEL - Complete Guides (   • EXCEL - Guide complete  ) If you work in #Excel, you're probably familiar with the IFERROR function, which allows you to handle errors in formulas. But did you know there's a similar function in Power Query? It's the try ... otherwise expression, which will revolutionize the way you handle errors in your queries. #Try allows you to identify errors and not only returns a description of the error type. When followed by #Otherwise, we can specify how the query should behave in the event of an error. In this video tutorial, we'll try to provide a complete overview! ____________________________________ You can download the Excel file used in this video if you're a channel subscriber or have purchased the Xcamp hands-on course: https://www.experta-bs.it/download-yo... Use the contact form at https://experta-bs.it/contattaci to provide us with your information and we'll enable the download. Thank you! ____________________________________ 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 ITA - DAX. Understanding and using Microsoft Power BI formula language (flexible) https://amzn.to/3K14ORC ITA - DAX. Understanding and Using Microsoft Power BI Formula Language (Kindle) https://amzn.to/40LAnX6 ENG - Power Pivot and Power BI: The Excel User's Guide to DAX https://amzn.to/3xtu0tG ENG - Power Query for Power BI and Excel https://amzn.to/3xsxzQs ENG - Excel 365 Bible https://amzn.to/3ev8cVQ ______________________________________________ #EXCELoltreognilimite #EXCELoltreognilimiteTRUCCHIeSEGRETI #EXCELPowerQuery #emmanuelevietti ______________________________________________ Author: Emmanuele Vietti Video created with: Camtasia Studio v.2021.0.19 Software: Microsoft 365 Excel All rights reserved: © 2024 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 Mount - 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: Professional Microsoft Excel Usage Group (  / 2279096  ) FACEBOOK: Usage Page Microsoft Excel Professional User Guide (  / utilizzoprofessionaledimicrosoftexcel  ) TELEGRAM: Microsoft Office Professional User Guide (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.