Learn Advanced Formulas in Excel

Download the demo file and follow along here

In this Advanced Formulas in Excel tutorial, we'll talk about the VLOOKUP formula before moving on to discuss lookups with multiple criteria.
We'll also discuss combining and splitting texts, INDEX and MATCH with multiple criteria, COUNTIFS and SUMIFS, and more.
Finally, we'll take a look at the LAMBDA formula and how you can create your own functions with LAMBDA.

💻 Watch more free popular training tutorials from Simon Sez IT:

🔥Check out our FREE 300+ hour training course playlist here ➡️

💬Stay in touch!

🔔 Subscribe to our channel:

If you enjoyed the video, please give a thumbs up 👍🏽 ;-)

[SimonSezIT]

Download the demo file and follow along here

[goldendice]

Excellent 👏👏👏. This is my second time to learn from you after your course on advanced Word lecture. As usual, clear explanation and useful examples. You are simply Great

[gloystar]

Thanks for your excellent videos, Deb, you're the best on YouTube and I've become much more skilled in excel because of your videos. Would you mind making a video about "Recursive Lambda" since I'm very eager to learn it?

[miall]

TEXTSPLIT Function makes life easier !!!!

[zenc]

How to convert number's figure into text without module/codes??

[excellNexcel]

Deborah has a big face...nice, big, beautiful face.