By Kristoffer Ditz, Instructor

Dashboards with Excel

Language: English
All Levels

Course description

GENERAL 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.

CONTENTS (with Excel 2013 - 2016) you will learn: - 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. Basic knowledge of MS Office and an Excel version on your own computer required.

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.

Related Skills

Course overview - 30

  • Professional Table

  • Table Charts $

  • Table Chart Percentage

  • Bar Chart

  • Table for bar charts

  • Bar chart positive values

  • Bar chart negative values

  • bar chart - consolidation

  • Intro Portfolio

  • table for portfolio chart

  • portfolio chart and poor dogs

  • bubble question marks

  • bubbles cash cows

  • bubbles stars

  • arrows and titles

  • Intro and table - chart for development

  • chart last year values

  • chart positive values - part 1

  • chart positive values - part 2

  • chart negative values

  • chart consolidation

  • Divider

  • Intro and table - chart %

  • chart - positive % deviations

  • chart - negative deviations %

  • chart consolidation %

  • divider %

  • months in chart

  • Excel Camera

  • Concluding

Learners who have already enrolled in this course

Meet your instructor

Kristoffer Ditz
Kristoffer DitzInstructor
Qualification CBE - Certificate of Business Excellence Instructor Bachelor of Trade an Commerce (CCI) Job stations PUMA AG Fronlineshop Ludwig Beck AG Hanseatic Business School