JRNY-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
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 +
- 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
02 Diving Into Document Creation 11 topics +
- 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
03 Working with Document Style and Content 7 topics +
- 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
04 Cutting, Copying, and Pasting Using the Clipboard 6 topics +
- 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
05 Cleaning Up with AutoCorrect and AutoFormat 10 topics +
- 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
06 Building Tables, Charts, and SmartArt to Show Data and Process 5 topics +
- Getting a Quick Start with Quick Tables
- Table Basics
- Working with Table Layout and Design
- Inserting SmartArt
- Summary
07 Adding Pictures and WordArt to Highlight Information 7 topics +
- 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
08 Adding Drop Caps, Text Boxes, Shapes, Symbols, and Equations 7 topics +
- 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
09 Setting Up the Document with Sections, Headers/Footers, and Columns 9 topics +
- 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 9 topics +
- 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 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 +
- 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 4 topics +
- Protection Types
- Comments and Tracked Changes
- Accepting and Rejecting Changes
- Summary
14 Customizing the Quick Access Toolbar and Ribbon 6 topics +
- 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 8 topics +
- Opening Word Options
- General
- Display (and Printing)
- Proofing
- Save
- Language
- Advanced
- Summary
16 Macros: Recording, Editing, and Using Them 7 topics +
- 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
17 Appendix A 1 topics +
- Certification Objectives Map
18 Introducing Excel 9 topics +
- 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 5 topics +
- 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 4 topics +
- Learning the Fundamentals of Excel Worksheets
- Controlling the Worksheet View
- Working with Rows and Columns
- Summary
21 Working with Cells and Ranges 5 topics +
- Understanding Cells and Ranges
- Copying or Moving Ranges
- Using Names to Work with Ranges
- Adding Comments to Cells
- Summary
22 Tables, Charts, and Sparklines 18 topics +
- 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 8 topics +
- 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 8 topics +
- 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 10 topics +
- 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 10 topics +
- 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 4 topics +
- About Conditional Formatting
- Specifying Conditional Formatting
- Working with Conditional Formats
- Summary
28 Enhancing Your Work with Pictures and Drawings 6 topics +
- Using Shapes
- Using SmartArt
- Using WordArt
- Working with Other Graphic Types
- Working with Hyperlinks
- Summary
29 Using Data Validation 8 topics +
- 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 5 topics +
- About Pivot Tables
- Creating a Pivot Table Automatically
- Creating a Pivot Table Manually
- More Pivot Table Examples
- Summary
31 Performing Spreadsheet What-If Analysis 4 topics +
- A What-If Example
- Types of What-If Analysis
- Single-Cell Goal Seeking
- Summary
32 Appendix A 1 topics +
- Certification Objectives Map
33 A First Look at PowerPoint 6 topics +
- 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 4 topics +
- Starting a New Presentation
- Saving Your Work
- Setting Passwords for File Access
- Summary
35 Creating Slides and Text Boxes 14 topics +
- 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 11 topics +
- 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 4 topics +
- Formatting Bulleted Lists
- Formatting Numbered Lists
- Formatting Text Boxes
- Summary
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 +
- 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 10 topics +
- 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 7 topics +
- 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 10 topics +
- 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 3 topics +
- Assigning Transitions to Slides
- Animating Slide Content
- Summary
44 Creating Support Materials 3 topics +
- The When and How of Handouts
- Creating Handouts
- Summary
45 Preparing for a Live Presentation 7 topics +
- 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 3 topics +
- Working with Comments
- Comparing and Merging Presentations
- Summary
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.