Mastering Presentation Techniques using Excel Charts & Powerpoint

Course Introduction

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.

  • Anyone wanting to understand the know-hows of the human element of  presentation skills utilizing Microsoft Excel charts within PowerPoint.

Participants will have a good understanding as to when to use the different types of charts in their presentation and how best to link it within PowerPoint automatically; besides learning the skills required in making a formal presentation and the techniques involved to overcome fear of public speaking.

Participants will be better at presentation techniques and able to have a better understanding of audiences needs and wants in delivering a presentation. They will also master the use of PowerPoint specifically for presentation to a range of audiences.

• 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.

• Presentation/lecture/data sharing
• Case study
• Personal interaction
• Practical Assessments
• Digital statistic and recommendation

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

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

• 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

• 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

• 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

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

Case Study and exercises given