Microsoft

Word, Excel, and PowerPoint

Training Outline

Atrium Learning Center

Library Building--18
MS Word 2016 MS Excel 2016
Creating Documents Creating Worksheets
 Starting a New Word Document  Starting Excel, Navigating Excel, Naming, & Saving a
 Setting Margins Workbook
 Aligning Paragraphs  Entering Text, Using AutoComplete, & Using the Name Box
 Setting Line Spacing
to Select a Cell
 Indenting Text
 Setting Space Before & After Paragraphs  Entering Numbers
 Formatting the Spacing & First-Page Information  Entering Data by Range
 Selecting and Moving Text  Editing Values in a Worksheet
 Inserting Symbols and Special Characters  Copying & Pasting by Using the Paste Options Gallery
 Inserting Page Breaks  Using Find and Replace
 Inserting a Text Box  Using Auto Fill & Keyboard Shortcuts
 Inserting Text from Another Document
 Aligning Text & Adjusting the Size of Columns
 Finding and Replacing Text
 Using the Navigation Pane to Go to a Specific Page  Adjusting Column Widths & Wrapping Text
 Adding Document Properties, Previewing & Printing a  Using Merge & Center & Applying Cell Styles
Document  Moving a Column
Chapter Quiz*  Formatting Financial Numbers
 Formatting Cells with the Percent Style
Applying Special Text, Paragraph, and Document Formats  Checking Spelling in a Worksheet
 Formatting Text Using Text Effects  Printing a Section of a Worksheet
 Adding a File Name to the Footer  Printing All the Worksheets in a Workbook
 Formatting the Page Numbering & Paragraph Indents Chapter Quiz*
 Creating a Bulleted List
 Creating a Numbered List Functions, Formatting, and Managing Worksheets
 Customizing Bullets  Inserting a Worksheet
 Creating a Multilevel List with Bullets  Using the Quick Analysis Tool
 Setting Tab Stops  Using Arithmetic Operators
 Modifying Tab Stops  Calculating Values
 Adding Borders & Shading to a Paragraph  Copying Formulas Containing Absolute Cell
 Inserting the Current Date & Creating a Cover Letter  Inserting & Deleting Rows & Columns
 Checking for Spelling & Grammar Errors  Constructing a Formula & Using the SUM Function
 Using the Thesaurus  Using the SUM & AVERAGE Functions
 Changing One Column of Text to Two Columns  Using the MIN & MAX Functions
 Applying Styles to Paragraphs  Using the NOW Function to display a System Date
 Changing the Document Theme  Copying a Formula by Using the Fill Handle
 Clearing Existing Formats  Moving Data & Resolving a # # # # # Error Message
Chapter Quiz*  Clearing Cell Contents & Formats
 Rotating Text
Graphics, Tables, and Finalizing a Document  Creating a Footer & Centering a Worksheet
 Inserting Pictures  Navigating, Renaming, & Changing the Tab Color of
 Wrapping Text Around a Picture Using Layout Options Worksheets
 Resizing Pictures & Using Live Layout  Changing Page Orientation & Displaying, Printing, & Hiding
 Positioning a Picture Formulas
 Applying Picture Styles Chapter Quiz*
 Applying Artistic Effects
 Adding a Page Border Charting Data & Finalizing a Workbook
 Inserting a SmartArt Graphic  Creating an Excel Table
 Sizing & Formatting a SmartArt Graphic  Sorting an Excel Table
 Creating a Table  Charting Data & Using Recommended Charts to Select &
 Typing Text in a Table Insert a Column Chart
 Creating Bulleted Lists in a Table  Using the Chart Tools to Set Chart Layouts & Chart Styles
 Using One-Click Row/Column Insertion  Creating a Pie Chart in a Chart Sheet
 Merging Table Cells  Creating & Formatting Sparklines
 Modifying Table Borders  Inserting Column Sparklines
 Inserting a Table into a Document & Table Style  Changing Theme Colors
 Addressing & Printing an Envelope  Freezing & Unfreezing Panes
