EXCEL 365 – TRUCCHI E SEGRETI: 💸 La funzione IRPEF: niente più sorprese nel calcolo delle imposte

Use the code MENO10 to get 10% off #Xcamp, the practical course to really learn Excel: https://experta-bs.it/shop Looking for more EXCEL TRICKS and SECRETS? Easy! You can find all the tutorials in the EXCEL Tricks and Secrets Playlist - #EXCELoltreognilimite (   • EXCEL Trucchi e Segreti - #EXCELoltreognil...  ) and, if that's not enough, there are the LIVE STREAMINGS that make Excel magical, or almost :) (   • EXCEL Trucchi e Segreti: Dirette Streaming  ) In this new tutorial, we tackle a thorny issue: personal income tax (IRPEF). As we know, this isn't a simple calculation like VAT, where a percentage is applied to a taxable income. Instead, it works in brackets with a progressive rate depending on the income bracket. Therefore, our goal is to build a custom function that allows us to calculate personal income tax (IRPEF) given the taxable income (considering all the variables associated with the different brackets). We'll first need to set up the calculations and then use the LET and LAMBDA functions to create our custom function. The process isn't exactly simple, but we'll eventually see how the new AFE (Advanced Formula Environment) add-on allows us to do everything in just a few clicks, potentially without even knowing what LAMBDA and LET are! Support our channel with a donation: https://www.paypal.com/donate?hosted_... Subscribe to this channel to access the benefits:    / @upmsexcel   ___________________________________________ You can download the Excel file used in this video if you are a subscriber to the channel or have purchased the Xcamp practical 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 will enable the download. Thank you! ______________________________________________ Here are some interesting titles: ENG - My name is Excel I solve problems (flexible) https://amzn.to/3I0fwq2 ENG - 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 – Excel 365 Bible https://amzn.to/3ev8cVQ _________________________________________ #EXCELoltreognilimite #EXCELoltreognilimiteTRUCCHIeSEGRETI #EXCEL #emmanuelevietti #xcamp #LAMBDAoltreognilimite ____________________________________________ Author: Emmanuele Vietti Video created with: Camtasia Studio v.2021.0.19 Software: Microsoft 365 Excel All rights reserved: © 2023 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.