MS-Office-2016 ISBN: 978-1-61691-966-5
Microsoft Office 2016
Gain hands-on expertise in the Microsoft Office 2016 certification exams with the Microsoft Office 2016 course and lab. The lab simulates real-world, hardware, software, and command-line interface environments and can be mapped to any text-book, course or training. The cert guide completely covers the objectives of Microsoft Office 2016 certification exams. It also provides the knowledge and skills required to work with Microsoft Office applications.
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.
Beginner Self-paced · 1 year access 4.6/5 (51 Reviews)
130 Hands-On LiveLabs
Practice real IT tasks in guided environments.
- Real environments
- Auto-graded
- No installation
01 / Lessons & labs
See exactly what you will learn and practice
Lessons
46 Interactive Lessons · 335 topics01 Taking Your First Steps with Word 10 topics · 3 LiveLab +
- 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
3 LiveLab in this lesson — see the labs panel →
02 Diving Into Document Creation 11 topics · 6 LiveLab +
- 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
6 LiveLab in this lesson — see the labs panel →
03 Working with Document Style and Content 7 topics · 8 LiveLab +
- 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
8 LiveLab in this lesson — see the labs panel →
04 Cutting, Copying, and Pasting Using the Clipboard 6 topics · 3 LiveLab +
- 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
3 LiveLab in this lesson — see the labs panel →
05 Cleaning Up with AutoCorrect and AutoFormat 10 topics · 3 LiveLab +
- 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
3 LiveLab in this lesson — see the labs panel →
06 Building Tables, Charts, and SmartArt to Show Data and Process 5 topics · 6 LiveLab +
- Getting a Quick Start with Quick Tables
- Table Basics
- Working with Table Layout and Design
- Inserting SmartArt
- Summary
6 LiveLab in this lesson — see the labs panel →
07 Adding Pictures and WordArt to Highlight Information 7 topics · 4 LiveLab +
- 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
4 LiveLab in this lesson — see the labs panel →
08 Adding Drop Caps, Text Boxes, Shapes, Symbols, and Equations 7 topics · 4 LiveLab +
- 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
4 LiveLab in this lesson — see the labs panel →
09 Setting Up the Document with Sections, Headers/Footers, and Columns 9 topics · 5 LiveLab +
- 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
5 LiveLab in this lesson — see the labs panel →
10 Changing Other Page Features 9 topics · 4 LiveLab +
- 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
4 LiveLab in this lesson — see the labs panel →
11 Identifying the Contents and Terms in Your Document: TOCs, Captions, and Indexing 14 topics +
- 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 8 topics · 2 LiveLab +
- 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
2 LiveLab in this lesson — see the labs panel →
13 Managing Document Security, Comments, and Tracked Changes 4 topics · 2 LiveLab +
- Protection Types
- Comments and Tracked Changes
- Accepting and Rejecting Changes
- Summary
2 LiveLab in this lesson — see the labs panel →
14 Customizing the Quick Access Toolbar and Ribbon 6 topics · 1 LiveLab +
- 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
1 LiveLab in this lesson — see the labs panel →
15 Word Options and Settings 8 topics · 1 LiveLab +
- Opening Word Options
- General
- Display (and Printing)
- Proofing
- Save
- Language
- Advanced
- Summary
1 LiveLab in this lesson — see the labs panel →
16 Macros: Recording, Editing, and Using Them 7 topics · 1 LiveLab +
- 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
1 LiveLab in this lesson — see the labs panel →
17 Appendix A 1 topics +
- Certification Objectives Map
18 Introducing Excel 9 topics · 3 LiveLab +
- 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
3 LiveLab in this lesson — see the labs panel →
19 Entering and Editing Worksheet Data 5 topics · 3 LiveLab +
- Entering Text and Values into Your Worksheets
- Entering Dates and Times into Your Worksheets
- Modifying Cell Contents
- Applying Number Formatting
- Summary
3 LiveLab in this lesson — see the labs panel →
20 Essential Worksheet Operations 4 topics · 2 LiveLab +
- Learning the Fundamentals of Excel Worksheets
- Controlling the Worksheet View
- Working with Rows and Columns
- Summary
2 LiveLab in this lesson — see the labs panel →
21 Working with Cells and Ranges 5 topics · 3 LiveLab +
- Understanding Cells and Ranges
- Copying or Moving Ranges
- Using Names to Work with Ranges
- Adding Comments to Cells
- Summary
3 LiveLab in this lesson — see the labs panel →
22 Tables, Charts, and Sparklines 18 topics · 11 LiveLab +
- 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
11 LiveLab in this lesson — see the labs panel →
23 Worksheet Formatting 8 topics · 3 LiveLab +
- 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
3 LiveLab in this lesson — see the labs panel →
24 Understanding Excel Files 8 topics · 3 LiveLab +
- Creating a New Workbook
- Saving a Workbook
- Password-Protecting a Workbook
- Closing Workbooks
- Safeguarding Your Work
- Excel File Compatibility
- Exploring Excel Templates
- Summary
3 LiveLab in this lesson — see the labs panel →
25 Printing and Protecting Your Work 10 topics · 4 LiveLab +
- 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
4 LiveLab in this lesson — see the labs panel →
26 Introducing Formulas and Functions 10 topics · 5 LiveLab +
- 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
5 LiveLab in this lesson — see the labs panel →
27 Visualizing Data Using Conditional Formatting 4 topics · 1 LiveLab +
- About Conditional Formatting
- Specifying Conditional Formatting
- Working with Conditional Formats
- Summary
1 LiveLab in this lesson — see the labs panel →
28 Enhancing Your Work with Pictures and Drawings 6 topics · 2 LiveLab +
- Using Shapes
- Using SmartArt
- Using WordArt
- Working with Other Graphic Types
- Working with Hyperlinks
- Summary
2 LiveLab in this lesson — see the labs panel →
29 Using Data Validation 8 topics · 2 LiveLab +
- 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
2 LiveLab in this lesson — see the labs panel →
30 Introducing Pivot Tables 5 topics · 1 LiveLab +
- About Pivot Tables
- Creating a Pivot Table Automatically
- Creating a Pivot Table Manually
- More Pivot Table Examples
- Summary
1 LiveLab in this lesson — see the labs panel →
31 Performing Spreadsheet What-If Analysis 4 topics · 1 LiveLab +
- A What-If Example
- Types of What-If Analysis
- Single-Cell Goal Seeking
- Summary
1 LiveLab in this lesson — see the labs panel →
32 Appendix A 1 topics +
- Certification Objectives Map
33 A First Look at PowerPoint 6 topics · 3 LiveLab +
- Who Uses PowerPoint and Why?
- Learning Your Way around PowerPoint
- Changing the View
- Zooming In and Out
- Customizing the Quick Access Toolbar
- Summary
3 LiveLab in this lesson — see the labs panel →
34 Creating and Saving Presentation Files 4 topics +
- Starting a New Presentation
- Saving Your Work
- Setting Passwords for File Access
- Summary
35 Creating Slides and Text Boxes 14 topics · 6 LiveLab +
- 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
6 LiveLab in this lesson — see the labs panel →
36 Formatting Text 11 topics · 3 LiveLab +
- 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
3 LiveLab in this lesson — see the labs panel →
37 Formatting Paragraphs and Text Boxes 4 topics · 2 LiveLab +
- Formatting Bulleted Lists
- Formatting Numbered Lists
- Formatting Text Boxes
- Summary
2 LiveLab in this lesson — see the labs panel →
38 Creating and Formatting Tables 7 topics +
- 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 12 topics · 4 LiveLab +
- 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
4 LiveLab in this lesson — see the labs panel →
40 Creating SmartArt Graphics 10 topics · 4 LiveLab +
- 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
4 LiveLab in this lesson — see the labs panel →
41 Working with Charts 7 topics · 2 LiveLab +
- 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
2 LiveLab in this lesson — see the labs panel →
42 Adding Sound Effects, Music, and Soundtracks 10 topics · 2 LiveLab +
- 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
2 LiveLab in this lesson — see the labs panel →
43 Creating Animation Effects and Transitions 3 topics · 4 LiveLab +
- Assigning Transitions to Slides
- Animating Slide Content
- Summary
4 LiveLab in this lesson — see the labs panel →
44 Creating Support Materials 3 topics · 2 LiveLab +
- The When and How of Handouts
- Creating Handouts
- Summary
2 LiveLab in this lesson — see the labs panel →
45 Preparing for a Live Presentation 7 topics · 1 LiveLab +
- 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
1 LiveLab in this lesson — see the labs panel →
46 Sharing and Collaborating 3 topics +
- Working with Comments
- Comparing and Merging Presentations
- Summary
Hands-On Labs Our edge
130 LiveLabs- Using the Word Count Option
- Exploring the File tab
- Understanding undoing and redoing actions
- 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
- 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
- Using the Cut and Paste Functions
- Understanding the Navigation pane
- Finding and Replacing the Text
- Revisiting AutoCorrect
- Inserting a Cover Page
- Printing an envelope
- 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
- Inserting and Modifying the Picture
- Inserting an Online Picture
- Understanding resizing, rotating, and cropping
- Inserting a WordArt
- Applying a Drop Cap
- Inserting Symbols
- Inserting a Shape
- Drag the features of the Symbol dialog box to match them with their descriptions.
- 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
- Adding and Removing Page Borders
- Adding the Page Color
- Adding a Custom Text Watermark
- Identifying shortcut for inserting bookmark
- Identifying Mail merge options
- Identifying fields of the Rules feature
- Understanding Track Changes
- Understanding Accept and Reject Changes
- Understanding the Quick Access Toolbar
- Identifying formatting marks
- Identifying Macro file formats
- Identifying elements of Excel
- Identifying keys of Worksheet
- Modifying worksheet in MS Excel 2016
- Modifying cell contents
- Identifying key combinations
- Changing date format in MS Excel 2016
- Freezing the top row in MS Excel 2016
- Inserting a column in MS Excel 2016
- Understanding cell range address
- Understanding paste options
- Adding comments in MS Excel 2016
- 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
- Formatting heading in MS Excel 2016
- Wrapping text in MS Excel 2016
- Applying border on the MS Excel 2016 sheet
- Saving a workbook in MS Excel 2016
- Understanding Workbook
- Understanding file compatibility
- 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
- 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
- Applying conditional formatting in MS Excel 2016
- Inserting and configuring shape
- Understanding graphic types
- Hiding column in MS Excel 2016
- Adding data validation in MS Excel 2016
- Understanding pivot table
- Understanding the Scenarios dropdown-list
- Identifying font dialog controls
- Adding notes in MS PowerPoint 2016
- Changing document view in MS PowerPoint 2016
- 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
- Identifying text effects
- Customizing AutoCorrect Options in MS PowerPoint 2016
- Marking a document as final in MS PowerPoint 2016
- Formatting bulleted lists
- Setting fill transparency
- Aligning objects in MS PowerPoint 2016
- Identifying merge operations
- Inserting and formatting shapes in MS PowerPoint 2016
- Understanding border attributes
- 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
- Understanding the parts of a chart
- Identifying chart elements
- Inserting audio in MS PowerPoint 2016
- Inserting a video in MS PowerPoint 2016
- 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
- Customizing the handout master in MS PowerPoint 2016
- Previewing the handout master in MS PowerPoint 2016
- Identifying shortcuts
Labs run in your browser — nothing to install.
02 / FAQs
Questions before you start
Prepare for Microsoft Office 2016
One-time payment. Full access for 1 year. Start with a free trial if you want to look around first.
- 1 year of full access
- 130 LiveLab included
- Certificate of completion
No credit card required