Dashboards with Excel

Dashboards with Excel, available at $19.99, has an average rating of 4.3, with 30 lectures, based on 17 reviews, and has 2019 subscribers.

You will learn about Microsoft Excel Reporting Controlling Dashboards Business Charts Management Information System Business Analytics Data Analysis This course is ideal for individuals who are Financial Analyst or Merchandise Planner or Controller or Accounting Manager or CFO or Sales Assistant or Management Consultant It is particularly useful for Financial Analyst or Merchandise Planner or Controller or Accounting Manager or CFO or Sales Assistant or Management Consultant.

Enroll now: Dashboards with Excel

Summary

Title: Dashboards with Excel

Price: $19.99

Average Rating: 4.3

Number of Lectures: 30

Number of Published Lectures: 30

Number of Curriculum Items: 30

Number of Published Curriculum Objects: 30

Original Price: $89.99

Quality Status: approved

Status: Live

What You Will Learn

Microsoft Excel
Reporting
Controlling
Dashboards
Business Charts
Management Information System
Business Analytics
Data Analysis

Who Should Attend

Financial Analyst
Merchandise Planner
Controller
Accounting Manager
CFO
Sales Assistant
Management Consultant

Target Audiences

Financial Analyst
Merchandise Planner
Controller
Accounting Manager
CFO
Sales Assistant
Management Consultant

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.

In this Online-Course you will learn how to create professional Business Charts with Excel step by step.

The concept named OPO – one page only.

At PUMA AG I was responsible for the worldwide Retail Controlling and developed a new Reporting-System for the stores. All reports were standard at board-management.

In Germany I publish many articles and books about Microsoft Exceland how to use professional Dashboardsin companies.

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 Microsoft Excel.

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

required.

PLEASE NOTE

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

Course Curriculum

Chapter 1: Introduction

Lecture 1: Introduction

Chapter 2: professional table

Lecture 1: professional table

Chapter 3: Table Charts

Lecture 1: Table Charts – $ Dollar

Lecture 2: Table Charts – % Percentage

Chapter 4: Bar Charts

Lecture 1: Intro Bar Charts

Lecture 2: Table for bar charts

Lecture 3: bar chart – positive values

Lecture 4: bar chart – negative values

Lecture 5: bar chart – consolidation

Chapter 5: Portfolio

Lecture 1: Intro Portfolio

Lecture 2: table for portfolio chart

Lecture 3: portfolio chart and poor dogs

Lecture 4: bubbles – question marks

Lecture 5: bubbles – cash cows

Lecture 6: bubbles – stars

Lecture 7: arrows and titles

Chapter 6: Charts for development

Lecture 1: Intro and table – chart for development

Lecture 2: chart last year values

Lecture 3: chart positive values – part 1

Lecture 4: chart positive values – part 2

Lecture 5: chart negative values

Lecture 6: chart consolidation

Lecture 7: Divider

Lecture 8: Intro and table – chart %

Lecture 9: chart – positive deviations %

Lecture 10: chart – negative deviations %

Lecture 11: chart – consolidation %

Lecture 12: divider – %

Lecture 13: months in charts

Chapter 7: Excel Camera

Lecture 1: Excel Camera

Instructors

Kristoffer Ditz
über 100 Online-Kurse für Ihre Ziele – mit Zertifikat

Rating Distribution

1 stars: 1 votes
2 stars: 0 votes
3 stars: 2 votes
4 stars: 5 votes
5 stars: 9 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!

Menu