Microsoft Excel, Word, PowerPoint 2016 Combined 3 Day Training

Section 1: Formulas and Functions  Entering Formulas Excel Arithmetic Operators Using AutoFill Options Using Commonly Used Functions

Section 2: Organizing Worksheet and Table Data
Create and Modify Tables Sorting and Filtering Data in a Table Getting 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 Adding Pictures into a Worksheet Customizing Pictures and Objects Adding Drawing Objects Adding SmartArt into a Worksheet

Section 5: Managing Large Workbook Managing Large Workbooks Printing Worksheets Setting Page Setup Options

Section 6: Customizing & Enhancing Workbooks
Customizing Excel to Your Work Creating Hyperlinks Customizing Quick Access Toolbar

Lesson 4: Working with Illustrations 
Inserting Pictures Manipulating Images Wrapping Text around a Picture

Lesson 5: Creating Mass Mailing Documents  
How do I merge? Setting Rules for Merging Creating Simple Mailing Documents

Lesson 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