Description

Microsoft Office 2016 Essentials is one of our best selling and most popular course.

This course is suitable for anyone aspiring to or already working in Microsoft Office and looks at skills needed to improve in relevant industry or Microsoft Office. By taking this course you will gain the necessary skills to perform effectively in this field.

The Microsoft Office 2016 Essentials is organised into 97 modules and includes everything you need to become successful in this profession.

To make this course more accessible for you, we have designed it for both part-time and full-time students. You can study at your own pace or become an expert in just 16 hours!

If you require support, our experienced tutors are always available to help you throughout the comprehensive syllabus of this course and answer all your queries through email.

Why choose this course

Earn an e-certificate upon successful completion.

Accessible, informative modules taught by expert instructors

Study in your own time, at your own pace, through your computer tablet or mobile device

Benefit from instant feedback through mock exams and multiple-choice assessments

Get 24/7 help or advice from our email and live chat teams

Full Tutor Support on Weekdays

Course Design

The course is delivered through our online learning platform, accessible through any internet-connected device. There are no formal deadlines or teaching schedules, meaning you are free to study the course at your own pace.

You are taught through a combination of

Video lessons

Online study materials

Mock exams

Multiple-choice assessment

Certificate of Achievement

Endorsed Certificate of Achievement from the Quality Licence Scheme

Once the course has been completed and the assessment has been passed, all students are entitled to receive an endorsed certificate. This will provide proof that you have completed your training objectives, and each endorsed certificate can be ordered and delivered to your address for only £119. Please note that overseas students may be charged an additional £10 for postage.

CPD Certificate of Achievement from Janets

Upon successful completion of the course, you will be able to obtain your course completion e-certificate. Print copy by post is also available at an additional cost of £9.99 and PDF Certificate at £4.99.

Endorsement

This course and/or training programme has been endorsed by the Quality Licence Scheme for its high-quality, non-regulated provision and training programmes. This course and/or training programme is not regulated by Ofqual and is not an accredited qualification. Your training provider will be able to advise you on any further recognition, for example progression routes into further and/or higher education. For further information please visit the Learner FAQs on the Quality Licence Scheme website.

Method of Assessment

In order to ensure the Quality Licensing scheme endorsed and CPD acknowledged certificate, learners need to score at least 60% pass marks on the assessment process. After submitting assignments, our expert tutors will evaluate the assignments and give feedback based on the performance. After passing the assessment, one can apply for a certificate.

Course Content

Excel 2016
Getting Started with Microsoft Office Excel 2016
	Navigate the Excel User Interface	00:28:00
	Use Excel Commands	00:10:00
	Create and Save a Basic Workbook	00:19:00
	Enter Cell Data	00:12:00
	Use Excel Help	00:05:00
Performing Calculations
	Create Worksheet Formulas	00:15:00
	Insert Functions	00:17:00
	Reuse Formulas and Functions	00:17:00
Modifying a Worksheet
	Insert, Delete, and Adjust Cells, Columns, and Rows	00:10:00
	Search for and Replace Data	00:09:00
	Use Proofing and Research Tools	00:07:00
Formatting a Worksheet
	Apply Text Formats	00:17:00
	Apply Number Format	00:08:00
	Align Cell Contents	00:09:00
	Apply Styles and Themes	00:12:00
	Apply Basic Conditional Formatting	00:11:00
	Create and Use Templates	00:07:00
Printing Workbooks
	Preview and Print a Workbook	00:10:00
	Set Up the Page Layout	00:08:00
	Configure Headers and Footers	00:07:00
Managing Workbooks
	Manage Worksheets	00:05:00
	Manage Workbook and Worksheet Views	00:07:00
	Manage Workbook Properties	00:05:00
Word 2016
Getting Started with Word
	Navigate in Microsoft Word	00:12:00
	Create and Save Word Documents	00:24:00
	Manage Your Workspace	00:06:00
	Edit Documents	00:16:00
	Preview and Print Documents	00:04:00
	Customize the Word Environment	00:08:00
Formatting Text and Paragraphs
	Apply Character Formatting	00:17:00
	Control Paragraph Layout	00:19:00
	Align Text Using Tabs	00:07:00
	Display Text in Bulleted or Numbered Lists	00:03:00
	Apply Borders and Shading	00:04:00
Working More Efficiently
	Make Repetitive Edits	00:06:00
	Apply Repetitive Formatting	00:10:00
	Use Styles to Streamline Repetitive Formatting Tasks	00:14:00
Managing Lists
	Sort a List	00:05:00
	Format a List	00:06:00
