By Kristoffer Ditz, Instructor
Dashboards with Excel
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