Microsoft Office 2016 Advanced

COURSE CURRICULUM

Module - 1

• Modify User Information
• Share a Document
• Work with Comments
• Compare Document Changes
• Review a Document
• Merge Document Changes
• Coauthor Documents
• Add Captions
• Add Cross-References
• Add Bookmarks
• Add Hyperlinks
• Insert Footnotes and Endnotes
• Add Citations
• Insert a Bibliography
• Insert Blank and Cover Pages
• Insert an Index
• Insert a Table of Contents
• Insert an Ancillary Table
• Manage Outlines
• Create a Master Document
• Suppress Information
• Set Editing Restrictions
• Add a Digital Signature to a Document
• Restrict Document Access
• Create Forms
• Manipulate Forms
• Form Data Conversion
• Create a New Document Version
• Compare Document Versions
• Merge Document Versions
• Activities – Microsoft Word 2016 Advanced

Module - 2

• Update Workbook Properties
• Activity-Update Workbook Properties
• Create and Edit a Macro
• Activity-Create and Edit a Macro
• Apply Conditional Formatting
• Activity-Apply Conditional Formatting
• Add Data Validation Criteria
• Activity-Add Data Validation Criteriaty
• Trace Cells
• Activity-Trace Cells
• Troubleshoot Invalid Data and Formula Errors
• Activity-Troubleshoot Invalid Data and Formula Errors
• Watch and Evaluate Formulas
• Activity-Watch and Evaluate Formulas
• Create a Data List Outline
• Activity-Create a Data List Outline
• Create Sparklines
• Activity_Create Sparklines
• Create Scenarios
• Activity-Create Scenarios
• Perform a What-If Analysis
• Activity-Perform a What-If Analysis
• Perform a Statistical Analysis with the Analysis ToolPak
• Activity-Perform a Statistical Analysis with the Analysis ToolPak
• Create Interactive Data with Power View
• Activity-Create Interactive Data with Power View
• Consolidate Data
• Activity-Consolidate Data
• Link Cells in Different Workbooks
• Activity-Link Cells in Different Workbooks
• Merge Workbooks
• Activity-Merge Workbooks
• Export Excel Data
• Activity-Export Excel Data
• Import a Delimited Text File
• Activity- Import a Delimited Text File
• Integrate Excel Data with the Web
• Activity-Integrate Excel Data with the Web
• Create a Web Query
• Activity-Create a Web Query
• Import and Export XML Data
• Activity-Import and Export XML Data
• Activities – Microsoft Excel 2016 Advanced

Module - 3

• Customize the User Interfac
• Set PowerPoint 2016 Options
• Create and Manage Sections
• Modify Slide Masters and Slide Layouts
• Add Headers and Footers
• Modify the Notes Master and the Handout Master
• Create SmartArt
• Modify SmartArt
• Add Audio to a Presentation
• Add Video to a Presentation
• Customize Animations and Transitions
• Add Comments to a Presentation
• Review a Presentation
• Store and Share Presentations on the Web
• Annotate a Presentation
• Set Up a Slide Show
• Create a Custom Slide Show
• Add Hyperlinks and Action Buttons
• Record a Presentation
• Secure a Presentation
• Present a Slide Show Online
• Create a Video or a CD
• Activities – Microsoft PowerPoint 2016 Advanced

Module - 4

• Insert Advanced Characters and Objects
• Modify Message Settings, Properties, and Options
• Use Automatic Replies
• Sort Messages
• Filter Messages
• Organize Messages
• Search Messages
• Manage Junk Mail
• Manage Your Mailbox
• Manage Advanced Calendar Options
• Manage Additional Calendars
• Manage Meeting Responses
• Assign and Manage Tasks
• Edit an Electronic Business Card
• Manage Advanced Contact Options
• Forward Contacts
• Export Contacts
• Delegate Access to Mail Folders
• Share Your Calendar
• Share Your Contacts
• Back Up Outlook Items
• Change Data File Settings
• Configure E-mail Message Security Settings
• Activities – Microsoft Outlook 2016 Advanced

Module - 5

• Add Controls to Forms
• Set Form Controls
• Create Subforms
• Organize Information with Tab Pages
• Enhance Navigation with Forms
• Format a Form
• Apply Conditional Formatting
• Field Validation
• Form and Record Validation
• Create a Macro
• Restrict Records Using a Condition
• Validate Data Using a Macro
• Automate Data Entry Using a Macro
• Convert a Macro to VBA
• Link Tables to External Data Sources
• Manage a Database
• Determine Object Dependency
• Document a Database
• Analyze the Performance of a Database
• Split a Database for Multiple User Access
• Implement Security
• Set Passwords
• Convert an Access Database to an ACCDE File
• Package a Database with a Digital Signature
• Create a Database Switchboard
• Modify a Database Switchboard
• Set Startup Options
• Activities – Microsoft Access 2016 Advanced