Adding Tables
	Insert a Table	00:07:00
	Modify a Table	00:06:00
	Format a Table	00:03:00
	Convert Text to a Table	00:04:00
Inserting Graphic Objects
	Insert Symbols and Special Characters	00:04:00
	Add Images to a Document	00:11:00
Controlling Page Appearance
	Apply a Page Border and Color	00:03:00
	Add Headers and Footers	00:06:00
	Control Page Layout	00:05:00
	Add a Watermark	00:04:00
Preparing to Publish a Document
	Check Spelling Grammar and Readability	00:07:00
	Use Research Tools	00:06:00
	Check Accessibility	00:03:00
	Save a Document to Other Formats	00:04:00
Workbooks - Microsoft Word 2016 (Beginner)
	Workbooks - Microsoft Word 2019	00:00:00
PowerPoint 2016
PowerPoint Interface
	Navigate the PowerPoint Environment	00:28:00
	View and Navigate a Presentation	00:15:00
	Create and Save a PowerPoint Presentation	00:13:00
	Use PowerPoint Help	00:10:00
Presentation Basics
	Select a Presentation Type	00:08:00
	Edit Text	00:13:00
	Build a Presentation	00:27:00
Formatting
	Format Characters	00:11:00
	Format Paragraphs	00:16:00
	Format Text Boxes	00:09:00
Inserting Options
	Insert Images	00:10:00
	Insert Shapes	00:15:00
Working with Objects
	Edit Objects	00:16:00
	Format Objects	00:06:00
	Group Objects	00:04:00
	Arrange Objects	00:07:00
	Animate Objects	00:07:00
Table
	Create a Table	00:09:00
	Format a Table	00:03:00
	Insert a Table from Other Microsoft Office Applications	00:06:00
Charts
	Create a Chart	00:10:00
	Format a Chart	00:10:00
	Insert a Chart from Microsoft Excel	00:05:00
Review and Presentatin
	Review Your Presentation	00:11:00
	Apply Transitions	00:05:00
	Print Your Presentation	00:05:00
	Deliver Your Presentation	00:08:00
Access 2016
Introduction to Access
	Orientation to Microsoft Access	00:39:00
	Create a Simple Access Database	00:10:00
	Get Help and Configure Options in Microsoft Access	00:06:00
Modify Data
	Modify Table Data	00:17:00
	Sort and Filter Records	00:05:00
Working with Queries
	Create Basic Queries	00:15:00
	Sort and Filter Data in a Query	00:14:00
	Perform Calculations in a Query	00:08:00
Access Forms
	Create Basic Access Forms	00:07:00
	Work with Data on Access Forms	00:23:00
Working with Reports
	Create a Report	00:23:00
	Add Controls to a Report	00:12:00
	Enhance the Appearance of a Report	00:05:00
	Prepare a Report for Print	00:03:00
	Organize Report Information	00:15:00
	Format Reports	00:12:00
Assignment
	Assignment - Microsoft Office 2016 Essentials	3 weeks, 3 days
Order Your Certificate
	Order your Certificate QLS	00:00:00

Frequently Asked Questions

Are there any prerequisites for taking the course?

There are no specific prerequisites for this course, nor are there any formal entry requirements. All you need is an internet connection, a good understanding of English and a passion for learning for this course.

Can I access the course at any time, or is there a set schedule?

You have the flexibility to access the course at any time that suits your schedule. Our courses are self-paced, allowing you to study at your own pace and convenience.

How long will I have access to the course?

For this course, you will have access to the course materials for 1 year only. This means you can review the content as often as you like within the year, even after you've completed the course. However, if you buy Lifetime Access for the course, you will be able to access the course for a lifetime.

Is there a certificate of completion provided after completing the course?

Yes, upon successfully completing the course, you will receive a certificate of completion. This certificate can be a valuable addition to your professional portfolio and can be shared on your various social networks.

Can I switch courses or get a refund if I'm not satisfied with the course?

We want you to have a positive learning experience. If you're not satisfied with the course, you can request a course transfer or refund within 14 days of the initial purchase.

How do I track my progress in the course?

Our platform provides tracking tools and progress indicators for each course. You can monitor your progress, completed lessons, and assessments through your learner dashboard for the course.

What if I have technical issues or difficulties with the course?

If you encounter technical issues or content-related difficulties with the course, our support team is available to assist you. You can reach out to them for prompt resolution.

Course Images

Microsoft Office 2016 Essentials

By Janets

Booking options

Highlights

Description

About The Provider

Tags

Reviews