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

• has data in Excel to analyse
• has to present Excel-based data to an audience
• needs to develop PowerPoint presentations

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 ClipArt

Adding a Sound Clip:

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