Excel Charts & Powerpoint Presentation Intermediate to Advanced

We Offer Online Individual & On Site ( In – House / Group ) Training Contact Us for Details

We Offer Online Individual & On Site ( In – House / Group ) Training Contact Us for Details

Training Duration : 2 Days

Excel Dashboard

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 BENEFICIT
Save significant time in creating and managing presentations</pDiscover 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 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. DINAMIC FORMATING 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 POWER POINT FOR PRESENTATION PURPOSE

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