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!
Great video, i still can't believe that this content is free. Thank u so much
You are very 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!
Introduction to code is awesome. A whole new world...
Welcome!
Thank you so much for your informative and excellent presentation.
You are very 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!
The f4 function is not working for me not sure why?! Any idea about it please! Thank you🙏🏻
Mate how you autofill all this 4300 columns which buttons you have been using?
35:50 why don't we use absolute reference just like in the xlookup? what's the difference?
I fw joe 🗣️💥💥
💯💯💯💯💯
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")
in XLOOKUP data mining you forget to add units to price
Noted!
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!
For x lookup what if you want to see all instances of the notebook listed?
I learn alot Thanks million times
You are very welcome
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!
This was a very helpful tutorial. Thank you! 👍🏼
You're very welcome!
just can i saying you are the best!
Thanks!
Love it ❤
Thanks!