2

Explore Courses
All Courses

Course Library View the full range of courses

Quality Licence Scheme Endorsed

Quality Licence Scheme Endorsed

Regulated Courses

Regulated Courses

Microsoft Office 2016 Complete Course for Beginners

60 Students
(10 Reviews)

Learn Microsoft Office 2016, including Word, Excel, PowerPoint, and Outlook, with this beginner-friendly complete course.

Microsoft Office 2016 Complete Course for Beginners

GET THIS COURSE AND 3000+ OTHERS FOR ONLY £49 PER YEAR. FIND OUT MORE

Overview

Microsoft Office 2016 is one of the most widely used office productivity suites in workplaces, education, and business environments. This comprehensive Microsoft Office 2016 Complete Course for Beginners equips you with the essential knowledge and skills needed to confidently use key Microsoft Office applications for everyday tasks. You will gain valuable insight into word processing, spreadsheets, presentations, and basic office productivity tools.

Microsoft Office includes essential programs such as Microsoft Word, Excel, PowerPoint, and Outlook. This course covers the fundamentals of each application, including document creation and formatting in Word, basic spreadsheet operations in Excel, presentation design in PowerPoint, and email and communication basics in Outlook. You will learn how to create professional documents, organise data, design presentations, and improve workplace efficiency using Office tools.

Developing Microsoft Office skills can create opportunities across almost every industry, including business administration, education, finance, healthcare, and customer service. The knowledge gained through this course is valuable for students, job seekers, office workers, and professionals who want to improve their digital skills. Whether you are a complete beginner or looking to strengthen your computer literacy, this course provides a strong foundation for Microsoft Office proficiency.

Learning Outcomes

  • Understand Microsoft Office 2016 interface and tools
  • Learn basic and advanced Microsoft Word functions
  • Create and manage spreadsheets in Microsoft Excel
  • Design presentations using Microsoft PowerPoint
  • Improve document formatting and data organisation
  • Build confidence in office software usage

Why choose this course

  • Affordable, Accessible, informative and well-structured study materials
  • Earn a globally recognised accredited qualification
  • Study in your own time, at your own pace, through any device
  • Benefit from feedback through mock exams and multiple-choice assessments
  • Excellent career advancement/career switch opportunities
  • Get 24/7 help or advice from our email and live chat teams

Certification

Certificate of Achievement

After the successful completion of the final assessment, you will receive a CPD-accredited certificate of achievement. The PDF certificate is for 9.99, and it will be sent to you immediately after through e-mail. You can get the hard copy for 15.99, which will reach your doorsteps by post. 

Entry Requirements

No previous experience is required. A basic understanding of computers and willingness to learn is beneficial. This course is suitable for beginners as well as individuals who want to improve their Microsoft Office skills.

Who is this course for?

This course is ideal for individuals interested in improving digital and office skills, including:

  • Beginners in Computer Skills
  • Students and Job Seekers
  • Administrative Staff
  • Business Professionals
  • Individuals Seeking IT Skills

Career Paths

This course can support progression into roles such as:

  • Administrative Assistant
  • Office Clerk
  • Data Entry Operator
  • Customer Service Assistant
  • Office Administrator
  • Junior Business Support Officer

Course Curriculum

