Professional Presentations with Excel & PowerPoint

Description:

This course will demonstrate how to prepare presentations and reports developed using Excel and PowerPoint.

Prerequisites

This course is aimed at experienced desktop users who are already familiar with basic functionality of Excel and PowerPoint.

Target Audience:

• Anyone who has data in Excel to analyze
• Anyone who has to present Excel-based data to an audience
• Anyone who needs to develop PowerPoint presentations

Course Content:

Introduction:

• The storyboard for the presentation
• Target audience: Establishing the Brief
• Making the presentation relevant – content and structure
• Using an appropriate structure to meet your objectives

Excel:

Working with Charts

Creating a Chart
Formatting a Chart
Modifying Charts with the Layout Ribbon
Manipulating a Chart
Enhancing a Chart with Shapes and Graphics

Working with Charts, Part 2

Changing the Type of Chart
Changing the Source Data
Working with the Chart Axis and Data Series
Saving a Chart as a Template

Getting the Most From Your Data

Getting The Most From Your Data
Using Automatic Outlining
Displaying and Collapsing Levels
Grouping Data Manually
Creating Subtotals

PivotTables

What is a PivotTable?
Creating a PivotTable
Creating a PivotTable Frame
Specifying PivotTable Data
Rearranging PivotTable Data

More About PivotTables

Modifying PivotTable Calculations
Formatting a PivotTable
Refreshing a PivotTable
Charting a PivotTable
Creating a PivotTable Based on External Data

Reporting tools in Excel and best practice for them

PowerPoint:

Creating and Working with Tables:

Inserting a Table
Drawing a Table
Using the Table Tools Ribbon
Working with Cells
Inserting an Excel Table
The Insert Excel Table Ribbons
 

Formatting a Table:

Setting Style Options
Setting Table Styles
Changing the Shape of a Fill
Applying Borders
Adding Effects
Drawing Borders
Adding and Formatting WordArt

Working with Charts and Graphs:

Creating and Linking Worksheet Charts and Graphs
Chart Tools Ribbon
Incorporating Titles and Data
Legends and Labels

Working with SmartArt:

Creating SmartArt
SmartArt Tools
Resizing Diagrams
Inserting SmartArt From a Slide

Customizing Your Diagrams:

Inserting a Symbol or Special Character
Adding and Editing Shapes
Changing Diagram Types and Design Schemes
Incorporating Text

Working with Text Boxes:

The Drawing Tools Ribbon

ClipArt:

Searching for ClipArt 
Inserting ClipArt 
Formatting Clip Art

Adding a Sound Clip:

Insert Sound Clip from Clip Organizer or File 
Sound Tools 
Recording a Sound