Course Hive
Search

Welcome

Sign in or create your account

Continue with Google
or
Build 5 ADVANCED Excel Charts from Scratch
Play lesson

📈 Excel for Business & Finance - Build 5 ADVANCED Excel Charts from Scratch

Master Excel for Business & Finance: From Formulas to Dashboards, Unleash Your Inner Pro!

5.0 (1)
19 learners

What you'll learn

Master essential Excel formulas for business and finance applications
Develop advanced skills in creating and analyzing financial models
Utilize Excel tools such as pivot tables and charts for data visualization
Enhance efficiency in Excel with key shortcuts and interactive dashboards

This course includes

  • 5.3 hours of video
  • Certificate of completion
  • Access on mobile and TV

Summary

Keywords

Full Transcript

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 🏦 The Investment Banking Program: https://www.careerprinciples.com/career-track/the-investment-banking-program 🚀 All our courses: https://www.careerprinciples.com/all-courses ▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬ 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.

Course Hive

Continue this lesson in the app

Install CourseHive on Android or iOS to keep learning while you move.

Related Courses

FAQs

Course Hive
Download CourseHive
Keep learning anywhere