Simplify ANY Excel Formula With This Trick

[@KenjiExplains]

🚀Get FREE Excel chart templates from Hubspot: clickhubspot.com/933u

[@cruzianfibergeek]

Finally it clicked on what lambdas can do. I just created my first lambda function for something I do several time day. You have just helped my save soooo much time.

[@JammieDragon2319]

These videos are very helpful, simple and straightforward. You explain clearly what your doing without adding any irrelevant information. Also your names almost the same as mine I'm Benji :D

[@KenjiExplains]

Thank you for your nice comment Benji! Yes haha they often confuse mine for Benji XD

[@antoniop.3586]

Wow, Kenji. I didn't know lambda and it just blowed my mind!! Thank you very much!!

[@KenjiExplains]

Great to hear that!

[@willzinner8813]

can you do more advanced cases of Lambda?

[@KenjiExplains]

Noted!

[@madhanKumar-d4p]

"First like and first comment! I’m truly impressed by all your videos, sir. 🙏"

[@KenjiExplains]

Thank you! Really appreciate it :)

[@ahmedsafwan2184]

Thanks Kenji you are a life savior God Bless you

[@IvanCortinas_ES]

Great explanation. Thank you, Kenji!!!

[@camlex6310]

Really helpful video!! Thanks Kenji

[@budams4668]

Super nice explanation of what lambdas are! Easy to grasp, and recreatable . But a little but, that has less to do with the lambda and more with your last step. Whilst I think the search field is super handy for very big data tables with many options, I would actually connect this with your lessons for dropdowns and the # . I just generally mistrust people to spell things correctly, and rather turn around and complain something isn’t working than check their own fallacy. So I take away the potential for mistakes by creating a field in an open area of the sheet or a new sheet with the formula =unique(Table[region column] Creating all unique and hence possible options for the filter and then reference to that field in the data validation with a #

[@Seftehandle]

Made lamda really easy to follow along. Thanks!

[@AbdulRahman-yp6oy]

Nice ,easy to understand Excellent ❤😊

[@TheWaldoMC]

Thank you for explaining the LAMBDA function, but everything you showed its also manageable by converting the data into a table, which can provide more filter and sort options. What are your thoughts?

[@ebamybass19]

Thank you kenji

[@colinhuntley9729]

impressive that as well as being an excel-expert, you speak very good german!

[@emefaamartey5922]

Thank you

[@48Gelombang]

Can this formula be applied to Excel on different devices? Or does the formula have to be created first? Terimakasih

[@denisereyes3337]

Hello, I want to learn excel (just because I like it) which of your courses do you recommend. My level will be like basic-intermediate. Thank you

[@KenjiExplains]

Hi thank you for your interest. I think the Excel for business & finance course is a nice starting point for you: www.careerprinciples.com/courses/excel-for-business-finance For any other questions you can ask [e-mail] 👍