Chapter Quiz*  Entering & Formatting Dates
 Preparing and Printing a Workbook with a Chart Sheet
◄MS Word Exam-Passing score is 70% or higher►  Printing titles & Scaling to Fit
 Adding Document Properties & Printing a Workbook
Chapter Quiz*

◄MS Excel Exam-Passing score is 70% or higher►

*Denotes students must score 85% or higher on quizzes before moving to the next chapter
PowerPoint 2016 Enhancing a Presentation with Animation, Tables, & Charts
 Changing the Theme Colors
Getting Started with PowerPoint  Changing Theme Fonts
 Creating a New Presentation  Applying a Background Style
 Hiding Background Graphics
 Entering Presentation Text
 Applying a Background Fill Color to a Slide
 Applying a Presentation Theme  Applying a Background Texture
 Inserting a New Slide  Applying a Picture to the Slide Background
 Increasing and Decreasing List Levels  Resetting a Slide Background
 Adding Speaker Notes to a Presentation  Applying Animation Entrance Effects and
 Displaying and Editing Slides in the  Reordering Animation
 Setting Animation Start Options
 Inserting a Picture from a File
 Setting Animation Duration and Delay
 Applying a Style to a Picture
 Using Animation Painter and Removing An
 Viewing a Slide Show  Inserting a Video and Using Media Controls
 Using Presenter View  Sizing and Aligning a Vide
 Inserting Headers and Footers on Slide  Changing the Style and Shape of a Video
 Inserting Slide Numbers on Slides  rimming and Compressing a Video and Set
 Printing Presentation Handouts  Creating a Table
 Inserting Rows and Columns in a Table
 Printing Speaker Notes
 Sizing a Table
 Changing Slide Size  Distributing and Aligning Table Text
 Displaying and Editing the Presentation  Applying and Modifying a Table Style
 Deleting and Moving a Slide  Applying Table Effects and Font Formatting
 Finding and Replacing Text  Inserting a Column Chart
 Applying a Theme Variant  Entering Chart Data
 Changing Fonts and Font Sizes  Applying a Chart Style and Modifying Chart Elements
 Creating a Line Chart and Deleting Char
 Changing Font Styles and Font Colors
 Formatting a Line Chart
 Aligning Text  Animating a Chart
 Changing Line Spacing
 Changing the Slide Layout
Chapter Quiz*
 Deleting Slides in Slide Sorter View
 Moving a Single Slide in Slide Sorter View
 Applying Slide Transitions to a Presentation ◄MS PowerPoint Exam-Passing score is 70% or higher►
 Setting Slide Transition Timing Options
 Displaying a Presentation in Reading
Chapter Quiz*

Formatting PowerPoint Presentations

 Selecting Placeholder Text
 Changing a Bulleted List to a Numbered List
 Changing the Shape and Color of a Bulleted List Symbol
 Removing a Bullet Symbol from a Bullet
 Inserting Pictures in a Content Placeholder
 Inserting Pictures in Any Location on a
 Sizing a Picture
 Using Smart Guides and the Ruler to Position a Picture
 Cropping a Picture
 Using Crop to Shape to Change the Shape
 Inserting a Text Box
 Aiding Text to Shapes
 Applying Shape Fills and Outlines
 Using the Eyedropper to Change Color
 Applying Shape Styles
 Applying Shape and Picture Effects
 Aligning and Distributing Objects Relative to the Slide
 Grouping Objects
 Removing the Background from a Picture
 Inserting and Aligning a WordArt Object
 Applying WordArt Styles to Existing Text
 Changing the Text Fill and Text Outline
 Adding Text Effects to a WordArt
 Creating a SmartArt Graphic from Bullet
 Inserting a SmartArt Graphic Using a Content Layout
 Inserting Pictures and Text in a SmartArt
 Changing the Size and Shape of SmartArt
 Changing the SmartArt Layout
 Changing the Color and Style of a Smart
Chapter Quiz*
*Denotes students must score 85% or higher on quizzes before moving to the next chapter