Description
Thanks to graphics, numbers turn into images! Nothing better to increase the readability of your numerical data, illustrate a trend or make a comparison. However, creating a successful graph cannot be improvised. The method proposed in this training allows you to build effective and impactful graphs in Excel 2016. Also learn to master the creation of elaborate graphs and discover the new graphs which considerably enrich the 2016 version of Excel.
Who is this training for ?
For whom ?Anyone who has to visually represent encrypted data in Excel 2016.
Prerequisites
Training objectives
Training program
- Creating a successful graphic: the steps to follow Define the message to be transmitted. Deduce the most effective graphic representation.
- Build the graph.
- Format the graph to strengthen its impact and make it easier to understand.
- Customize a chart to enhance its impact
- Reminder on building simple graphs.
- Adapt the scale of the axes.
- Modify the order of plotting the series.
- Customize legend, titles.
- Insert free text, images.
- Ignore or interpolate missing data.
- Display a trendline.
- Automate the update of a chart by associating it with a dynamic data range.
- Build elaborate charts
- Combine multiple chart types into one.
- Create a semicircle, gauge, or radar chart.
- Draw bubble matrices.
- Draw a pyramid of ages.
- Exploit the new graphics
- Excel 0 Discover the new graphs and identify in which context to use them: Compartments.
- Sunbeams.
- Funnel.
- Graph cascade.
- Pareto chart.
- Geographic maps.
