Microsoft

Microsoft Office 2016

(MS-Office-2016) / ISBN : 978-1-61691-966-5
Lessons
Lab
TestPrep
51 Reviews
Get A Free Trial

Skills You’ll Get

Microsoft Office Specialist 2016 exam validates the candidate's understanding of the Excel environment and the skill to deliver tasks without any help. The exam helps the candidates in demonstrating the correct application of the basic features of Excel 2016 by making and editing a workbook with multiple sheets, and they use a graphic element to represent data visually, for example, sales invoices, financial statements.
Download Course Outline

1

Taking Your First Steps with Word

  • Welcome to a New Word
  • The Office Look
  • Using the Word Start Screen
  • Touring the Word Screen
  • Exploring the File Tab
  • Undoing and Redoing Actions
  • Setting Word Options
  • Getting Help
  • Exiting Word
  • Summary
2

Diving Into Document Creation

  • Creating a Blank File
  • Creating a File from a Template
  • Opening an Existing File
  • Saving and File Formats
  • Compatibility with Previous Versions of Word
  • Choosing the Right Word View for the Task at Hand
  • Printing a Document
  • Achieving Attractive Documents with Styles
  • Constructing Documents Faster with Outlining
  • Cleaning Up Content with AutoCorrect
  • Summary
3

Working with Document Style and Content

  • Reviewing the Ways You Can Format Text in Word
  • Applying Character Formatting
  • Structuring Text with Paragraph Formatting
  • Setting Off Text with Paragraph Decoration
  • Using the Styles Group to Apply Styles
  • Checking Spelling and Grammar
  • Summary
4

Cutting, Copying, and Pasting Using the Clipboard

  • Adding and Moving Document Content with Cut, Copy, and Paste
  • Managing Pasting Options
  • Searching with the Navigation Pane
  • Starting an Advanced Find from the Ribbon
  • Replacing Text via the Ribbon
  • Summary
5

Cleaning Up with AutoCorrect and AutoFormat

  • Revisiting AutoCorrect
  • Using Quick Parts and Building Blocks
  • Inserting a Cover Page
  • Printing Envelopes and Labels Automatically
  • Printing an Envelope
  • Creating Labels
  • Creating PDF or XPS Output
  • Emailing a Document
  • Blogging
  • Summary
6

Building Tables, Charts, and SmartArt to Show Data and Process

  • Getting a Quick Start with Quick Tables
  • Table Basics
  • Working with Table Layout and Design
  • Inserting SmartArt
  • Summary
7

Adding Pictures and WordArt to Highlight Information

  • Inserting Pictures from a File
  • Adding an Online Picture
  • Pasting or Snapping a Picture
  • Manipulating Inserted Pictures (and Other Graphics)
  • Creating WordArt
  • Arranging Pictures and Other Objects
  • Summary
8

Adding Drop Caps, Text Boxes, Shapes, Symbols, and Equations

  • Adding a Drop Cap for Drama
  • Why Use Text Boxes?
  • Inserting a Text Box
  • Inserting a Shape
  • Adding a Basic Symbol
  • Inserting a Symbol from the Symbol Dialog Box
  • Summary
9

Setting Up the Document with Sections, Headers/Footers, and Columns

  • Changing Basic Page Setup
  • Section Formatting
  • Headers and Footers Overview
  • Header and Footer Navigation and Design
  • Adding Header and Footer Material
  • Considering the Need for Columns
  • Changing the Number of Columns
  • Special Column Formatting
  • Summary
10

Changing Other Page Features

  • Adding and Removing Page Borders
  • Formatting the Page Background
  • Applying Page Background Colors, Patterns, Textures, or Pictures
  • Adding a Watermark
  • Removing Watermarks and Page Backgrounds
  • Working More Effectively with Themes
  • Working with Bookmarks
  • Hyperlinks
  • Summary
11

