|
Course overview
The aim of this module is to enable you to create charts to visually represent
data within your Excel spreadsheets.
Who should attend
Delegates should feel confident in the topics covered in the Microsoft
Excel Creating and Editing module.
Learning outcomes
At the end of the module, you will be able to:
• Create charts within Excel workbooks using the chart wizard to
build charts based on selected data ranges, to investigate the most appropriate
style to communicate the data
•
Edit charts changing style, options, size and location to display the
data in the most effective manner
•
Design 3D charts showing elevation, rotation and perspective techniques
presenting information to make an impact on the viewer
Course contents
Creating charts
Understanding charts
Creating a chart based on a continuous range
Creating a chart based on a non-continuous range
Using the Chart Wizard to create a chart
Understanding the best chart types to use
Editing a chart
Changing the chart type, e.g. column, pie, bubble charts
Changing the chart data series
Adding chart and axes titles
Applying gridlines
Re-positioning the legend
Applying data labels
Adding a data table
Changing the chart location, e.g. creating a chart on a separate worksheet
Resizing the chart, e.g. if a chart is on same worksheet as the data
Formatting the chart, e.g. font, colour, fill effects
Changing the original data values to update the chart
Creating 3-D effects
Changing the elevation, rotation and perspective of a 3D chart
Creating exploding pie charts
Related courses
Creating
and Editing
Worksheets
and Workbooks
Basic Formulas
Linking
Spreadsheets and Formulas
Advanced Formulas
Sorting
and Filtering Data Lists
Summarising
Data Lists
Templates
and Macros
PivotTable
and PivotChart Reports
Home
© Alpha Training | Telephone
020 8658 6994 | Email admin@alphatraining.com
|
