Excel Charts & Powerpoint Presentation Intermediate to Advanced

Mastering Presentation Techniques Using Microsoft Excel Charts & Powerpoint

Mastering Presentation Technique Using Excel

Target Audience: Anyone who uses Excel on regular basis to prepare various
aspects of charts for presentation purposes.

About the Course:

Innovative Charting Techniques
PowerPoint charts can be as simple or as complex as you like. Learn to create a basic chart right inside PowerPoint using Microsoft Graph, or create a full featured chart using Microsoft Excel and insert it into your presentation. Choose from common chart types such as column, bar, line, and pie charts. Try something out of the ordinary such as a doughnut or radar chart; or create a unique chart type of your own. While PowerPoint charts are pre-formatted using design template, this course will show how you can change nearly every aspect of a chart, its color, text, labels and much more.

Training Benefits:

• Save significant time in creating and managing presentations
• Discover new PowerPoint techniques that can help you achieve your objectives.
• Master Excel’s user defined custom charts and types
• Modify and existing chart to create a more dynamic chart
• Manipulate and present your data to better serve your audience
• Enhance a chart by adding external objects to it
• Collaborate with others by sharing presentations and tracking changes
• Apply dozens of shortcuts and techniques in your everyday work and more.

Training / Course Outline:

1. INTRODUCTION TO EXCEL CHARTS

What is a Chart?
Significance of Charts
How Excel Handles Charts
Parts of a Chart
Creating Charts
Basic Chart Modifications

2. UNDERSTANDING CHART TYPES

Conveying a Message with a Chart
Choosing the right Chart Type
Analyzing various types of Charts
Importance of looking good

3. CHANGING CHART ELEMENTS

Selecting chart elements
Modifying chart properties using the following:
Format dialog box
Modifying chart area
Modifying plot area
Working with chart titles
Working with legends
Changing chart gridlines
Modifying axes
Displaying values within chart elements

4. FINE TUNING THE CHART

Modifying one chart to another within the same chart area
When to add secondary axis
How to handle large numbers against very small numbers
When and how to reverse a data category
Converting horizontal axis values from negative to positive completely
Moving vertical axis from middle to left when dealing with positive and negative values
Highlighting lower values with different colors
Reducing gap width of columns and bars

5. DYNAMIC FORMATTING WITH THE FOLLOWING TYPES OF CHARTS:

Bar
Radar
Pie (various aspects)
Surface
Column (images within columns)
Scatter (forecasting future values)
Line
Doughnut
Bubble (showing market share)
Stock (displaying high-low-close values)
Gantt (for project planning)
Thermometer
Histogram and comparative histogram
Combining multiple charts
and many others

6. INCORPORATING EXCEL CHARTS WITH POWERPOINT FOR PRESENTATION PURPOSES

PowerPoint Lesson 1: Presentation Management
Switching the Design Theme
Duplicating and Moving Slides
Moving and Re-sizing Text Placeholders
Copying Placeholder Styles
Changing the Slide Layout
Copying Slides between Presentations

PowerPoint Lesson 2: Working with graphics
Add Graphics to a Presentation
Modify a Graphic
Look at Drawing Objects
Importing a Picture

PowerPoint Lesson 3: Working with charts
Working with Chart Elements
Create a Chart
Importing a Chart
Modify a Chart

PowerPoint Lesson 4: Building the slide show
Examine Transitions and Builds
Add Transitions and Builds
Use Multimedia Elements
Creating Hyperlink to other Slides and Files

PowerPoint Lesson 5: Working with Sounds and Movies
Introduction to Sounds and Movies
Incorporating Sounds to Slides

PowerPoint Lesson 6: Presenting the Slide Show
Prepare to Present
Set up a Slide Show
Prepare the Setting
Create Handouts