Hands On Training

Dashboards With Excel by Skillshare

via

Skillshare

Course Features

Duration

2 hours

Delivery Method

Online

Available on

Lifetime Access

Accessibility

Mobile, Desktop

Language

English

Subtitles

English

Level

Beginner

Teaching Type

Self Paced

Video Content

2 hours

Course Description

Management does not always see reports and tools that controllers create.

Reports often contain excessive material such as clipart or confusing graphics, and many legends.

CONTENTS (with Excel 2013-2016) You will learn:

How to build a professional table
Deviations (Euros and Percents) in tables
Bar charts
Portfolio / 4 fields matrix
Charts for developments
Excel Camera

You will also receive an Excel training file, including the formulas and the solutions.

COURSE OBJECTIVE

The video course will teach you the fundamental techniques and methods of successful reporting. You will also learn how to create professional Excel dashboards.

Basic knowledge of MS Office, and Excel on your computer

required.

NOTE

This video course was created using Excel 2016. However, the diagrams can be used with Excel 2010 or 2007. It is very similar.

Course Overview

International Faculty

Post Course Interactions

Hands-On Training,Instructor-Moderated Discussions

Case Studies, Captstone Projects

Skills You Will Gain

Prerequisites/Requirements

Basic knowledge of MS Office and an Excel version on your own computer required

What You Will Learn

Business Analytics

Chart

Data Modelling

Data Virtualization

Excel

Microsoft Excel

Pivot Table

Spreadsheet

Course Content

Expand all sections

Module 1: Introduction Dashboards with Excel

Module 2: Table Charts $ Dollar

Module 3: Table Charts % Percentage

Module 4: Intro Bar Charts

Course Instructors

Kristoffer Ditz

Instructor

Instructor at Skill Share