The Microsoft Office 2016 Complete Bundle Course (Word, Excel, PowerPoint, Outlook and Access) is the ultimate online bundle training program, designed for learners of all levels. It covers Microsoft Office 2016’s most fundamental functions and formulas, exploring five key programs; Word, Excel, PowerPoint, Outlook and Access. Taking you from beginner to expert, you will learn the basics such as how to personalise the interface, automate formulas, modify your slide presentations, organise your inbox, and many other fundamental administrative procedures.
This course can be studied on a full-time or part-time basis and applies to anyone who works in an office-based role, equipping you with core transferable skills, techniques and shortcuts required to boost your professional development and gain the confidence you need to master both simple and complex administrative tasks with ultimate proficiency.
Course Curriculum
-
Modify User Information
00:15:00
-
Share a Document
00:30:00
-
Work with Comments
00:15:00
-
Compare Document Changes
00:15:00
-
Review a Document
00:15:00
-
Merge Document Changes
00:15:00
-
Coauthor Documents
00:15:00
-
Add Captions
00:15:00
-
Add Cross-References
00:15:00
-
Add Bookmarks
00:15:00
-
Add Hyperlinks
00:15:00
-
Insert Footnotes and Endnotes
00:15:00
-
Add Citations
00:30:00
-
Insert a Bibliography
00:15:00
-
Insert Blank and Cover Pages
00:15:00
-
Insert an Index
00:30:00
-
Insert a Table of Contents
00:30:00
-
Insert an Ancillary Table
00:15:00
-
Manage Outlines
00:30:00
-
Create a Master Document
00:30:00
-
Suppress Information
00:30:00
-
Set Editing Restrictions
00:30:00
-
Add a Digital Signature to a Document
00:15:00
-
Restrict Document Access
00:15:00
-
Create Forms
00:30:00
-
Manipulate Forms
00:15:00
-
Form Data Conversion
00:15:00
-
Create a New Document Version
00:30:00
-
Compare Document Versions
00:15:00
-
Merge Document Versions
00:15:00
-
Activities – Microsoft Word 2016 Advanced
-
Update Workbook Properties
00:15:00
-
Activity-Update Workbook Properties
00:05:00
-
Create and Edit a Macro
00:15:00
-
Activity-Create and Edit a Macro
00:05:00
-
Apply Conditional Formatting
00:15:00
-
Activity-Apply Conditional Formatting
00:05:00
-
Add Data Validation Criteria
00:15:00
-
Activity-Add Data Validation Criteriaty
00:05:00
-
Trace Cells
00:15:00
-
Activity-Trace Cells
00:05:00
-
Troubleshoot Invalid Data and Formula Errors
00:15:00
-
Activity-Troubleshoot Invalid Data and Formula Errors
00:05:00
-
Watch and Evaluate Formulas
00:15:00
-
Activity-Watch and Evaluate Formulas
00:05:00
-
Create a Data List Outline
00:15:00
-
Activity-Create a Data List Outline
00:05:00
-
Create Sparklines
00:15:00
-
Activity_Create Sparklines
00:05:00
-
Create Scenarios
00:15:00
-
Activity-Create Scenarios
00:05:00
-
Perform a What-If Analysis
00:15:00
-
Activity-Perform a What-If Analysis
00:05:00
-
Perform a Statistical Analysis with the Analysis ToolPak
00:15:00
-
Activity-Perform a Statistical Analysis with the Analysis ToolPak
00:05:00
-
Create Interactive Data with Power View
00:15:00
-
Activity-Create Interactive Data with Power View
00:05:00
-
Consolidate Data
00:15:00
-
Activity-Consolidate Data
00:05:00
-
Link Cells in Different Workbooks
00:15:00
-
Activity-Link Cells in Different Workbooks
00:05:00
-
Merge Workbooks
00:15:00
-
Activity-Merge Workbooks
00:05:00
-
Export Excel Data
00:15:00
-
Activity-Export Excel Data
00:05:00
-
Import a Delimited Text File
00:14:00
-
Activity- Import a Delimited Text File
00:05:00
-
Integrate Excel Data with the Web
00:15:00
-
Activity-Integrate Excel Data with the Web
00:05:00
-
Create a Web Query
00:15:00
-
Activity-Create a Web Query
00:05:00
-
Import and Export XML Data
00:15:00
-
Activity-Import and Export XML Data
00:05:00
-
Activities and Exercise Files – Microsoft Excel 2016 Advanced
-
Customize the User Interface
01:30:00
-
Set PowerPoint 2016 Options
00:45:00
-
Create and Manage Sections
01:00:00
-
Modify Slide Masters and Slide Layouts
01:15:00
-
Add Headers and Footers
00:30:00
-
Modify the Notes Master and the Handout Master
00:45:00
-
Create SmartArt
00:45:00
-
Modify SmartArt
01:00:00
-
Add Audio to a Presentation
00:45:00
-
Add Video to a Presentation
01:00:00
-
Customize Animations and Transitions
01:00:00
-
Add Comments to a Presentation
00:45:00
-
Review a Presentation
00:45:00
-
Store and Share Presentations on the Web
01:30:00
-
Annotate a Presentation
00:45:00
-
Set Up a Slide Show
00:45:00
-
Create a Custom Slide Show
00:30:00
-
Add Hyperlinks and Action Buttons
00:45:00
-
Record a Presentation
00:15:00
-
Secure a Presentation
01:30:00
-
Present a Slide Show Online
01:00:00
-
Create a Video or a CD
00:45:00
-
Activities – Microsoft PowerPoint 2016 Advanced
-
Insert Advanced Characters and Objects
01:30:00
-
Modify Message Settings, Properties, and Options
01:30:00
-
Use Automatic Replies
01:30:00
-
Sort Messages
00:45:00
-
Filter Messages
01:00:00
-
Organize Messages
02:00:00
-
Search Messages
01:30:00
-
Manage Junk Mail
01:00:00
-
Manage Your Mailbox
02:00:00
-
Manage Advanced Calendar Options
00:45:00
-
Manage Additional Calendars
01:00:00
-
Manage Meeting Responses
00:45:00
-
Assign and Manage Tasks
01:00:00
-
Edit an Electronic Business Card
01:00:00
-
Manage Advanced Contact Options
01:30:00
-
Forward Contacts
00:30:00
-
Export Contacts
01:00:00
-
Delegate Access to Mail Folders
01:00:00
-
Share Your Calendar
00:30:00
-
Share Your Contacts
00:15:00
-
Back Up Outlook Items
00:45:00
-
Change Data File Settings
00:45:00
-
Configure E-mail Message Security Settings
00:30:00
-
Activities – Microsoft Outlook 2016 Advanced
-
Add Controls to Forms
01:00:00
-
Set Form Controls
01:00:00
-
Create Subforms
00:30:00
-
Organize Information with Tab Pages
00:30:00
-
Enhance Navigation with Forms
00:30:00
-
Format a Form
01:00:00
-
Apply Conditional Formatting
00:30:00
-
Field Validation
00:30:00
-
Form and Record Validation
00:30:00
-
Create a Macro
01:00:00
-
Restrict Records Using a Condition
00:30:00
-
Validate Data Using a Macro
00:30:00
-
Automate Data Entry Using a Macro
00:30:00
-
Convert a Macro to VBA
00:30:00
-
Link Tables to External Data Sources
00:30:00
-
Manage a Database
00:30:00
-
Determine Object Dependency
00:30:00
-
Document a Database
00:30:00
-
Analyze the Performance of a Database
00:30:00
-
Split a Database for Multiple User Access
00:30:00
-
Implement Security
00:30:00
-
Set Passwords
00:30:00
-
Convert an Access Database to an ACCDE File
00:30:00
-
Package a Database with a Digital Signature
00:30:00
-
Create a Database Switchboard
01:00:00
-
Modify a Database Switchboard
00:30:00
-
Set Startup Options
00:30:00
-
Activities – Microsoft Access 2016 Advanced
-
Mock Exam- Microsoft Office 2016 Advanced
00:30:00
-
Final Exam- Microsoft Office 2016 Advanced
00:30:00
14-Day Money-Back Guarantee
-
Duration:3 days, 5 hours
-
Access:1 Year
-
Units:151


Want to get everything for £149
Take Lifetime Pack