Only the Top 1% of Analysts Have These 5 Excel Skills
Kenji Explains Kenji Explains
588K subscribers
25,200 views
1.1K

 Published On Sep 15, 2024

5 Excel tricks to boost your productivity!
πŸ”₯ Take our Complete Finance & Valuation Course: https://www.careerprinciples.com/cour...

πŸ†“ DOWNLOAD Free Excel file for this video: https://careerprinciples.myflodesk.co...

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:
πŸ‘‰ Excel for Business & Finance Course: https://www.careerprinciples.com/cour...
πŸ”₯Power BI for Business Analytics: https://www.careerprinciples.com/cour...
πŸš€ All our courses: https://www.careerprinciples.com/courses

β–¬β–¬β–¬β–¬β–¬β–¬β–¬β–¬β–¬β–¬β–¬β–¬β–¬β–¬β–¬β–¬β–¬β–¬β–¬β–¬β–¬β–¬β–¬β–¬β–¬β–¬β–¬β–¬β–¬β–¬β–¬β–¬β–¬β–¬β–¬β–¬β–¬β–¬β–¬β–¬

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

show more

Share/Embed