MS-Office-2016 : Microsoft Office 2016

MSO-2016
MS-Office-2016
Microsoft Office 2016
ISBN : 978-1-61691-966-5
Gain hands-on expertise in Microsoft Office 2016 certification exams with Microsoft Office 2016 course and performance-based labs. Performance-based labs simulate real-world, hardware, software & command line interface environments and can be mapped to any text-book, course & training. The course focuses on the objectives of Microsoft Office 2016 certification exams and provides skills required to get the most out of the Office by earning a Microsoft Office Specialist (MOS) certification in a specific Office program.

Here's what you will get

Lessons
Lessons
46+
Quizzes
285+
Flashcards
312+
Glossary of terms
312+
TestPrep
Pre-assessment Questions
100+
Full Length Tests
3+
Post-Assessment Questions
84+
Lab
Performance based lab
130+
Video tutorials
90+
Minutes
47+

Videos and How To..

uCertify course includes videos to help understand concepts. It also includes How Tos that help learners with how to accomplish certain tasks.

Video Lessons
Videos
97+
Hours
03:24+

Here's what you will learn

  • 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
  • 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
  • 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
  • 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
  • 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
  • Getting a Quick Start with Quick Tables
  • Table Basics
  • Working with Table Layout and Design
  • Inserting SmartArt
  • Summary
  • 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
  • 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
  • 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
  • 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
  • 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
  • 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
  • Protection Types
  • Comments and Tracked Changes
  • Accepting and Rejecting Changes
  • Summary
  • 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
  • Opening Word Options
  • General
  • Display (and Printing)
  • Proofing
  • Save
  • Language
  • Advanced
  • Summary
  • 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
  • Certification Objectives Map
  • 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
  • Entering Text and Values into Your Worksheets
  • Entering Dates and Times into Your Worksheets
  • Modifying Cell Contents
  • Applying Number Formatting
  • Summary
  • Learning the Fundamentals of Excel Worksheets
  • Controlling the Worksheet View
  • Working with Rows and Columns
  • Summary
  • Understanding Cells and Ranges
  • Copying or Moving Ranges
  • Using Names to Work with Ranges
  • Adding Comments to Cells
  • Summary
  • 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
  • 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
  • Creating a New Workbook
  • Saving a Workbook
  • Password-Protecting a Workbook
  • Closing Workbooks
  • Safeguarding Your Work
  • Excel File Compatibility
  • Exploring Excel Templates
  • Summary
  • 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
  • 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
  • About Conditional Formatting
  • Specifying Conditional Formatting
  • Working with Conditional Formats
  • Summary
  • Using Shapes
  • Using SmartArt
  • Using WordArt
  • Working with Other Graphic Types
  • Working with Hyperlinks
  • Summary
  • 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
  • About Pivot Tables
  • Creating a Pivot Table Automatically
  • Creating a Pivot Table Manually
  • More Pivot Table Examples
  • Summary
  • A What-If Example
  • Types of What-If Analysis
  • Single-Cell Goal Seeking
  • Summary
  • Certification Objectives Map
  • Who Uses PowerPoint and Why?
  • Learning Your Way around PowerPoint
  • Changing the View
  • Zooming In and Out
  • Customizing the Quick Access Toolbar
  • Summary
  • Starting a New Presentation
  • Saving Your Work
  • Setting Passwords for File Access
  • Summary
  • 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
  • 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
  • Formatting Bulleted Lists
  • Formatting Numbered Lists
  • Formatting Text Boxes
  • Summary
  • 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
  • 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
  • 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
  • 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
  • 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
  • Assigning Transitions to Slides
  • Animating Slide Content
  • Summary
  • The When and How of Handouts
  • Creating Handouts
  • Summary
  • 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
  • Working with Comments
  • Comparing and Merging Presentations
  • Summary

Hands on Activities (Labs)

  • Using word count in MS Word 2016
  • Exploring the File tab
  • Understanding undoing and redoing actions
  • Understanding Inserting versus Overtyping
  • Creating a file from a template
  • Saving document in MS Word 2016
  • Identifying file formats
  • Zooming document in MS Word 2016
  • Changing text to bold in MS Word 2016
  • Changing the font style and font size in MS Word 2016
  • Changing text color in MS Word 2016
  • Showing paragraph marks in MS Word 2016
  • Increasing line spacing in MS Word 2016
  • Creating a signature line in MS Word 2016
  • Inserting page breaks in MS Word 2016
  • Inserting bullets in MS Word 2016
  • Changing heading style in MS Word 2016
  • Using the cut and paste functions in MS Word 2016
  • Understanding the Navigation pane
  • Finding and replacing text in MS Word 2016
  • Revisiting AutoCorrect
  • Inserting a cover page in MS Word 2016
  • Printing an envelope
  • Inserting table in MS Word 2016
  • Formatting table border in MS Word 2016
  • Inserting rows and columns in MS Word 2016
  • Drag the table style option to its description.
  • Modifying table design
  • Inserting SmartArt
  • Inserting picture from a file
  • Inserting an online picture
  • Understanding resizing, rotating, and cropping
  • Inserting a WordArt
  • Applying a drop cap in MS Word 2016
  • Inserting symbols in MS Word 2016
  • Inserting a shape
  • Identifying features of the Symbol dialog box
  • Changing basic page setup
  • Adding header in MS Word 2016
  • Inserting page numbers in MS Word 2016
  • Changing the number of columns
  • Breaking content into columns in MS Word 2016
  • Adding and removing page borders
  • Adding page color in MS Word 2016
  • Adding a custom text watermark in MS Word 2016
  • 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