How can you learn the Excel dashboard?

vhs.digital

Online course: Dashboards - presenting information clearly with Excel


course


Previous knowledge: Excel basics

You will learn to create meaningful dashboards. This enables you to quickly grasp the essential information. Individually adjustable dashboards provide the basis for reliable decisions.

With the help of a variety of exercises, you will gradually improve your Excel skills. You will learn how to prepare your data accordingly in order to present all relevant information clearly. This is the only way to offer a reliable basis for decision-making.

Just watch the video with selected course content in advance:
https://www.excel-berlin.com/excel-video.html

Contents:
- Create and edit different types of diagrams effectively
- Custom number format and conditional formatting
- Sparklines, map diagrams, special diagrams
- Dynamic charts
- Special Effects, design with PowerPoint
- Pivot tables, pivot charts
- controls
- relative, absolute and mixed references, names
- important functions including logic functions, VLOOKUP, INDEX, COMPARE
- Preparation of information for presentation in the dashboard
- Design and dynamization of dashboards
- lots of tips and tricks

An entry at any time. You can use the course for up to six months. Communication between you and the course leader takes place over the Internet. This means that you are independent of time and place and can deepen and expand your knowledge flexibly and efficiently. Internet access with DSL speed and a computer with Microsoft Excel are required. The course uses the new features of Excel 365, but for the most part can also be completed with older versions of Excel.

You can find information about the course management at: www.dozent4u.de
If you have any questions, simply use the contact form.

Martin Rode, who is responsible for the program, will be happy to provide you with further information about this course on 0561-1003 1671.

Course number: 211-12244
Cost: € 258.00


Period

You can start with the lesson at any time!

Registration

to

Availability

Free places


Course location (s)

There are no locations available for this course.

Lecturer (s)