Course Details
Excel Graphs
Dates will be avalible shortly
Professional Development
Computer Skills / Applications
Victoria University Professional and Executive Development
Level 2, Rutherford House, 23 Lambton Quay, Wellington City
Half Day
9:00am - 1.00pm
9:00am - 1.00pm
$258.75
Graphs equip you with ways to analyse, report and present data professionally. This course looks at this tool and provides you with the skills to use it with your data.
Who Should Attend:
This course is suitable for people who are experienced in using Excel spreadsheets and want to produce Graphs. It assumes you have good/intermediate Excel skills (for example, you should be confident sorting and filtering data, and creating formulas).
Please note - we are currently using Office 2007 software
Course Objectives:
* Understand the use of Graphs to analyse and present data Create and format Graphs from data
* Amend graphs, add data and change the type of graph.
Course Outline:
Getting Started with Graphs
* Quick Graphs
* Types of Graphs
* Creating a Graph using the Wizard
* Parts of a Graph
Customising the Graph
* Graph Types
* Series in Rows vs Series in Columns
* Graph Titles and Axis Labels
* Graph Legend
* Including a Data Table
* Data Labels
* Adding and Removing Data Series
* Changing the Order of Series
Pie Graphs
* Key Differences
* Creating a Pie Graph
* Exploding a Pie Graph
* Pie-of-Pie and Bar-of-Pie Graphs
Graph Size and Location
* Changing the Graph Location
* Resizing a Graph
* Auto Scale
* Graph Object Positioning Behaviour
* Resizing the Plot Area
Other Graph Features
* Formatting a Data Series
* Trend Lines
* Dynamic Graph Titles
* Customising the Axes
* Dual Axes
* Combination Graphs
Course Format:
This hands-on 1/2 day course is in our Computer Training Suite. Participants will be encouraged to practice and apply the skills covered in the session. You will receive course materials to take away. There will be a maximum of 12 participants. The course is designed to allow for questions and individual focus with participants.
Who Should Attend:
This course is suitable for people who are experienced in using Excel spreadsheets and want to produce Graphs. It assumes you have good/intermediate Excel skills (for example, you should be confident sorting and filtering data, and creating formulas).
Please note - we are currently using Office 2007 software
Course Objectives:
* Understand the use of Graphs to analyse and present data Create and format Graphs from data
* Amend graphs, add data and change the type of graph.
Course Outline:
Getting Started with Graphs
* Quick Graphs
* Types of Graphs
* Creating a Graph using the Wizard
* Parts of a Graph
Customising the Graph
* Graph Types
* Series in Rows vs Series in Columns
* Graph Titles and Axis Labels
* Graph Legend
* Including a Data Table
* Data Labels
* Adding and Removing Data Series
* Changing the Order of Series
Pie Graphs
* Key Differences
* Creating a Pie Graph
* Exploding a Pie Graph
* Pie-of-Pie and Bar-of-Pie Graphs
Graph Size and Location
* Changing the Graph Location
* Resizing a Graph
* Auto Scale
* Graph Object Positioning Behaviour
* Resizing the Plot Area
Other Graph Features
* Formatting a Data Series
* Trend Lines
* Dynamic Graph Titles
* Customising the Axes
* Dual Axes
* Combination Graphs
Course Format:
This hands-on 1/2 day course is in our Computer Training Suite. Participants will be encouraged to practice and apply the skills covered in the session. You will receive course materials to take away. There will be a maximum of 12 participants. The course is designed to allow for questions and individual focus with participants.
Edwin Hermann