Graphing for Impact using Excel 2007 - Intermediate
Course Information
This one day modular course will enable you to use graphs for added impact when producing reports. The phrase “a picture says a thousand words” is never more true than when you see a well presented graph showing how your sales figures or profits have risen (or dropped) over the last quarter.
Once created a graph can be incorporated into a monthly or quarterly report for the Board, if you are delivering your good news through a presentation, incorporate a graph and use the special effects to your advantage: Highlight the areas where you’ve done well and downplay the ones where you haven’t.
This course will be delivered as 4 sessions each building on the work undertaken and the skills learned in the previous session.
Pre-requisites
Delegates should be able to use Microsoft Excel to the equivalent level of the Quasar Controlling & Improving Course and PowerPoint to the equivalent level of the Quasar Advanced Presentation Skills Course
Course Objectives
By the end of the course delegates will be able to:
- Create a graphs from data within an Excel Spreadsheet
- Modify the graphs
- Add titles, legends and data labels
- Format the graphs
- Place the graph into a Word document
- Link back to source data
- Text wrap
- Add wrap points
- Place the graph into a PowerPoint presentation
- Link back to source data
- Converting to a Spreadsheet object
- Identify key messages
- Add effects to their graph
What you will learn:
Lesson 1 – Graphs in Excel
Create a Graph
Modify a Graph
Titles, Label & Legends
Saving Chart Tempates
Chart Layout
Chart Design
Chart Format
Lesson 2 – Working with Word
Inserting a Graph
Link to source
Wrapping Text around the graph
Lesson 3 – Working with PowerPoint
Inserting a Graph
Link to source
Converting to a Spreadsheet Object
Lesson 4 – Slide show Effects
Key Messages
Adding Effects