Identifying the Contents and Terms in Your Document: TOCs, Captions, and Indexing

  • Automating Table of Contents Creation
  • Working with TOC Styles
  • Manually Creating a Table of Contents
  • Updating or Deleting a Table of Contents
  • Captions and Tables of Captioned Items
  • Indexing a Document
  • Footnotes and Endnotes Basics
  • Working with Footnote and Endnote Styling
  • Separators and Continuation
  • Making a Bibliography
  • Identifying the Sources for Your Bibliography
  • Editing Citations
  • Compiling the Citations into a Bibliography
  • Summary
12

Data Documents and Mail Merge

  • Previewing the Mail Merge Process
  • Data Considerations
  • Reviewing Data File Formats
  • Choosing the Data Document Type
  • Attaching a Data Source
  • Assembling a Merge Document
  • Mail Merge Pane/Wizard
  • Summary
13

Managing Document Security, Comments, and Tracked Changes

  • Protection Types
  • Comments and Tracked Changes
  • Accepting and Rejecting Changes
  • Summary
14

Customizing the Quick Access Toolbar and Ribbon

  • The QAT?
  • Changing the Buttons on the Quick Access Toolbar
  • The Customize Quick Access Toolbar Dialog Box
  • Making Changes to the Ribbon
  • Importing and Exporting Ribbon Customizations
  • Summary
15

Word Options and Settings

  • Opening Word Options
  • General
  • Display (and Printing)
  • Proofing
  • Save
  • Language
  • Advanced
  • Summary
16

Macros: Recording, Editing, and Using Them

  • Displaying Macro Tools and Creating a Macro
  • Managing Macros
  • Understanding More about Macro Security
  • Macro Storage
  • Automatic Macros
  • Visual Basic for Applications: Quick and Dirty Answers
  • Summary
A

Appendix A

  • Certification Objectives Map
18

Introducing Excel

  • Identifying What Excel Is Good For
  • Seeing What's New in Excel 2016
  • Understanding Workbooks and Worksheets
  • Moving Around a Worksheet
  • Using the Ribbon
  • Customizing the Ribbon
  • Creating Your First Excel Workbook
  • Customizing the Quick Access Toolbar
  • Summary
19

Entering and Editing Worksheet Data

  • Entering Text and Values into Your Worksheets
  • Entering Dates and Times into Your Worksheets
  • Modifying Cell Contents
  • Applying Number Formatting
  • Summary
20

Essential Worksheet Operations

  • Learning the Fundamentals of Excel Worksheets
  • Controlling the Worksheet View
  • Working with Rows and Columns
  • Summary
21

Working with Cells and Ranges

  • Understanding Cells and Ranges
  • Copying or Moving Ranges
  • Using Names to Work with Ranges
  • Adding Comments to Cells
  • Summary
22

Tables, Charts, and Sparklines

  • What Is a Table?
  • Creating a Table
  • Changing the Look of a Table
  • Working with Tables
  • What Is a Chart?
  • Understanding How Excel Handles Charts
  • Creating a Chart
  • Hands On: Creating and Customizing a Chart
  • Working with Charts
  • Understanding Chart Types
  • Working with Titles in a Chart
  • Working with a Legend
  • Working with Gridlines
  • Working with Data Series
  • Sparkline Types
  • Creating Sparklines
  • Customizing Sparklines
  • Summary
23

Worksheet Formatting

  • Getting to Know the Formatting Tools
  • Using Different Fonts to Format Your Worksheet
  • Changing Text Alignment
  • Using Colors and Shading
  • Adding Borders and Lines
  • Understanding Document Themes
  • About Number Formatting
  • Summary
24

Understanding Excel Files

  • Creating a New Workbook
  • Saving a Workbook
  • Password-Protecting a Workbook
  • Closing Workbooks
  • Safeguarding Your Work
  • Excel File Compatibility
  • Exploring Excel Templates
  • Summary
25

Printing and Protecting Your Work

  • Basic Printing
  • Changing Your Page View
  • Adjusting Common Page Setup Settings
  • Adding a Header or Footer to Your Reports
  • Types of Protection
  • Protecting a Worksheet
  • Protecting a Workbook
  • Exporting Data
  • Importing Data
  • Summary
26

