The secrets to generate the most automated Excel Dashboards

Learn all the functionalities, shortcuts, formulas, interfaces and interactions between objects to generate dashboards

In this course the students will learn how to create automated Excel dashboards. In details:

What you’ll learn

  • Create their own Excel Dashboards.
  • Create Excel reports with charts and formulas.
  • Create automated reports in Excel.
  • Created automated reports and applications with Excel functions and VBA.

Course Content

  • Introduction –> 6 lectures • 32min.
  • User Acceptance Tests Dashboard –> 27 lectures • 3hr 1min.
  • Interactive Dashboard in Excel using Hyperlinks –> 5 lectures • 20min.
  • Dashboard with Interactive Sales Chart –> 6 lectures • 36min.
  • Complex KPI Excel Dashboard –> 21 lectures • 1hr 40min.
  • Make Dynamic Dashboards using Pivot Tables & Slicers –> 6 lectures • 35min.
  • Customer Service Dashboard –> 13 lectures • 1hr 31min.
  • KPI Dashboard –> 2 lectures • 10min.
  • Project Management Dashboard / Project Status Report –> 24 lectures • 2hr 8min.
  • KPI Dashboard –> 11 lectures • 42min.
  • Financial Dashboard –> 19 lectures • 1hr 22min.
  • Understand Visual Basic for Applications (VBA) –> 10 lectures • 44min.
  • Enhance the user acceptance test dashboard with VBA –> 10 lectures • 1hr 10min.
  • Special Bonus: use VBA to enhance your Excel dashboards –> 13 lectures • 1hr 16min.

The secrets to generate the most automated Excel Dashboards

Requirements

  • Basic knowledge of Windows or OSX for MAC.
  • Basic knowledge of Microsoft Excel.

In this course the students will learn how to create automated Excel dashboards. In details:

  • how to connect form commands or ActiveX to values in cells and ranges
  • how to generate automated charts which will be updated just modifying a single value in one or a few cells
  • how to create dynamic images, which will be updated by changing some values in cells
  • how to use Excel functions and formulas to create tables and data sources and summary reports
  • how to use combined lookup and reference formulas to retrieve joined values between different tables
  • how to create variable charts with data series generated dynamically

The course is conducted through examples.

These examples covers Excel dashboards in the most popular business areas, in details:

  • Dashboard testing activities
  • Interactive Dashboard in Excel using Hyperlinks
  • Interactive Sales Chart
  • several KPI dashboards
  • Make Dynamic Dashboards using Pivot Tables & Slicers
  • Customer Service Dashboard
  • Project Management Dashboard / Project Status Report
  • Financial Dashboard

During the course and especially at the end some example will be done implementing Visual Basic for Applications (VBA). The programming language to create macros and functions to expand the functionalites of Excel.