Course Excel Charts

Working with Objects

• Explanation of the concept of an object and its position in Office programs Inserting and creating objects in Excel Changing the size, format and other settings of different objects

Creating a Chart

• Description of different chart styles Explanation of the suitability of using different chart types and subtypes Preparing a table for chart creation Quick chart layout Creating sparklines (cell mini-charts) as cell content Creating different types of charts in Excel (column, line, pie, bar, area, scatter, map, radar, histogram, waterfall, funnel, etc.) Combo chart (using different chart types for individual series) Creating charts from non-continuous areas, editing source data Creating a chart from a named table

Editing a Chart

• Chart design and formatting, editing chart appearance, setting themes and custom color schemes, i.e. editing charts (colors, size, font, etc.) Use and formatting of chart elements (chart axes, axis titles, chart title, data labels, data table, error bars, trendline, gridlines, legend, up/down bars, etc.) Filtering data in a chart Chart placement (floating object, separate sheet) Primary and secondary chart axis Practical advice when creating charts Creating chart templates and their subsequent use, template management Pivot chart

Exporting Charts

• Printing charts Using charts in Word or PowerPoint Linking charts

Discussion and Further Learning Options After Completing the Training