Module : 1
Identify the Components of the Word Interface 00:30:00
Create a Word Document 00:30:00
Help 00:30:00
Navigate and Select Text 00:30:00
Modify Text 00:30:00
Find and Replace Text 00:30:00
Apply Character Formatting 00:30:00
Align Text Using Tabs 00:30:00
Display Text as List Items 00:30:00
Control Paragraph Layout 00:30:00
Apply Borders and Shading 00:30:00
Apply Styles 00:30:00
Manage Formatting 00:30:00
Insert a Table 00:30:00
Modify a Table 00:30:00
Format a Table 00:30:00
Convert Text to a Table 00:30:00
Sort a List 00:30:00
Renumber a List 00:30:00
Customize a List 00:30:00
Insert Symbols and Special Characters 00:30:00
Add Images to a Document 00:30:00
Apply a Page Border and Color 00:30:00
Add a Watermark 00:30:00
Add Headers and Footers 00:30:00
Control Page Layout 00:30:00
Check Spelling and Grammar 00:30:00
Other Proofing Tools 00:30:00
Check Accessibility 00:30:00
Customize the Word Interface 00:30:00
Additional Save Options 00:30:00
Manage Additional File Types 00:30:00
Activities – Microsoft Word 2016 for Beginners 00:00:00
Module : 2
Identify the Elements of the Excel Interface 00:30:00
Activity – Identify the Elements of the Excel Interface 00:05:00
Create a Basic Worksheet 01:00:00
Activity – Create a Basic Worksheet 00:05:00
Use the Help System 00:15:00
Activity – Use the Help System 00:05:00
Create Formulas in a Worksheet 01:00:00
Activity – Create Formulas in a Worksheet 00:05:00
Insert Functions in a Worksheet 00:30:00
Activity – Insert Functions in a Worksheet 00:05:00
Reuse Formulas 00:30:00
Activity – Reuse Formulas 00:05:00
Manipulate Data 00:30:00
Activity – Manipulate Data 00:05:00
Insert, Manipulate, and Delete Cells, Columns, and Rows 00:30:00
Activity – Insert, Manipulate, and Delete Cells, Columns, and Rows 00:05:00
Search For and Replace Data 00:30:00
Activity – Search For and Replace Data 00:05:00
Spell Check a Worksheet 00:30:00
Activity – Spell Check a Worksheet 00:05:00
Modify Fonts 00:30:00
Activity – Modify Fonts 00:05:00
Add Borders and Colors to Cells 01:00:00
Activity – Add Borders and Colors to Cells 00:05:00
Apply Number Formats 00:30:00
Activity – Apply Number Formats 00:05:00
Align Cell Contents 00:30:00
Activity – Align Cell Contents 00:05:00
Apply Cell Styles 00:30:00
Activity – Apply Cell Styles 00:05:00
Define the Basic Page Layout for a Workbook 01:00:00
Activity – Define the Basic Page Layout for a Workbook 00:05:00
Refine the Page Layout and Apply Print Options 00:30:00
Activity – Refine the Page Layout and Apply Print Options 00:05:00
Format Worksheet Tabs 00:30:00
Activity – Format Worksheet Tabs 00:05:00
Manage Worksheets 00:30:00
Activity – Manage Worksheets 00:05:00
Manage the View of Worksheets and Workbooks 00:30:00
Activity – Manage the View of Worksheets and Workbooks 00:05:00
Customize General and Language Options 00:30:00
Activity – Customize General and Language Options 00:05:00
Customize Formula Options 00:30:00
Activity – Customize Formula Options 00:05:00
Customize Proofing and Save Options 01:00:00
Activity – Customize Proofing and Save Options 00:05:00
Customize the Ribbon and Quick Access Toolbar 00:30:00
Activity – Customize the Ribbon and Quick Access Toolbar 00:05:00
Customize the Functionality of Excel by Enabling Add-Ins 00:30:00
Activity – Customize the Functionality of Excel by Enabling Add-Ins 00:05:00
Customize Advanced and Trust Center Options 00:30:00
Activity – Customize Advanced and Trust Center Options 00:05:00
Activities and Exercise Files – Microsoft Excel 2016 for Beginners 00:00:00
Module : 3
Navigate the PowerPoint Environment 00:30:00
ACTIVITY – NAVIGATING THE POWERPOINT 2016 USER INTERFACE 00:05:00
Create and Save a PowerPoint Presentation 00:15:00
ACTIVITY – CREATING AND SAVING A POWERPOINT PRESENTATION 00:05:00
Use Help 00:15:00
ACTIVITY – USING POWERPOINT HELP 00:05:00
Select a Presentation Type 00:15:00
ACTIVITY – SELECTING A PRESENTATION TYPE 00:05:00
Build a Presentation 00:15:00
ACTIVITY – BUILDING A PRESENTATION 00:05:00
Lay Out a Presentation 00:15:00
ACTIVITY – LAYING OUT A PRESENTATION 00:05:00
Edit Text 00:15:00
ACTIVITY – EDITING TEXT 00:05:00
View and Navigate a Presentation 00:15:00
ACTIVITY – VIEWING A PRESENTATION 00:05:00
Format Characters 00:15:00
ACTIVITY – FORMATTING CHARACTERS 00:05:00
Format Paragraphs 00:30:00
ACTIVITY – FORMATTING PARAGRAPHS 00:05:00
Format Text Boxes 00:15:00
ACTIVITY – FORMATTING TEXT BOXES 00:05:00
Insert Images 00:30:00
ACTIVITY – INSERTING IMAGES 00:05:00
Insert Shapes 00:15:00
ACTIVITY – INSERTING SHAPES 00:05:00
Insert WordArt 00:15:00
ACTIVITY – INSERT WORDART 00:05:00
Edit Objects 00:30:00
ACTIVITY – EDITING OBJECTS 00:05:00
Format Objects 00:15:00
ACTIVITY – FORMATTING OBJECTS 00:05:00
Group Objects 00:15:00
ACTIVITY – GROUPING OBJECTS 00:05:00
Arrange Objects 00:15:00
ACTIVITY – ARRANGING OBJECTS 00:05:00
Animate Objects 00:15:00
ACTIVITY – ANIMATING OBJECTS 00:05:00
Create a Table 00:15:00
ACTIVITY – CREATING A TABLE 00:05:00
Format a Table 00:15:00
ACTIVITY – FORMATTING A TABLE 00:05:00
Insert a Table from Other Microsoft Office Applications 00:15:00
ACTIVITY – INSERTING A TABLE FROM MICROSOFT EXCEL 00:05:00
Create a Chart 00:15:00
ACTIVITY – CREATING A CHART 00:05:00
Format a Chart 00:15:00
ACTIVITY – FORMATTING A CHART 00:05:00
Manipulate a Chart 00:15:00
ACTIVITY – MANIPULATING A CHART 00:05:00
Insert a Chart from Microsoft Excel 00:15:00
ACTIVITY – INSERTING A CHART FROM MICROSOFT EXCEL 00:05:00
Review Your Presentation 00:30:00
ACTIVITY – REVIEWING YOUR PRESENTATION 00:05:00
Apply Transitions 00:15:00
ACTIVITY – APPLYING TRANSITIONS 00:05:00
Print Your Presentation 00:15:00
ACTIVITY – PRINTING YOUR PRESENTATION 00:05:00
Deliver Your Presentation 01:00:00
ACTIVITY – DELIVERING YOUR PRESENTATION 00:05:00
Activities – Microsoft PowerPoint 2016 for Beginners 00:00:00
Module : 4
Navigate the Outlook Interface 00:15:00
ACTIVITY – NAVIGATING THE OUTLOOK INTERFACE 00:05:00
Perform Basic E-mail Functions 00:30:00
ACTIVITY – PERFORMING BASIC E-MAIL FUNCTIONS 00:05:00
Use Outlook Help 00:15:00
ACTIVITY – GETTING HELP IN MICROSOFT OUTLOOK 2016 00:05:00
Create an E-mail Message 00:15:00
ACTIVITY – CREATING AN E-MAIL MESSAGE 00:05:00
Check Spelling and Grammar 00:15:00
ACTIVITY – CHECK SPELLING AND GRAMMAR 00:05:00
Format Message Content 00:15:00
ACTIVITY – FORMAT MESSAGE CONTENT 00:05:00
Attach Files and Items 00:15:00
ACTIVITY – ATTACHING A FILE TO A MESSAGE 00:05:00
Enhance an E-mail Message 00:30:00
ACTIVITY – ENHANCING AN E-MAIL MESSAGE 00:05:00
Manage Automatic Message Content 00:15:00
ACTIVITY – MANAGING AUTOMATIC MESSAGE CONTENT 00:05:00
Customize Reading Options 00:15:00
ACTIVITY – CUSTOMIZING READING OPTIONS 00:05:00
Work with Attachments 00:15:00
ACTIVITY – WORKING WITH ATTACHMENTS 00:05:00
Manage Your Message Responses 00:15:00
ACTIVITY – MANAGING YOUR MESSAGE RESPONSES 00:05:00
Manage Messages Using Tags, Flags, and Other Commands 00:15:00
ACTIVITY – MANAGING MESSAGES USING TAGS, FLAGS AND OTHER COMMANDS 00:05:00
Organize Messages Using Folders 00:15:00
ACTIVITY – ORGANIZING MESSAGES USING FOLDERS 00:04:00
View the Calendar 00:15:00
ACTIVITY – CUSTOMIZING YOUR CALENDAR VIEW 00:05:00
Manage Appointments 00:15:00
ACTIVITY – MANAGING APPOINTMENTS 00:05:00
Manage Meetings 00:30:00
ACTIVITY – CREATING AND MANAGING MEETINGS 00:05:00
Print Your Calendar 00:15:00
ACTIVITY – PRINTING YOUR CALENDAR 00:05:00
Create and Update Contacts 00:15:00
ACTIVITY – CREATING AND UPDATING CONTACTS 00:05:00
View and Organize Contacts 00:15:00
ACTIVITY – VIEW AND ORGANIZE CONTACTS 00:05:00
Create Tasks 00:15:00
ACTIVITY – CREATING TASKS 00:05:00
Manage Tasks 00:15:00
ACTIVITY – MANAGING TASKS 00:05:00
Manage Notes 00:15:00
ACTIVITY – CREATING AND MANAGING NOTES 00:05:00
Customize the Outlook Interface 00:30:00
ACTIVITY – CUSTOMIZING THE OUTLOOK INTERFACE 00:05:00
Create and Manage Quick Steps 00:15:00
ACTIVITY – CREATING AND MANAGING QUICK STEPS 00:05:00
Activities – Microsoft Outlook 2016 for Beginners 00:00:00
Module : 5
Orientation to Microsoft Access 01:00:00
Create a Simple Access Database 01:00:00
Get Help in Microsoft Access 00:30:00
Modify Table Data 00:30:00
Working With Records 00:15:00
Sort and Filter Records 00:30:00
Create Lookups 01:00:00
Join Data from Different Tables in a Query 01:00:00
Sort and Filter Data in a Query 01:00:00
Perform Calculations in a Query 00:30:00
Create Parameter Queries 00:30:00
Create Action Queries 00:30:00
Create Find Duplicate and Find Unmatched Queries 00:30:00
Summarize Data 00:30:00
Create a Report 01:00:00
Add Controls to a Report 00:30:00
Enhance the Appearance of a Report 00:30:00
The Access Options Dialog Box 01:00:00
Create a Table 01:00:00
Modify a Table and Fields 00:30:00
Create Table Relationships 00:30:00
Create Query Joins 00:30:00
Join Tables That Have No Common Fields 00:30:00
Relate Data within a Table 00:30:00
Work with Subdatasheets 00:30:00
Create Subqueries 00:30:00
Data Normalization 01:00:00
Create a Junction Table 00:30:00
Import Data into Access 00:30:00
Export Data to Text File Formats 00:30:00
Export Access Data to Excel 00:30:00
Create a Mail Merge 00:30:00
Organize Report Information 00:30:00
Format Reports 00:30:00
Include Charts in a Report 00:30:00
Add a Calculated Field to a Report 00:30:00
Add a Subreport to an Existing Report 00:30:00
Create a Mailing Label Report 00:30:00
Publish a Report as PDF 00:30:00
Activities – Microsoft Outlook 2016 for Beginners 00:00:00
Mock Exam
Mock Exam – Microsoft Office 2016 Complete Course for Beginners 00:20:00
Final Exam
Final Exam – Microsoft Office 2016 Complete Course for Beginners 00:20:00
Order your Certificates & Transcripts
Order your Certificates & Transcripts 00:00:00

