When controllers create reports or tools, they are not always read by management.

Too often, the reports contain superfluous material, such as clipart, or confusing graphics and numerous legends.

What will you learn in this course?

  • Building a professional table
  • Deviations (Euro and percents) in tables
  • Bar charts
  • Portfolio / 4 fields matrix
  • Charts for developments
  • Using the Excel camera

In addition, you will receive the Excel training file (including the formulas and solutions)

Course Objective

After the video course, you will understand the key techniques and methods for successful reporting and you will know how to create professional dashboards in Excel.

Note: The video course was created with Excel 2016, but the diagrams can also be used with Excel 2010 and 2007. The approach is very similar.