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
Excel Charts & Powerpoint Presentation Intermediate to Advanced
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
Contact us : https://www.malaysia-training.com/contact-us