Introducing Formulas and Functions

  • Understanding Formula Basics
  • Entering Formulas into Your Worksheets
  • Editing Formulas
  • Using Cell References in Formulas
  • Correcting Common Formula Errors
  • Counting and Summing Worksheet Cells
  • Basic Counting Formulas
  • Summing Formulas
  • Basic Lookup Formulas
  • Summary
27

Visualizing Data Using Conditional Formatting

  • About Conditional Formatting
  • Specifying Conditional Formatting
  • Working with Conditional Formats
  • Summary
28

Enhancing Your Work with Pictures and Drawings

  • Using Shapes
  • Using SmartArt
  • Using WordArt
  • Working with Other Graphic Types
  • Working with Hyperlinks
  • Summary
29

Using Data Validation

  • About Data Validation
  • Specifying Validation Criteria
  • Types of Validation Criteria You Can Apply
  • Creating a Drop-Down List
  • Using Formulas for Data Validation Rules
  • Understanding Cell References
  • Data Validation Formula Examples
  • Summary
30

Introducing Pivot Tables

  • About Pivot Tables
  • Creating a Pivot Table Automatically
  • Creating a Pivot Table Manually
  • More Pivot Table Examples
  • Summary
31

Performing Spreadsheet What-If Analysis

  • A What-If Example
  • Types of What-If Analysis
  • Single-Cell Goal Seeking
  • Summary
B

Appendix A

  • Certification Objectives Map
33

A First Look at PowerPoint

  • Who Uses PowerPoint and Why?
  • Learning Your Way around PowerPoint
  • Changing the View
  • Zooming In and Out
  • Customizing the Quick Access Toolbar
  • Summary
34

Creating and Saving Presentation Files

  • Starting a New Presentation
  • Saving Your Work
  • Setting Passwords for File Access
  • Summary
35

Creating Slides and Text Boxes

  • Creating New Slides
  • Inserting Content from External Sources
  • Managing Slides
  • Using Content Placeholders
  • Creating Text Boxes Manually
  • Working with Text Boxes
  • Understanding Layouts and Themes
  • Changing a Slide's Layout
  • Applying a Theme
  • Managing Themes
  • Changing Colors, Fonts, and Effects
  • Changing the Background
  • Managing Slide Masters
  • Summary
36

Formatting Text

  • Changing the Font
  • Changing the Font Size
  • Changing Font Color/Text Fill
  • Applying Text Attributes
  • Applying WordArt Styles
  • Applying Text Effects
  • Finding and Replacing Text
  • Correcting Your Spelling and Grammar
  • Using AutoCorrect to Fix Common Problems
  • Using the Research Tools
  • Summary
37

Formatting Paragraphs and Text Boxes

  • Formatting Bulleted Lists
  • Formatting Numbered Lists
  • Formatting Text Boxes
  • Summary
38

Creating and Formatting Tables

  • Creating a New Table
  • Moving around in a Table
  • Selecting Rows, Columns, and Cells
  • Editing a Table's Structure
  • Applying Table Styles
  • Formatting Table Cells
  • Summary
39

Drawing and Formatting Objects

  • Working with the Drawing Tools
  • Understanding Object Formatting
  • Resizing Objects
  • Arranging Objects
  • Merging Shapes
  • Applying Shape or Picture Styles
  • Understanding Color Selection
  • Applying an Object Border
  • Applying an Object Fill
  • Applying Object Effects
  • Using Action Buttons
  • Summary
40

Creating SmartArt Graphics

  • Understanding SmartArt Types and Their Uses
  • Inserting a SmartArt Graphic
  • Formatting a SmartArt Graphic
  • Inserting Clip Art
  • Inserting Photos
  • Sizing and Cropping Photos
  • Adjusting and Correcting Photos
  • Compressing Images
  • Creating a Photo Album Layout
  • Summary
41

Working with Charts

  • Understanding the Parts of a Chart
  • Starting a New Chart
  • Working with Chart Data
  • Chart Types and Chart Layout Presets
  • Working with Chart Elements
  • Formatting a Chart
  • Summary
42

