• Professional Development
  • Medicine & Nursing
  • Arts & Crafts
  • Health & Wellbeing
  • Personal Development

Course Images

Microsoft Office 2016 Advanced

Microsoft Office 2016 Advanced

By Course Gate

5.0(1)
  • 30 Day Money Back Guarantee
  • Completion Certificate
  • 24/7 Technical Support

Highlights

  • On-Demand course

  • 3 days

  • All levels

Description

Microsoft office is used for documentation, writing, and many other activities. It brings a new dimension to this technology-based competitive world. It has vivid functions and much more use. If you want to learn all its advanced functions, look at our Microsoft Office 2016 Advanced course.

This course introduces to the function of ribbon that incorporates many tabs such as Insert, design, animation, slides, show, review, and home. It also guides you step by step how to insert a picture, change design lay order, add a hyperlink, watch video from youtube, create CV, cash memo, payment sleep, many more things.

Overall the course teaches you all the efficient use of Microsoft Office to be expert in it.

Who is this Course for?

Microsoft Office 2016 Advanced is perfect for anyone trying to learn potential professional skills.

As there is no experience and qualification required for this course, it is available for all students from any academic background.

Entry Requirement:
  • This course is available to all learners, of all academic backgrounds.

  • Learners should be aged 16 or over to undertake the qualification.

  • Good understanding of English language, numeracy and ICT are required to attend this course.

CPD Certificate from Course Gate 

At the successful completion of the course, you can obtain your CPD certificate from us. You can order the PDF certificate for £9 and the hard copy for £15. Also, you can order both PDF and hardcopy certificates for £22.

Career path

This course opens a new door for you to enter the relevant job market and also gives you the opportunity to acquire extensive knowledge along with required skills to become successful. You will be able to add our qualification to your CV/resume which will help you to stand out in the competitive job industry.


Course Curriculum

Microsoft Word 2016

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

00:00:00

Microsoft Excel 2016

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

00:00:00

Microsoft PowerPoint 2016

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

00:00:00

Microsoft Outlook 2016

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

00:00:00

Microsoft Access 2016

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

Mock Exam

Mock Exam - Microsoft Office 2016 Advanced

00:20:00

Final Exam

Final Exam - Microsoft Office 2016 Advanced

00:20:00

Certificate and Transcript

Order Your Certificates or Transcripts

00:00:00

About The Provider

Course Gate
Course Gate
London
5.0(1)

Welcome to Course Gate, your gateway to a world of knowledge and oppo...

Read more about Course Gate

Tags

Reviews