5 Genius Excel Skills Every Analyst Should Know

5 Excel tricks to boost your productivity!
🔥 Take our Complete Finance & Valuation Course: https://www.careerprinciples.c....om/courses/finance-v

🆓 DOWNLOAD Free Excel file for this video: https://careerprinciples.myflodesk.com/a9a435addw

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.c....om/courses/excel-for
🔥Power BI for Business Analytics: https://www.careerprinciples.c....om/courses/power-bi-
🚀 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