Day 1: Excel 2016

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

Day 2: Word 2016

Lesson 1: Formatting Text & Paragraphs

Setting Tab Stops Organizing List Information

Lesson 2: Formatting Documents to Print

Using Headers & Footers Proofing Preparing for Print |

Lesson 3: Using Tables in Word 16

Inserting Tables Modifying Tables Sorting Lists

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

Day 3: PowerPoint 2016

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