You've really outdone yourself this time, such an amazing video.😍😍👍👍 I'm sure that in a short while, your subscriber count will exceed a million.❤❤😁😁 But please, I have one request: make more tutorials on Power Query and Power BI.
xlook up is almost the same as the vlookup, the only difference is that it doesn't use a look-up column anymore. It somehow functions like sumifs or countifs wherein all you need to do is look up the value based on a criteria or multiple criterias. For example, if you want to look up the sales of Team A on a certain year, you just need to combine your two criterias using the ampersand, and then combine the criteria column as well. It is much simpler.
hi there, it can definitely help, but Excel is not the only factor to a good salary. It depends more on your education, work experience etc. I'd say Excel is a very useful skill to have, but not the main deciding factor to getting a good salary.
Good salary is based on your knowledge+skills and EXPERIENCE. Entry level excel jobs offers only descent salary. But if you are an experienced excel/ analytics experts, that's how you get a premium salary.
using FILTER to give me all courses in column B attended by Students in Column A, what i need is the count of Course A, B, C instead of listing them all and count them. how do I do a =COUNTIF(FILTER, "")
🔥Take our Complete Finance & Valuation Course: www.careerprinciples.com/courses/finance-valuation-course
This is one of your best vids yet. Here's a major compliment. You're easy to learn from. Thank you
These are so good! And as somebody that uses Power BI, it's amazing to me how many GREAT Excel users don't know anything about Power Query and PBI.
that's a great point! thanks for your comment :)
@@KenjiExplains yes Kenji please make video on Power BI.
What a great video but for some reason it won't let me put some formulas and I don't know why
Try to find an Office key to see if that problem is solved.
But try to search in safe places, at least BNH software worked for me.
I think it is an option, it is better to go for the safe option.
I can try thanks
Thank you. Just found out, power query under DATE function, there is Quarter conversion function. Nice
Another very informative topic!... Thank you very much...
Wow great video!! Thanks Kenji
Hello... Would like to ask what formula will i use if this is the scenario....
15% of gross sales or 20k whichever is higher. Thank you in advance🙏🧡
Glad to be in 1% ;)
Great! Enjoyed watching and learned something new. Keep it up.
Glad you enjoyed it!
thank you can you do a part2 as well?
Noted!
You've really outdone yourself this time, such an amazing video.😍😍👍👍 I'm sure that in a short while, your subscriber count will exceed a million.❤❤😁😁
But please, I have one request: make more tutorials on Power Query and Power BI.
Can you make a video about advanced filter???? Please it’s a request
Sir, please create a complete tutorial on Power Pivot that covers all DAX functions.
what do you mean "covers all DAX functions"... I think it's a lot better to focusing on most use functions.
Honestly the main DAX you have to know is CALCULATE, VAR, IF, and the “X” iterative functions, obviously there’s more but to many for one video
Shouldn’t the row and column inputs for the data table be flipped?
How do you query a CSV data?
Great video. Can you answer a question of mine regarding xlookup?
xlook up is almost the same as the vlookup, the only difference is that it doesn't use a look-up column anymore. It somehow functions like sumifs or countifs wherein all you need to do is look up the value based on a criteria or multiple criterias. For example, if you want to look up the sales of Team A on a certain year, you just need to combine your two criterias using the ampersand, and then combine the criteria column as well. It is much simpler.
Thanks brother, Can one get a good salary after learning to excel? Please reply.
hi there, it can definitely help, but Excel is not the only factor to a good salary. It depends more on your education, work experience etc. I'd say Excel is a very useful skill to have, but not the main deciding factor to getting a good salary.
@@KenjiExplains thanks for your reply 😊
Good salary is based on your knowledge+skills and EXPERIENCE. Entry level excel jobs offers only descent salary. But if you are an experienced excel/ analytics experts, that's how you get a premium salary.
using FILTER to give me all courses in column B attended by Students in Column A, what i need is the count of Course A, B, C instead of listing them all and count them. how do I do a =COUNTIF(FILTER, "")
COUNTA
Twas my network. It’s working now.
Awesome!
Was wondering when this week’s was gonna drop… hehe… thank u
You're the first comment! Thank you for your support :)
Thanks
hi i cant use sequence and many formulas in my excel
These formulas are only available in excel version 2021 and higher
👍
❤