MS-Office-2016 : Microsoft Office 2016

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.
MS-Office-2016
Microsoft Office 2016
ISBN : 978-1-61691-966-5

Lessons

uCertify uses content from well known publishers, instructors, and subject matter experts. They have a minimum of 15 years of experience in their fields. uCertify brings these textbooks to life. It is full of interactive activities that keep the learner engaged. uCertify brings all available learning resources for a topic in one place so that the learner can efficiently learn without going to multiple places. Challenge questions are also embedded in the chapters so learners can attempt those while they are learning about that particular topic. This helps them grasp the concepts better because they can go over it again right away which improves learning. At the end of every lesson, uCertify courses guide the learners on the path they should follow.

uCertify platform supports 50+ different types of interactive activities, connect the idea, or try it yourself lab activities embedded throughout its course. These interactive activities keep learners engaged and make learning fun.

Here's What You Get

Flashcards Quizzes Glossary

Each lesson comes with Flashcards & Quizzes. There is no limit to the number of times learners can attempt these. Flashcards help master the key concepts. Glossary defines the key terms.

Quizzes
285+
Flashcards
312+
Glossary of terms
312+
Lessons
46+
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.

Videos
97+
Hours
03:24+

Test Prep & Practice Questions

uCertify provides full length practice tests. These tests closely follow the exam objectives and are designed to simulate real exam conditions. Each course has a number of test sets consisting of hundreds of items to ensure that learners are prepared for the certification exam.

Here's What You Get

Pre-assessments Questions
100+
Full Length Tests
3+
Post-Assessments Questions
84+

Features

Full Remediation

Each question comes with detailed remediation explaining not only why an answer option is correct but also why the incorrect answer options are incorrect.

Unlimited Practice

Each test can be taken unlimited number of times until the learner feels they are prepared. Learner can review the test and read detailed remediation. Detailed test history is also available.

Learn, Test and Review Mode

Each test set comes with learn, test and review modes. In learn mode, learners will attempt a question and will get immediate feedback and complete remediation as they move on to the next question. In test mode, learners can take a timed test simulating the actual exam conditions. In review mode, learners can read through one item at a time without attempting it.

Labs

Online labs can be used to supplement training. uCertify labs are an inexpensive & safe way to explore and learn. uCertify labs are versatile - labs simulate real-world, hardware, software & command line interface environments and can be mapped to any text-book, course & training.

Here's What You Get

Performance based lab
130+
Video tutorials
90+
Minutes
47+

Hands on Activities

Taking Your First Steps with Word

  • Using word count in MS Word 2016
  • Exploring the File tab
  • Understanding undoing and redoing actions

Diving Into Document Creation

  • 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

Working with Document Style and Content

  • 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

Cutting, Copying, and Pasting Using the Clipboard

  • Using the cut and paste functions in MS Word 2016
  • Understanding the Navigation pane
  • Finding and replacing text in MS Word 2016

Cleaning Up with AutoCorrect and AutoFormat

  • Revisiting AutoCorrect
  • Inserting a cover page in MS Word 2016
  • Printing an envelope

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

  • 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

Adding Pictures and WordArt to Highlight Information

  • Inserting picture from a file
  • Inserting an online picture
  • Understanding resizing, rotating, and cropping
  • Inserting a WordArt

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

  • Applying a drop cap in MS Word 2016
  • Inserting symbols in MS Word 2016
  • Inserting a shape
  • Identifying features of the Symbol dialog box

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

  • 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

Changing Other Page Features

  • 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 the Contents and Terms in Your Document: TOCs, Captions, and Indexing

Data Documents and Mail Merge

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

Managing Document Security, Comments, and Tracked Changes

  • Understanding Track Changes
  • Understanding Accept and Reject Changes

Customizing the Quick Access Toolbar and Ribbon

  • Understanding the Quick Access Toolbar

Word Options and Settings

  • Identifying formatting marks

Macros: Recording, Editing, and Using Them

  • Identifying Macro file formats

Appendix A

Introducing Excel

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

Entering and Editing Worksheet Data

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

Essential Worksheet Operations

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

Working with Cells and Ranges

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

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

Worksheet Formatting

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

Understanding Excel Files

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

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

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

Visualizing Data Using Conditional Formatting

  • Applying conditional formatting in MS Excel 2016

Enhancing Your Work with Pictures and Drawings

  • Inserting and configuring shape
  • Understanding graphic types

Using Data Validation

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

Introducing Pivot Tables

  • Understanding pivot table

Performing Spreadsheet What-If Analysis

  • Understanding the Scenarios dropdown-list

Appendix A

A First Look at PowerPoint

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

Creating and Saving Presentation Files

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

Formatting Text

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

Formatting Paragraphs and Text Boxes

  • Formatting bulleted lists
  • Setting fill transparency

Creating and Formatting Tables

Drawing and Formatting Objects

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

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

Working with Charts

  • Understanding the parts of a chart
  • Identifying chart elements

Adding Sound Effects, Music, and Soundtracks

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

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

Creating Support Materials

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

Preparing for a Live Presentation

  • Identifying shortcuts

Sharing and Collaborating

Table of Content

Here's What you will Learn

Lesson 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

Lesson 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

Lesson 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

Lesson 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

Lesson 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

Lesson 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

Lesson 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

Lesson 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

Lesson 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

Lesson 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

Lesson 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

Lesson 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

Lesson 13: Managing Document Security, Comments, and Tracked Changes

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

Lesson 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

Lesson 15: Word Options and Settings

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

Lesson 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

Lesson 17: Appendix A

  • Certification Objectives Map

Lesson 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

Lesson 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

Lesson 20: Essential Worksheet Operations

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

Lesson 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

Lesson 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

Lesson 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

Lesson 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

Lesson 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

Lesson 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

Lesson 27: Visualizing Data Using Conditional Formatting

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

Lesson 28: Enhancing Your Work with Pictures and Drawings

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

Lesson 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

Lesson 30: Introducing Pivot Tables

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

Lesson 31: Performing Spreadsheet What-If Analysis

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

Lesson 32: Appendix A

  • Certification Objectives Map

Lesson 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

Lesson 34: Creating and Saving Presentation Files

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

Lesson 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

Lesson 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

Lesson 37: Formatting Paragraphs and Text Boxes

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

Lesson 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

Lesson 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

Lesson 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

Lesson 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

Lesson 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

Lesson 43: Creating Animation Effects and Transitions

  • Assigning Transitions to Slides
  • Animating Slide Content
  • Summary

Lesson 44: Creating Support Materials

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

Lesson 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

Lesson 46: Sharing and Collaborating

  • Working with Comments
  • Comparing and Merging Presentations
  • Summary
uCertify

uCertify provides courses, simulator, labs, test prep kits for IT certifications including Microsoft, Oracle, Cisco, CompTIA, CIW, PMI, ISC2, Linux, Zend, Google, IC3 , Adobe and many more.

© 2002-2017 uCertify. All Rights Reserved
app_store
google_play