Description
This module shows how to transform a simple graph into an advanced graphical visualization of complex data using formulas and using graph options.
In addition to the commonly used simple graph types, we also cover the less frequently used types and the newer graph types.
Audience
This course is intended for people who already know how to work with charts in MS Excel and want to delve into creating advanced graphs.
Methods
Classic training with attention to individual guidance and the ability to ask questions. On the basis of exercises, the student can immediately put the possibilities of the program into practice.
Contents
- Creating a graph (repetition)
- Graphs that can be applied at any time
- Column, Bar, Line, Area, Radar, Ring (Doughnut)
- Combi charts
- Transform a simple graph into a more detailed graph
- Via formulas in the basis of the graph
- Via chart options
- Graphs whose basis must meet certain conditions
- Circle (Pie)
- Spread (XY (Scatter)) & Bubble (Bubble)
- High/Low/Lock (Stock)
- Surface
- Map (Map)
- The latest chart types
- Treemap & Sunburst (Sunburst)
- Histogram
- Box & Whisker
- Waterfall
- Funnel
- Create interactive charts
Certification
Participation certificate: participants receive a certificate that they have completed this training at the end of the training.