Adding Sound Effects, Music, and Soundtracks

  • How PowerPoint Uses Audio
  • When to Use Sounds - and When Not To
  • Inserting an Audio Clip as an Icon on a Slide
  • Assigning a Sound to an Object
  • Configuring Sound Playback
  • Understanding Video Types
  • Placing a Video on a Slide
  • Changing the Video's Formatting
  • Specifying Playback Options
  • Summary
43

Creating Animation Effects and Transitions

  • Assigning Transitions to Slides
  • Animating Slide Content
  • Summary
44

Creating Support Materials

  • The When and How of Handouts
  • Creating Handouts
  • Summary
45

Preparing for a Live Presentation

  • Starting and Ending a Show
  • Using the On-Screen Show Controls
  • Using the On-Screen Pen
  • Using Custom Shows
  • Creating and Using Sections
  • Recording Narration and Timings
  • Summary
46

Sharing and Collaborating

  • Working with Comments
  • Comparing and Merging Presentations
  • Summary

1

Taking Your First Steps with Word

  • Using the Word Count Option
  • Exploring the File tab
  • Understanding undoing and redoing actions
2

Diving Into Document Creation

  • Understanding Inserting versus Overtyping
  • Creating a file from a template
  • Saving a Document
  • Identifying file formats
  • Zooming in the Document
  • Changing the Text to Bold
3

Working with Document Style and Content

  • Modifying the Font
  • Changing the Text Color
  • Showing Paragraph Marks and Zooming in the Document 
  • Increasing the Line Spacing
  • Creating a Signature Line
  • Inserting Page Breaks
  • Inserting Bullets
  • Changing the Heading Style
4

Cutting, Copying, and Pasting Using the Clipboard

  • Using the Cut and Paste Functions
  • Understanding the Navigation pane
  • Finding and Replacing the Text
5

Cleaning Up with AutoCorrect and AutoFormat

  • Revisiting AutoCorrect
  • Inserting a Cover Page
  • Printing an envelope
6

Building Tables, Charts, and SmartArt to Show Data and Process

  • Inserting a Table
  • Formatting the Table Border
  • Inserting Rows and Columns
  • Drag the table style option to its description.
  • Modifying the Table Design and Border
  • Inserting SmartArt
7

Adding Pictures and WordArt to Highlight Information

  • Inserting and Modifying the Picture
  • Inserting an Online Picture
  • Understanding resizing, rotating, and cropping
  • Inserting a WordArt
8

Adding Drop Caps, Text Boxes, Shapes, Symbols, and Equations

  • Applying a Drop Cap
  • Inserting Symbols
  • Inserting a Shape
  • Drag the features of the Symbol dialog box to match them with their descriptions.
9

Setting Up the Document with Sections, Headers/Footers, and Columns

  • Changing the Basic Page Setup
  • Adding a Header
  • Inserting Page Numbers
  • Changing the Number of Columns and the Basic Page Setup
  • Breaking Content into Columns
10

Changing Other Page Features

  • Adding and Removing Page Borders
  • Adding the Page Color
  • Adding a Custom Text Watermark
  • Identifying shortcut for inserting bookmark
11

Data Documents and Mail Merge

  • Identifying Mail merge options
  • Identifying fields of the Rules feature
12

Managing Document Security, Comments, and Tracked Changes

  • Understanding Track Changes
  • Understanding Accept and Reject Changes
13

Customizing the Quick Access Toolbar and Ribbon

  • Understanding the Quick Access Toolbar
14

Word Options and Settings

  • Identifying formatting marks
15

Macros: Recording, Editing, and Using Them

  • Identifying Macro file formats
16

Introducing Excel

  • Identifying elements of Excel
  • Identifying keys of Worksheet
  • Modifying worksheet in MS Excel 2016
17

Entering and Editing Worksheet Data

  • Modifying cell contents
  • Identifying key combinations
  • Changing date format in MS Excel 2016
18

Essential Worksheet Operations

  • Freezing the top row in MS Excel 2016
  • Inserting a column in MS Excel 2016
19

