Create advanced excel charts (forecast chart, waterfall chart, column chart etc.)
👉 Sign up to Morning Brew: morningbrewdaily.com/kenjiexplains

🆓 DOWNLOAD Free Excel file for this video:
view.flodesk.com/pages/62daa67903e5892a03493bb0

In this video you'll learn to create 5 dynamic advanced excel charts.
In level 1, we'll go over a dynamic doughnut chart, where the centre will include the customer satisfaction score out of 100% dynamically linked.
In level 2, we'll go over a budget vs actuals charts. This will start as a column chart and by changing the second axis and the column widths we'll active a progress bar chart.
In level 3, we'll go over a waterfall chart, which allows us to track progress over time.
In level 4, we'll go over a forecast chart, which allows you to forecast how a certain trend is going to evolve in the future. In our case, we use Netflix shares as an example.
Lastly, in level 5, we go over a complex column chart with a percentage change to showcase the revenue trend in more detail.

LEARN:
📈 The Complete Finance & Valuation Course: careerprinciples.com/courses/finance-valuation-course
👉 Excel for Business & Finance Course: careerprinciples.com/courses/excel-for-business-finance
📊 Get 25% OFF Financial Edge Using Code KENJI25: bit.ly/3Ds47vS

USEFUL SOURCES:
Excel Campus: excelcampus.com/charts/column-chart-percentage-change/
Xelplus: xelplus.com/excel-progress-circle-chart/

SOCIALS:
📸 Instagram - instagram.com/careerprinciples/?hl=en
🤳 TikTok - tiktok.com/@career_principles
🧑‍💻 LinkedIn - linkedin.com/company/careerprinciples/

GEAR:
📹 My Favorite Books & Gear: kit.co/kenjiexplains
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬

Chapters:
0:00​ -​ Level 1 Doughnut Chart with Textbox
2:57​ - Level 2 Progress Column Chart
5:59​ - Level 3 Waterfall Chart
7:42​ - Level 4 Forecast Chart
9:20​ - Level 5: Column Chart with % Change

Disclaimer: I may receive a small commission on some of the links provided at no extra cost to you.

• Build 5 ADVANCED Excel Charts from Scratch ( Download)
• Excel Charts and Graphs Tutorial ( Download)
• Get Ahead With These 10 Advanced Excel Charts! ( Download)
• 10 Advanced Excel Charts and Graphs (Creating from Scratch) | FREE Excel Course ( Download)
• Effortlessly Create Dynamic Charts in Excel: New Feature Alert! ( Download)
• Actual vs Target Charts in Excel: How to make variance charts in Excel with floating markers or bars ( Download)
• Progress Charts in Excel! 8 Types That Will Help You Get Ahead ( Download)
• Make Impressive McKinsey Visuals in Excel! ( Download)
• 𝗕𝘂𝗶𝗹𝗱 𝗮 𝗚𝗮𝗻𝘁𝘁 𝗖𝗵𝗮𝗿𝘁 𝗬𝗼𝘂’𝗹𝗹 𝗡𝗲𝘃𝗲𝗿 𝗙𝗼𝗿𝗴𝗲𝘁! 𝗨𝗹𝘁𝗶𝗺𝗮𝘁𝗲 𝗘𝘅𝗰𝗲𝗹 𝗣𝗿𝗼𝗷𝗲𝗰𝘁 𝗚𝘂𝗶𝗱𝗲 ( Download)
• How to Make Bar Chart in Excel ( Download)
• Advanced Excel: Using Charts and Functions to See Trends ( Download)
• Make Beautiful Excel Charts Like The Economist (file included) ( Download)
• How To FORMAT CHARTS in Excel #shorts ( Download)
• 📊 How to Build Excel Interactive Dashboards ( Download)
• How to combine a line graph and Column graph in Microsoft Excel| Combo Charts in Excel ( Download)