Course Name

Excel Charts

Overview

This course targets all Excel users who need to work with graphs/charts.

Course Objectives

► Creating Charts
♦ Understanding The Charting Process
♦ Choosing The Chart Type
♦ Creating A New Chart
♦ Working With An Embedded Chart
♦ Resizing A Chart
♦ Dragging A Chart
♦ Printing An Embedded Chart
♦ Creating A Chart Sheet
♦ Changing The Chart Type
♦ Changing The Chart Layout
♦ Changing The Chart Style
♦ Printing A Chart Sheet
♦ Embedding A Chart Into A Worksheet
♦ Deleting A Chart

► Common Chart Types
♦ Understanding Common Chart Types
♦ Creating A Column Chart
♦ Creating A Line Chart
♦ Creating A Pie Chart
♦ Creating A Bar Chart
♦ Creating An Area Chart
♦ Creating A Scatter Chart
♦ Other Chart Types

► Charting Techniques
♦ Understanding Chart Layout Elements
♦ Adding A Chart Title
♦ Adding Axes Titles
♦ Positioning The Legend
♦ Showing Data Labels
♦ Showing A Data Table
♦ Modifying The Axes
♦ Showing Gridlines
♦ Formatting The Plot Area
♦ Showing The Plot Area
♦ Adding A Trendline
♦ Adding Error Bars
♦ Adding A Text Box To A Chart
♦ Drawing Shapes In A Chart

► Chart Object Formatting
♦ Understanding Chart Object Formatting
♦ Selecting Chart Elements
♦ Using Shape Styles To Format Objects
♦ Changing Column Colour
♦ Changing Pie Slice Colour
♦ Changing Bar Colours
♦ Changing Chart Line Colours
♦ Using Shape Effects
♦ Filling The Chart Area And The Plot Area
♦ Filling The Background
♦ The Format Dialog Box
♦ Using The Format Dialog Box
♦ Using Themes

Target Group

This course targets all Excel users who need to work with graphs/charts.

Minimum Delegates

6 Delegates

Maximum Delegates

10 Delegates

Accreditation

No

Number of Days

4 Hours

Learning Approach

Practical - Computers will be provided should learners not have own laptops.

Cost per Delegate

R500

Send an Enquiry Form

Click here to close Window