Working with Cells and Ranges

  • Understanding cell range address
  • Understanding paste options
  • Adding comments in MS Excel 2016
20

Tables, Charts, and Sparklines

  • Formatting data as table in MS Excel 2016
  • Removing duplicates in MS Excel 2016
  • Sorting data in MS Excel 2016
  • Filtering data in MS Excel 2016
  • Inserting a chart in MS Excel 2016
  • Changing chart style in MS Excel 2016
  • Changing chart color in MS Excel 2016
  • Customizing a chart in MS Excel 2016
  • Identifying chart types
  • Removing gridlines and headings in MS Excel 2016
  • Creating Sparklines in MS Excel 2016
21

Worksheet Formatting

  • Formatting heading in MS Excel 2016
  • Wrapping text in MS Excel 2016
  • Applying border on the MS Excel 2016 sheet
22

Understanding Excel Files

  • Saving a workbook in MS Excel 2016
  • Understanding Workbook
  • Understanding file compatibility
23

Printing and Protecting Your Work

  • Setting page margin in MS Excel 2016
  • Printing an area in MS Excel 2016
  • Adding header in MS Excel 2016
  • Protecting a workbook in MS excel 2016
24

Introducing Formulas and Functions

  • Using the Concatenate function in MS Excel 2016
  • Using the Average function in MS Excel 2016
  • Using the SUMIF function in MS Excel 2016
  • Using the SUM function in MS Excel 2016
  • Using VLOOKUP in MS Excel 2016
25

Visualizing Data Using Conditional Formatting

  • Applying conditional formatting in MS Excel 2016
26

Enhancing Your Work with Pictures and Drawings

  • Inserting and configuring shape
  • Understanding graphic types
27

Using Data Validation

  • Hiding column in MS Excel 2016
  • Adding data validation in MS Excel 2016
28

Introducing Pivot Tables

  • Understanding pivot table
29

Performing Spreadsheet What-If Analysis

  • Understanding the Scenarios dropdown-list
30

A First Look at PowerPoint

  • Identifying font dialog controls
  • Adding notes in MS PowerPoint 2016
  • Changing document view in MS PowerPoint 2016
31

Creating Slides and Text Boxes

  • Showing gridlines in MS PowerPoint 2016
  • Duplicating slide in MS PowerPoint 2016
  • Understanding Outline view
  • Understanding themes and template
  • Adding a layout in MS PowerPoint 2016
  • Applying themes in MS PowerPoint 2016
32

Formatting Text

  • Identifying text effects
  • Customizing AutoCorrect Options in MS PowerPoint 2016
  • Marking a document as final in MS PowerPoint 2016
33

Formatting Paragraphs and Text Boxes

  • Formatting bulleted lists
  • Setting fill transparency
34

Drawing and Formatting Objects

  • Aligning objects in MS PowerPoint 2016
  • Identifying merge operations
  • Inserting and formatting shapes in MS PowerPoint 2016
  • Understanding border attributes
35

Creating SmartArt Graphics

  • Inserting SmartArt and arranging picture position in MS PowerPoint 2016
  • Adding multiple screenshots in MS PowerPoint 2016
  • Applying artistic effects in MS PowerPoint 2016
  • Creating an album in MS PowerPoint 2016
36

Working with Charts

  • Understanding the parts of a chart
  • Identifying chart elements
37

Adding Sound Effects, Music, and Soundtracks

  • Inserting audio in MS PowerPoint 2016
  • Inserting a video in MS PowerPoint 2016
38

Creating Animation Effects and Transitions

  • Applying transition on the slide in MS PowerPoint 2016
  • Applying animation on images in MS PowerPoint 2016
  • Adding a motion path to an object
  • Applying animation on an online picture
39

Creating Support Materials

  • Customizing the handout master in MS PowerPoint 2016
  • Previewing the handout master in MS PowerPoint 2016
40

Preparing for a Live Presentation

  • Identifying shortcuts

Any questions?
Check out the FAQs

Still have unanswered questions and need to get in touch?

Contact Us Now

Microsoft Office 2016

$379.99

Buy Now

Related Courses

All Courses