Only the Top 1% of Analysts Know These 5 Excel Skills

[@KenjiExplains]

🔥Take our Complete Finance & Valuation Course: www.careerprinciples.com/courses/finance-valuation-course

[@kayespedal10]

This is one of your best vids yet. Here's a major compliment. You're easy to learn from. Thank you

[@Benjaminpro55]

What a great video but for some reason it won't let me put some formulas and I don't know why

[@yavuzs7]

Try to find an Office key to see if that problem is solved.

[@Melissalove44]

But try to search in safe places, at least BNH software worked for me.

[@yavuzs7]

I think it is an option, it is better to go for the safe option.

[@Benjaminpro55]

I can try thanks

[@crashingatom6755]

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.

[@KenjiExplains]

that's a great point! thanks for your comment :)

[@AbdulRahman-yp6oy]

@@KenjiExplains yes Kenji please make video on Power BI.

[@zhiqizhang4348]

Thank you. Just found out, power query under DATE function, there is Quarter conversion function. Nice

[@willzinner8813]

thank you can you do a part2 as well?

[@KenjiExplains]

Noted!

[@ABDULQADEERQADEER-ty2rp]

Can you make a video about advanced filter???? Please it’s a request

[@markdreyes]

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🙏🧡

[@silvestrecamposano6317]

Another very informative topic!... Thank you very much...

[@AbdulRahman-yp6oy]

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.

[@lukasolsovsky7299]

Glad to be in 1% ;)

[@faizujutt4942]

Sir, please create a complete tutorial on Power Pivot that covers all DAX functions.

[@greisboy425]

what do you mean "covers all DAX functions"... I think it's a lot better to focusing on most use functions.

[@alecseidman5601]

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

[@Lupin290]

Great! Enjoyed watching and learned something new. Keep it up.

[@KenjiExplains]

Glad you enjoyed it!

[@camlex6310]

Wow great video!! Thanks Kenji

[@kromeface4976]

Shouldn’t the row and column inputs for the data table be flipped?

[@magnus8488]

Great video. Can you answer a question of mine regarding xlookup?

[@dalefxclub]

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.

[@MSshorts..-iq7os]

Thanks brother, Can one get a good salary after learning to excel? Please reply.

[@KenjiExplains]

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.

[@MSshorts..-iq7os]

@@KenjiExplains thanks for your reply 😊

[@dalefxclub]

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.

[@dalefxclub]

How do you query a CSV data?

[@rumeeburu3648]

Twas my network. It’s working now.

[@KenjiExplains]

Awesome!

[@rachidikhlef8192]

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, "")

[@kevinhumphreys8554]

COUNTA

[@rumeeburu3648]

Was wondering when this week’s was gonna drop… hehe… thank u

[@KenjiExplains]

You're the first comment! Thank you for your support :)

[@rumeeburu3648]

Thanks

[@_Arjunbansal]

hi i cant use sequence and many formulas in my excel

[@434_rishi6]

These formulas are only available in excel version 2021 and higher

[@ericssontest2332]

👍

[@olaidealafia1965]

❤

[@ErinTruitt-s3j]

White Scott Gonzalez Frank Anderson Margaret