Hichert Partner Logo

Deutsch (DE-CH-AT)

sEMINARS > topics > Charts with Excel

Topics
SUCCESS

Certification

Charts with Excel Seminar

Charts with Excel Workshop

 

Excel Templates

HI-CHART Templates '12

HI-CHART Templates '10

HI-CHART Templates '08

HI-CHART Templates '07

 

Dates

Organization  

Registration

 

Sophisticated visualizations can be created using Excel, even without additional programming. Two consecutive events with the aim of creating sophisticated templates.

We discuss the 97/2003 and 2007/10 versions the same seminar. 

 

Download the German program in PDF format (0,2 MB) 

Register here.

 
   
  Creating Sophisticated Charts with Excel
   

SEMINAR

The first day of the seminar begins with an overview of the design rules of SUCCESS. Afterwards, we present the basics of Excel charts and then show step-by-step the main Tips and Tricks using a complex stacked chart.

On the second day of the seminar, the Tips and Tricks learned for the example stacked chart are then applied to bar charts and the transition from a chart to a report page is explained and implemented.

The third day of the seminar concentrates on exercises pertaining to waterfall, line, scatter, and bubble charts.
   

WORKSHOP

The first day of the workshop concentrates on multi, combination, and table charts.

On the second day of the workshop, focus is on implementing sophisticated exhibits and report pages using practical examples.

The third day of the workshop is concerned with high-definition charts, the ROTATE function, and other special functions. 

 

We present the same material for both "Excel up to 2003" as well as for "Excel 2007..2010." Since the differences in operation (and unfortunately for many of our Tricks) are so substantial, we can only present the material in separate seminars.
   
 

SPEAKERS

Holger Gerths, Dipl-Ing., is the 'inventor' of our Excel Tricks and advises many companies on Excel charts and other software issues.

Markus Wolff, Dipl.-Bw. (FH), MBA, is the partner for projects in Austria. He works as a corporate controller in Graz, prior to that he was an instructor in adult education.

Jörg Knuth, Dipl. Ing., has worked for over 14 years as a consultant and trainer, in particular involving Microsoft products.
   
 

SEMINAR OBJECTIVE

The main objective of this three-day seminar is to enable participants to design even sophisticated business charts using Excel. The intent is to show that it is possible to fulfill virtually any design requirement by using standard Excel functions creatively and without programming. The use of self-generated charts should not only help achieve a higher standard of quality, reusing them should also save time. This is not a standard Excel seminar in which Excel functions are explained. Options are presented instead for creating new types of visualizations using familiar functions.

During this three-day seminar, we show example reports illustrating the entire path from the problem to the solution. We first provide a brief overview of the SUCCESS Rules, upon which the example charts proposed here are based. Afterwards, we present a concept for improving the example report and then implement it step by step using Excel. The result is a professionally designed report page that can be updated dynamically. With the experience gained here, participants should then be able to design other sophisticated charts according to their own ideas.
   
 

WHO SHOULD PARTIPCATE?
These events are geared towards all professionals involved in creating of sophisticated business charts. Many participants come from the fields of finance and controlling, marketing, sales, production and project management, or are staff responsible for creating reports and presentations.
   

 

IMPORTANT PREREQUISITES

Many participants have attended the SUCCESS Seminar prior to these events – or have at least become acquainted with the HICHERT®SUCCESS Rules such as clear messages, uniform design, and the proper scaling of charts.
A basic understanding of the practical application of Excel is required to attend the seminar, knowledge of VBA programming is not necessary, however.
Under www.tutorial.hichert.com (in German) you will find a summary of the Excel functions with which you need to be familiar. We assume that participants will have at least tried out the chart functions in Excel. You will work with Excel Version 2010 at the events. Participants with the 2007 version will have no trouble understanding the steps, as the differences between Excel 2010 and 2007 are minor. Participants using older Excel installations up to Version 2003 will also have no trouble understanding these steps. If necessary, the speaker will point out differences to older versions of Excel and demonstrate them with Excel 2003. The examples used in the course are in both the old .XLS format and the new .XLSX format.
The examples are basically designed so that they work in all Excel versions using the same tricks. Each participant should bring his or her own Windows-based notebook in which the installation of add-ins is not restricted.
   
  PPARTICIPATION FEES
The fee to participate in the three-day seminar is EUR 2,700, in the three-day workshop EUR 3,000, each plus VAT. If several persons from one company register for the same date, the second person and each additional person qualify for a discount in the amount of EUR 300.