One of the first youtube videos I was actually excitedly waiting for! Been very grateful for this tutorial, my skills have improved in such a short period of time.
In the Macros section, it is needed to go to Tools - Options and uncheck Require Variable Declaration if the "Option Explicit" is activated, otherwise you have an error.
Allow me to oblige: logical test 1 value if true 1 logical test 2 value if true 2 logical test 3 value if true 3...and so on =IFS(F5=1,"Soup",F5=2,"Sub",F5=3,"Salad")
Exercise Files: learnitanytime.com/p/exercise-files-excel-advanced-tutorial-2024
One of the best video tutorials for Excel, from their beginner, intermediate, advanced and expert... Very detailed and highly skilled
Thank you for the kind words!
I can only imagine how many have been able to secure jobs because of your excel videos. I know I'm one of them. Thank you Joe.
Love to hear comments like this! We are glad to have helped you in securing a job!
Great video, i still can't believe that this content is free. Thank u so much
You are very welcome!
Introduction to code is awesome. A whole new world...
Welcome!
One of the first youtube videos I was actually excitedly waiting for! Been very grateful for this tutorial, my skills have improved in such a short period of time.
Glad we could help!
I learned a lot from this! Thank you so much
You are welcome!
In the Macros section, it is needed to go to Tools - Options and uncheck Require Variable Declaration if the "Option Explicit" is activated, otherwise you have an error.
Thanks for the great tiP!
Thank you so much for your informative and excellent presentation.
You are very welcome!
This was a very helpful tutorial. Thank you! 👍🏼
You're very welcome!
I learn alot Thanks million times
You are very welcome
For x lookup what if you want to see all instances of the notebook listed?
just can i saying you are the best!
Thanks!
I would suggest rather than doing multiple if functions you could have demonstrated ifs function
Noted!
Allow me to oblige:
logical test 1
value if true 1
logical test 2
value if true 2
logical test 3
value if true 3...and so on
=IFS(F5=1,"Soup",F5=2,"Sub",F5=3,"Salad")
35:50 why don't we use absolute reference just like in the xlookup? what's the difference?
I fw joe 🗣️💥💥
💯💯💯💯💯
Mate how you autofill all this 4300 columns which buttons you have been using?
Can i get the pdf of the course 😊
in XLOOKUP data mining you forget to add units to price
Noted!
Love it ❤
Thanks!
The f4 function is not working for me not sure why?! Any idea about it please! Thank you🙏🏻
try "fn+f4" it might work
@@alluriabhinay-gq3rj i will try it. Thank you!
Start using a better mic. Great quality content though. ❤
Working on it!
Please do the freak off party where there are other rappers🤭...
This is a Wendy's sir
woow
Thanks!
why you guys are skipping vlookup in all your videos? plus please get a new mic while you're at it.
Xlookup is greater than VLOOKUP
already beginner excel tutorial waş too much and now this is way too much
We built these so that they can be watched again and you can even slow the pace down. You got this!