Advanced business charts with Excel

Rok prijave: Otvorene prijave
Trajanje: 8 sat(i)
EduCentar cijena: Od 1.990 kn + PDV

Opis

Datum održavanja: .

Seminar summary
Well-conceived visual design of data leads to better business communication: Information is conveyed to the target audience faster and more effective. The creators of reports are able to attract the desired level of attention.
This seminar provides a well-balanced combination of conceptional and technical methods needed to produce high-class business charts for reports and presentations. These methods and techniques are universally applicable and can be adopted to individual cases easily.

Who should participate
This seminar is geared towards all professionals involved in visualizing business data in reports and presentations. Many participants come from the fields of finance and controlling, sales, marketing, project management and consulting.

Important prerequisites
A basic understanding of the practical application of Excel is required to attend this seminar. Special knowledge, however, such as VBA is not necessary. We expect participants to have at least tried out the chart functions of Excel.
Excel 2013 is used in the seminar. Participants with Excel 2007 and 2010 will have no trouble understanding the steps. The training examples used in the course are provided in XLSX format for Excel versions 2007, 2010, and 2013.
Each participant should bring his or her own Windows-based notebook in which USB-stick access is not restricted. A mouse is recommended.

Program of the seminar

08:30 - 09:00 Registration
09:00 Overview of the HICHERT®SUCCESS concept
Successful business communication is based on binding rules: Say, Unify, Condense, Check, Express, Simplify, Structure
•  Convey messages, use visualization
•  Omit decorative and distracting elements
•  Design charts and tables with standardized meaning
•  Condense information, display scales accurately

10:30 Column chart with variance display, part 1
Excel charts need to be formatted and configured properly in order to comply with the SUCCESS-rules. Further features are implemented using some special tricks and techniques.
•   Format standard charts according to the SUCCESS rules
•   Position user-defined data labels and legends
•   Display reference and separator lines
•   Synchronize scales of groups of charts


12:00 - 13:00 Lunch break

13:00 Column chart with variance display, part 2
The methods are demonstrated and practiced using a column chart, as one of the most frequently used types. All techniques can also be universally applied to other chart types, though.
•   Control chart elements through formula calculations
•   Build a variance display with red/green columns
•   Combine two charts in one using primary/secondary axes
•   Switch column pattern for ACT/FC automatically

14:15 Combined charts, tables with variance display, PPT linking
Once created, chart templates can be used multiple times with little effort. They can even be combined to build more sophisticated multi-tier charts. All templates can be integrated into page layouts and linked to PowerPoint slides easily.
•   Create combined charts by overlaying multiple templates
•   Integrate charts into page layouts and link with PowerPoint slides
•   Learn easy-to-use methods to enhance tables with red/green variance bars

16:00 Questions and answers

16.30 End of seminar

Language
The training will be conducted in English.

Date and place of the seminar:
28.02.2017. (Tuesday), Zagreb

About the trainer

Markus Wolff, Dipl.-Betriebswirt (FH), MBA, received a degree in business administration from the University of Applied Sciences in Eberswalde and a master degree from the Danube University in Krems. He is co-founder and CEO of chartisan GmbH in Potsdam, a service provider for data visualization. Previously he worked as a group controller for Saubermacher AG in Graz and as CEO of HI-CHART GmbH in Berlin. Since 2007 he is teaching seminars for HICHERT+FAISST and Controller Akademie. In 2010 he became one of the first HICHERT®IBCS Certified Consultants (HCC). Today, as a service provider, he delivers ready-to-use implementations and, as a consultant and trainer, he supports the conception and implementation of reporting solutions, including related software tools.

Application deadline:
Thursday, 23.02.2017.

Course fees
  1.990,00 HRK + PDV/260,50 EUR + VAT

Bank: Privredna banka Zagreb, Račkoga 6, Zagreb, Croatia
IBAN: HR6023400091110356112
SWIFT CODE: PBZGHR2X

Discounts:
•   5% - members of Klub kontrolera and participants of our held trainings (unit price 1.890,50 HRK + PDV / 247,45 EUR + VAT)
•   10% - 2 participants from the same company (unit price 1.791,00 HRK + PDV /  234,42 EUR + VAT)
•   15% - 3 or more participants from the same company (unit price 1.691,50 HRK + PDV /  221,34 EUR + VAT)

Pošalji upit za program