Build 5 ADVANCED Excel Charts from Scratch

2022-07-17 4,555 0 205,680 YouTube

Download Convert to MP3

Create advanced excel charts (forecast chart, waterfall chart, column chart etc.) 👉 Sign up to Morning Brew: https://morningbrewdaily.com/kenjiexplains 🆓 DOWNLOAD Free Excel file for this video: https://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: https://www.careerprinciples.com/courses/finance-valuation-course 👉 Excel for Business & Finance Course: https://www.careerprinciples.com/courses/excel-for-business-finance 📊 Get 25% OFF Financial Edge Using Code KENJI25: https://bit.ly/3Ds47vS USEFUL SOURCES: Excel Campus: https://www.excelcampus.com/charts/column-chart-percentage-change/ Xelplus: https://www.xelplus.com/excel-progress-circle-chart/ SOCIALS: 📸 Instagram - https://www.instagram.com/careerprinciples/?hl=en 🤳 TikTok - https://www.tiktok.com/@career_principles 🧑‍💻 LinkedIn - https://www.linkedin.com/company/careerprinciples/ GEAR: 📹 My Favorite Books & Gear: https://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.

coinpayu
Loading...