Microsoft Office 2016 Complete Course

Over 80% of UK job listings require proficiency in Microsoft Office. Enhancing your skills in Office 2016 can increase your employability and pave the way for career advancement. Dive into the essentials of Microsoft Office 2016 with our comprehensive course designed for beginners. Whether you’re new to Office or looking to refresh your skills, this course offers a deep dive into Word, Excel, PowerPoint, Outlook, and Access.

Structured in five detailed modules, each section of this Microsoft Office course is dedicated to maximising your proficiency in one of these critical Office components. Embark on a journey from the basics to more advanced features, with each module carefully crafted to build your skills step-by-step. Through 30-minute focused lessons and hands-on activities, you’ll gain confidence in navigating interfaces, creating compelling documents, analysing data, and much more.

Enhance your skillset, boost your productivity, and open doors to new career opportunities with our Microsoft Office 2016 Complete Course for Beginners. Enrol now and take the first step towards mastering Microsoft Office 2016!

What Will You Learn?

Navigating and customising the interface for each Office application.
Creating, formatting, and managing documents in Word.
Building spreadsheets, using formulas, and analysing data in Excel.
Designing impactful presentations with PowerPoint.
Managing emails effectively and organising your schedule in Outlook.
Developing and managing databases in Access.
Enhancing your productivity with Office 2016’s comprehensive tools.
Practical skills through guided activities and real-world scenarios.

Microsoft Office 2016 Complete Course For Beginners Curriculum

Module: 1

Identify the Components of the Word Interface
Create a Word Document
Help
Navigate and Select Text
Modify Text
Find and Replace Text
Apply Character Formatting
Align Text Using Tabs
Display Text as List Items
Control Paragraph Layout
And So On...

Module: 2

Identify the Elements of the Excel Interface
Activity – Identify the Elements of the Excel Interface
Create a Basic Worksheet
Activity – Create a Basic Worksheet
Use the Help System
Activity – Use the Help System
Create Formulas in a Worksheet
Activity – Create Formulas in a Worksheet
Insert Functions in a Worksheet
Activity – Insert Functions in a Worksheet
Reuse Formulas
Activity – Reuse Formulas
Manipulate Data
Activity – Manipulate Data
Insert, Manipulate, and Delete Cells, Columns, and Rows
Activity – Insert, Manipulate, and Delete Cells, Columns, and Rows
Search For and Replace Data
Activity – Search For and Replace Data
And So On...

Module : 3

Navigate the PowerPoint Environment
ACTIVITY – NAVIGATING THE POWERPOINT 2016 USER INTERFACE
Create and Save a PowerPoint Presentation
ACTIVITY – CREATING AND SAVING A POWERPOINT PRESENTATION
Use Help
ACTIVITY – USING POWERPOINT HELP
Select a Presentation Type
ACTIVITY – SELECTING A PRESENTATION TYPE
Build a Presentation
ACTIVITY – BUILDING A PRESENTATION
Lay Out a Presentation
ACTIVITY – LAYING OUT A PRESENTATION
Edit Text
ACTIVITY – EDITING TEXT
View and Navigate a Presentation
ACTIVITY – VIEWING A PRESENTATION
Format Characters
ACTIVITY – FORMATTING CHARACTERS
Format Paragraphs
ACTIVITY – FORMATTING PARAGRAPHS
Format Text Boxes
ACTIVITY – FORMATTING TEXT BOXES
Insert Images
ACTIVITY – INSERTING IMAGES

Module: 4

Navigate the Outlook Interface
ACTIVITY – NAVIGATING THE OUTLOOK INTERFACE
Perform Basic E-Mail Functions
ACTIVITY – PERFORMING BASIC E-MAIL FUNCTIONS
Use Outlook Help
ACTIVITY – GETTING HELP IN MICROSOFT OUTLOOK 2016
Create An E-Mail Message
ACTIVITY – CREATING AN E-MAIL MESSAGE
Check Spelling And Grammar
ACTIVITY – CHECK SPELLING AND GRAMMAR
Format Message Content
And So On...

Module: 5

Orientation to Microsoft Access
Create a Simple Access Database
Get Help In Microsoft Access
Modify Table Data
Working With Records
Sort and Filter Records
Create Lookups
Join Data from Different Tables in a Query
Sort and Filter Data in a Query
Perform Calculations in a Query
Create Parameter Queries
Create Action Queries
Create Find Duplicate and Find Unmatched Queries
Summarize Data
Create a Report
Add Controls to a Report
Enhance the Appearance of a Report
The Access Options Dialog Box
And So On...

Why Choose Teachers Training

Some of our website features are:

This is a dedicated website for teaching
24/7 tutor support
Interactive Content
Affordable price
Courses accredited by the UK's top awarding bodies
100% online
Flexible deadline

Entry Requirements

No formal entry requirements. You need to have:

Passion for learning
A good understanding of the English language
Be motivated and hard-working
Over the age of 16.

Certification

CPD Certification from The Teachers Training

Successfully completing the MCQ exam of this course qualifies you for a CPD-accredited certificate from The Teachers Training. You will be eligible for both PDF copy and hard copy of the certificate to showcase your achievement however you wish.

You can get your digital certificate (PDF) for £4.99 only
Hard copy certificates are also available, and you can get one for only £10.99
You can get both PDF and Hard copy certificates for just £12.99!

The certificate will add significant weight to your CV and will give you a competitive advantage when applying for jobs.

Microsoft Word Masterclass

Microsoft Office 2016 Complete Course For Beginners