i have been watching your videos for past 4 days and i honestly say that it is simplest video even you make 6 hr video i can watch it. i looking to upskill my resume and you explaining thing in simplest form. a guy like me working in customer service and sales looking to gain specific skill to get better job. thank you for creating this content which helps million. i still going through your series of video and when my basic are clear then i can go for the certification course so that i can get a better job profile. i pray to god for your well being and prosperous life ahead.
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.
XLOOKUP is not available in Excel 2016 and Excel 2019. However, you may come across a situation of using a workbook in Excel 2016 or Excel 2019 with the XLOOKUP function in it, if it was created by someone else using a newer version of Excel.
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")
i modded Sub Game() Dim x As Integer, a As Integer x = WorksheetFunction.RandBetween(1, 10) Do a = InputBox("Tom is Thinking of a number between 1 and 10, What is it?") If a = x Then Exit Do If a < x Then MsgBox ("The number is higher, try again") Else MsgBox ("The number is lower, try again") End If Loop MsgBox ("You and Tom are connected") End Sub And now use Else
![Blox Fruits Dragon Rework Update [Full Stream]](http://i.ytimg.com/vi/EqDAp8udhm0/mqdefault.jpg)
Exercise Files: learnitanytime.com/p/exercise-files-excel-advanced-tutorial-2024
i have been watching your videos for past 4 days and i honestly say that it is simplest video even you make 6 hr video i can watch it. i looking to upskill my resume and you explaining thing in simplest form. a guy like me working in customer service and sales looking to gain specific skill to get better job. thank you for creating this content which helps million. i still going through your series of video and when my basic are clear then i can go for the certification course so that i can get a better job profile. i pray to god for your well being and prosperous life ahead.
Thank you so much for the kind words! We hope you are able to climb that career ladder!
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!
the color coding skills used here are amazing ty
Glad you liked the color coding!
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!
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!
I learned a lot from this! Thank you so much
You are welcome!
nice explanation
Thanks!
This was a very helpful tutorial. Thank you! 👍🏼
You're 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!
Thank you so much for your informative and excellent presentation.
You are very welcome!
I learn alot Thanks million times
You are very welcome
35:50 why don't we use absolute reference just like in the xlookup? what's the difference?
just can i saying you are the best!
Thanks!
For x lookup what if you want to see all instances of the notebook listed?
Love it ❤
Thanks!
I fw joe 🗣️💥💥
💯💯💯💯💯
hello I can't find or it's not showing xlookup function on my excel.
XLOOKUP is not available in Excel 2016 and Excel 2019. However, you may come across a situation of using a workbook in Excel 2016 or Excel 2019 with the XLOOKUP function in it, if it was created by someone else using a newer version of Excel.
MAKE MORE OF MINE!
IM SO AT STUCK.
👍👍
Can i get the pdf of the course 😊
Mate how you autofill all this 4300 columns which buttons you have been using?
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")
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!
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
Start using a better mic. Great quality content though. ❤
Working on it!
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!
i modded
Sub Game()
Dim x As Integer, a As Integer
x = WorksheetFunction.RandBetween(1, 10)
Do
a = InputBox("Tom is Thinking of a number between 1 and 10, What is it?")
If a = x Then Exit Do
If a < x Then
MsgBox ("The number is higher, try again")
Else
MsgBox ("The number is lower, try again")
End If
Loop
MsgBox ("You and Tom are connected")
End Sub
And now use Else
👍