Original price was: £319.Current price is: £25. ex Vat

SAVE 92% - OFFER ENDS IN

Description of image
TAKE THIS COURSE
Or
ALL COURSES FOR £49
moneyback 14-Day Money-Back Guarantee
  • Personal
  • Team
  • Level
  • CertificateYes
  • Duration 3 days, 7 hours
£25 /Unit Price
Quantity:
Total:
£250.00
Add to Cart
Buying more than one of the same course?
50% discount for orders of 10+ courses
60% discount for orders of 50+ courses
70% discount for orders of 100+ courses
For more personalised package, contact us
  • cpd uk
  • Tutor support
  • qls

Frequently asked questions

Can’t find the anwser you’re looking for ? Reach out to customer support team.

What is Microsoft Office 2016?

Microsoft Office 2016 is a suite of productivity applications used for documents, spreadsheets, presentations, and email.

What will I learn in this course?

You will learn Word, Excel, PowerPoint, and Outlook basics for professional and personal use.

Is this course suitable for beginners?

Yes. It is designed for complete beginners with no prior experience.

Why are Microsoft Office skills important?

They are essential for most office, business, and administrative jobs.

What is Microsoft Word used for?

Word is used for creating and formatting documents such as letters and reports.

What is Microsoft Excel used for?

Excel is used for data entry, calculations, charts, and spreadsheets.

What is Microsoft PowerPoint used for?

PowerPoint is used to create presentations with slides, text, and visuals.

Where are Microsoft Office skills used?

They are used in offices, schools, businesses, hospitals, and almost every industry.

Is Microsoft Office a good career skill?

Yes. It is one of the most in-demand workplace skills.

Can I continue studying after this course?

Yes. You can progress into advanced Office, IT, data analysis, or business administration.

What career opportunities are available after completing this course?

Career opportunities include Administrative Assistant, Office Clerk, Data Entry Operator, Receptionist, Customer Service Assistant, Office Administrator, Secretarial Assistant, and Junior Business Support Officer.

Popular Categories
Important Links
Information
Certificate Validator
  • Facebook
  • YouTube
  • tiktok
  • instagram
  • pinterest
top