Excel Dashboards & Power BI Bootcamp – Finance & Accounting

Learn to create beautiful, powerful & dynamic dashboards in Excel & Microsoft Power BI

Being able to visually present your analysis is key! Learn to create beautiful, powerful, and dynamic dashboards in Excel and Power BI.

What you’ll learn

  • How to create beautiful, powerful, dynamic dashboards and reports in Power BI.
  • How to get more out of Microsoft excel including great dashboards.
  • Make reports available to stakeholders 24/7 on all devices.
  • Simple methods to Analyze data with Power BI and gain Insights.
  • Different visualizations & how to use them.
  • Explore your data with Power BI.
  • Master the rules for Data Preparation.
  • Identify what a dashboard really is and dashboard best practices.
  • Connect your data to Microsoft Power BI.

Course Content

  • Welcome to the course! –> 1 lecture • 2min.
  • Introduction to Dashboards & to the Case Study –> 5 lectures • 33min.
  • Creating a Dynamic Excel Dashboard pt. I –> 7 lectures • 48min.
  • Creating a Dynamic Excel Dashboard pt. II –> 8 lectures • 49min.
  • Analyzing Our Data Using Microsoft Power BI pt. I –> 10 lectures • 46min.
  • Analyzing Our Data Using Microsoft Power BI pt. II –> 9 lectures • 43min.
  • Conclusion –> 1 lecture • 3min.

Auto Draft

Requirements

  • You should have an intermediate knowledge on Excel (eg: IF Statements, VLOOKUP, COUNTIFS & etc.).
  • Fundamental Excel Knowledge is an added advantage.
  • Knowledge of Excel Pivot Tables is an added advantage.

Being able to visually present your analysis is key! Learn to create beautiful, powerful, and dynamic dashboards in Excel and Power BI.

What will you learn in this course?

  • Identify what a dashboard really is and dashboard best practices
  • Create a powerful, dynamic Excel dashboard
  • Create many of the most common visualizations used in dashboards
  • Connect your data to Microsoft Power BI
  • Utilize Power BI to create powerful visualizations
  • Derive a deeper knowledge of your data using the tools in Power BI

Want to be the team Rockstar? Learn to create dashboards! Dashboards are interactive tools that provide insights and analyses to users. This course will quickly teach you how to create amazing dashboards in Excel and Microsoft Power BI.

After learning dashboard fundamentals in Excel, we’ll supercharge your skills by teaching you Power BI. Power BI is Microsoft’s free business intelligence tool that allows you to easily create interactive and powerful dashboards.

We recommend taking our Intro to Data Analytics using Excel in conjunction with this course. In order to truly understand your data, you need to know some analytics.

At completion, you’ll know how to make dynamic dashboards in both Excel and Power BI.

 

What makes our course so awesome?

· Real world case-studies: In depth, real-world case studies using fictitious companies

· Fun: Light-hearted, fun, and enjoyable course (we never take ourselves too seriously)

· Knowledgeable instructor: Nate is a CPA and Joe is a CFO, a lot of experience and expertise!

· No fluff: We don’t teach theory or waste your time with useless information. Everything we teach you can start applying TODAY

 

Let’s start learning!

Get Tutorial