Microsoft Office 2016 – Level 3 (MB5814)

Module 1: Manipulating Images

• Integrate Pictures and Text
• Adjust Image Appearance
• Insert Other Media Elements

Module 2: Using Custom Graphic Elements

• Create Text Boxes and Pull Quotes
• Add WordArt and Other Text Effects
• Draw Shapes
• Create Complex Illustrations with SmartArt

Module 3: Collaborating on Documents

• Prepare a Document for Collaboration
• Mark Up a Document
• Review Markups
• Merge Changes from Other Documents

Module 4: Adding Document References and Links

• Add Captions
• Add Cross-References
• Add Bookmarks
• Add Hyperlinks
• Insert Footnotes and Endnotes
• Add Citations and a Bibliography

Module 5: Securing a Document

• Suppress Information
• Set Formatting and Editing Restrictions
• Restrict Document Access
• Add a Digital Signature to a Document

Module 6: Using Forms to Manage Content

• Create Forms
• Modify Forms

Module 7: Automating Repetitive Tasks with Macros

• Automate Tasks by Using Macros
• Create a Macro

Module 8: Working with Multiple Worksheets and Workbooks

• Use Links and External References
• Use 3-D References
• Consolidate Data

Module 9: Using Lookup Functions and Formula Auditing

• Use Lookup Functions
• Trace Cells
• Watch and Evaluate Formulas

Module 10: Sharing and Protecting Workbooks

• Collaborate on a Workbook
• Protect Worksheets and Workbooks

Module 11: Automating Workbook Functionality

• Apply Data Validation
• Search for Invalid Data and Formulas with Errors
• Work with Macros

Module 12: Creating Sparklines and Mapping Data

• Create Sparklines
• Map Data

Module 13: Forecasting Data

• Determine Potential Outcomes Using Data Tables
• Determine Potential Outcomes Using Scenarios
• Use the Goal Seek Feature
• Forecasting Data Trends