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

5 Excel tricks to boost your productivity!

In this tutorial we go over 5 genius Excel skills to boost your productivity. Firstly we have importing data from the web into excel so we can have a live connection. This allows us to import any website data into Excel. Secondly, cleaning data using Power Query, which is faster than using Excel formulas.
Thirdly, using Alt Key shortcuts to reach any part of the ribbon and get things done faster. Fourth, using pivot tables for data analysis instead of Excel functions. Lastly, using the what-if analysis tool's data table to create different scenarios. As a bonus, we have automating with Excel Macros.

LEARN:

▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬

Chapters:
0:00​ -​ Skill 1
1:27​ - Skill 2
3:57​ - Skill 3
6:11​ - Skill 4
8:31​ - Skill 5
11:20 - Bonus Skill

[kayespedal]

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

[crashingatom]

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.

[ivobaren]

love your content. Could you please teach some accounting and valuation based on your audit experience and based on M&A valuations at Goldman

[Mo-Thoughx]

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

[Abdulhamidkarimov-ew]

Hi, Kenji

I find your tutorials truly amazing.

Is it possible for you to make a video about preparing project valuation documents and financial models for infrastructure projects (construction of roads and cement-concrete facilities) under public private partnership scheme taking, any random developed or developing country's legislation?

[zhiqizhang]

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

[silvestrecamposano]

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

[Lupin]

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

[faizujutt]

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

[ABDULQADEERQADEER-tyrp]

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

[AbdulRahman-ypoy]

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.

[magnus]

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

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

[kromeface]

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

[rumeeburu]

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

[MSshorts..-iqos]

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

[rachidikhlef]

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

[_Arjunbansal]

hi i cant use sequence and many formulas in my excel

[ErinTruitt-sj]

White Scott Gonzalez Frank Anderson Margaret