Microsoft Excel, Word, PowerPoint Combined 3 Day Training With CoPilot

Section 1: Formulas and Functions 

Entering Formulas
Excel Arithmetic Operators
Using AutoFill Options
Commonly Used Functions

Section 2: Organizing Worksheet and Table Data

Create and Modify Tables
Sort and Filtering Data
Get Summary Information in a Table

Section 3: Working with Charts

Summarizing Data Using Charts
Customizing Chart Data
Format Chart Legend and Titles
Creating a Pie Chart

Section 4: Working with Graphics

Add Pictures into a Worksheet
Customize Pictures and Objects
Add Drawing Objects
Add SmartArt

Section 5: Managing Large Workbook

Manage Large Workbook Printing
Worksheets Setting
Page Setup Options

Section 6: Customizing & Enhancing Workbooks

Customizing Excel to Your Work
Creating Hyperlinks
Customizing Quick Access Toolbar

Inserting Pictures Manipulating Images Wrapping Text around a Picture

Section 5: Creating Mass Mailing Documents  

How do I merge?
Setting Rules for Merging
Creating Simple Mailing Documents

Section 6: Referencing Information

Creating an Index Creating a Table of Contents

Section 1: Working With Text 

Using an Outline Adding Text Using Bullets and Numbering Formatting Text & Paragraphs Using Text Boxes Setting Tabs

Section 2: Adding Multimedia Elements

Using Multimedia Elements Working With Pictures Applying Styles & Effects Modifying Hyperlinks Working With SmartArt

Section 3: Enhancing Presentations

Adding Audio & Video Media
Using Animation
Managing Multiple Transitions
Changing Animation Order
Using Slide Transitions

Section 4:  Preparing The Slide Show

Reviewing The Presentation Customizing the Presentation Proofing the Presentation Setting up a Slide Show Using Presentation Tools
Using Presenter View Rehearsing a Presentation Presenting The Slide Show