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 a free 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

Certification

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

Course Curriculum

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 2016 (Beginner) 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

Course Reviews

4.7

4.7
8 ratings
  • 5 stars0
  • 4 stars0
  • 3 stars0
  • 2 stars0
  • 1 stars0

No Reviews found for this course.

510 STUDENTS ENROLLED

© Janets.