MS-Office-2016 : Microsoft Office 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 will you get

Lessons
46+
Quizzes
285+
Flashcards
312+
Glossary of terms
312+
Pre-assessment Questions
100+
Full Length Tests
3+
Post-Assessment Questions
84+
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.

Videos
97+
Hours
03:24+

Here's what will you 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
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