• No products in the basket.

Category:

£
4.7( 9 REVIEWS )
477 STUDENTS

Description:

Are you not familiar with Office 2016 and want to learn every single detail of it? Then you are at the right place!

Office 2016 Complete Course is designed for beginners to educate about Microsoft Office 2016. Initially, you will learn about the basic features of Microsoft Word such as creating a new document, personalizing the Microsoft Word interface, adding graphics, controlling page appearance, proofing and editing a document. Following that, you will learn about the foundations of Microsoft Office Excel that is essential to create and work with an electronic spreadsheet. You will be able to insert and delete text or images, create columns, rows and much more. Microsoft PowerPoint will help you in navigating the PowerPoint environment, create and save PowerPoint presentation, etc.

Microsoft Outlook will help you to set up and use Outlook on Windows, also assist you in creating and sending messages, managing contacts, working with notes, etc. You will learn related information to access Microsoft Office 2016. Additionally, you will learn Project management basics, adding tasks and resources to a project and saving them. In the course, you will learn the essential features of the latest version of Microsoft Visio and the basic information about the diagramming software.

Learning Outcomes:

  • Word 2016 user interface, creating basic documents and utilizing help
  • Managing text through modifying, finding and replacing, and selecting them; and arranging texts through tabs and lists
  • Understanding the commands on the home tab and mini toolbar
  • Paragraph layout tool, borders, shading, styles and formatting management techniques
  • Maximizing your ability to utilize tables within Word 2016
  • Inserting symbols and special characters along with techniques for adding them
  • Managing your page’s appearance with colours, borders, watermarks, headers, footers and page setup dialog box
  • Reviewing documents through spell check, research pane and thesaurus
  • Document accessibility options
  • Customizing the user interface, modifying save options and managing other file types
  • Familiarize the excel user interface, creating basic worksheet and using the help system
  • How to create formulas, reuse them and insert functions in a worksheet
  • Managing cells, columns and rows and ways to manipulate data
  • Utilizing the ‘Search and replace’ data options and spell checking
  • Modifying fonts, adding borders and colours to cells, using number formats, aligning cell contents and applying cell styles
  • Define and refine page layouts for printing options
  • Managing large workbooks through worksheet tab formatting and using different views
  • Options for general customization, language, formula, proofing and saving
  • Customizing Quick Access toolbar, ribbon, advanced and Trust Center options
  • Utilize Excel’s version control features and enabling add-ins
  • Utilize the PowerPoint user interface, creating and saving  presentations, and using help
  • Making presentations through presentation options like selecting types, building it, layouts, text editing, viewing and navigation
  • Discover methods for formatting characters, paragraphs, and text boxes
  • Adding images, screenshots, screen recordings, shapes and WordArt
  • Modifying options for objects and animation features
  • Creating and formatting a table and integrating data from other Microsoft Office applications
  • Create format and manipulate a chart
  • Navigate throughout the Outlook user interface and learn to perform basic email functions and utilize help
  • Composing emails, grammar and spell checks, formatting content, attaching files, enhancing messages and managing automatic message responses
  • Customize reading options, work with attachments and manage message responses
  • Managing and organization of messages with the help of tags, flags, other commands and folders
  • Using calendar options to manage appointments and meetings
  • Using People workspace to create, update, view and organise contacts
  • Managing tasks and notes
  • Creating and managing Quick Steps, and customizing the interface according to needs
  • Get familiarized with Microsoft Access 2016, create simple databases, and use the help options
  • Change table data, manage records and create lookups
  • Join data from different tables, sort and filter them, and perform calculations for queries
  • Creating, adding controls, enhancing appearance and print preparation for reports
  • How to utilize Access Options dialog box
  • Relational database design, creating tables, managing table fields and creating table relationships
  • Creating query joins and subqueries, joining tables with no common fields, relating data within a table, and working with sub datasheets
  • Data normalization and creating junction tables
  • Sharing Access data with other applications and through import and export options
  • Managing reports through organizing information, formatting, including charts, adding calculated fields and sub-report inclusion to existing ones
  • Create mailing label report and publishing reports in PDF format
  • Project management basics, navigating and customizing the user interface, adding tasks and resources to a project and saving them
  • Managing project time frames and changing working time
  • Managing project tasks, adding summary tasks and milestones
  • Managing project resources, allocating and levelling work resources
  • Sharing and exporting projects, and adjusting project print views
  • Navigation throughout Visio interface, creating basic drawing and using the help system
  • Drawing components, modifying drawings and work with callouts and groups
  • Organization charts creation, modifying their layouts, positioning and spacing
  • Create and integrate organization chart copies and compare them
  • Making a basic floor plan and custom room shapes, utilizing the program as a modelling tool and modelling room layouts
  • Creating cross-functional flowcharts and related features like – swimlanes and separators
  • Altering orientation and direction, changing margins and choosing styles for flowcharts
  • Creating network diagrams, and utilizing shape data and layers
  • Other network diagram relevant topics such as network shapes, shape data, adding layers, activating, colouring and more
  • Working with shape, connector styles, themes, variants and containers

Assessment:

  • At the end of the course, you will be required to sit for an online MCQ test. Your test will be assessed automatically and immediately. You will instantly know whether you have been successful or not.
  • Before sitting for your final exam you will have the opportunity to test your proficiency with a mock exam.

Certification:

  • After completing and passing the course successfully, you will be able to obtain an Accredited Certificate of Achievement.
  • Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24.

Who is this Course for?

Office 2016 Complete Course is certified by CPD Qualifications Standards and CiQ. This makes it 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.

Requirements

Our Office 2016 Complete Course is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation.

Career Path

After completing this course you will be able to build up accurate knowledge and skills with proper confidence to enrich yourself and brighten up your career in the relevant job market.

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:30: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
Work with Records 01:00: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
Prepare a Report for Print 00:30:00
The Access Options Dialog Box 01:00:00
Relational Database Design 00:30: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 Access 2016 for Beginners 00:00:00
Module - 6
Project Management 101 00:15:00
ACTIVITY – PROJECT MANAGEMENT 101 00:05:00
Navigate and Customize the Project 2016 Interface 00:30:00
ACTIVITY – NAVIGATING AND CUSTOMIZING THE PROJECT 2016 INTERFACE 00:05:00
Add Tasks to a Project 00:15:00
ACTIVITY – ADDING TASKS TO A PROJECT 00:05:00
Add Resources to a Project 00:15:00
ACTIVITY – ADDING RESOURCES TO A PROJECT 00:05:00
Save a Project 00:15:00
ACTIVITY – SAVING A PROJECT 00:05:00
Manage Project Time Frames 00:15:00
ACTIVITY – MANAGING PROJECT TIME FRAMES 00:05:00
Change Working Time 00:15:00
ACTIVITY – CHANGING THE WORKING TIME FOR A PROJECT 00:05:00
Manage Project Tasks 00:15:00
ACTIVITY – MANAGING PROJECT TASKS 00:05:00
Add Summary Tasks and Milestones 00:15:00
ACTIVITY – ADDING SUMMARY TASKS AND MILESTONES 00:05:00
Manage Project Resources 00:15:00
ACTIVITY – MANAGING PROJECT RESOURCES 00:05:00
Allocate and Level Work Resources 00:15:00
ACTIVITY – LEVELING RESOURCES 00:05:00
Print Project Views 00:15:00
ACTIVITY – PRINTING A PROJECT VIEW 00:05:00
Share Projects 00:15:00
ACTIVITY -SHARING PROJECTS 00:05:00
Export Projects 00:15:00
ACTIVITY – EXPORTING A PROJECT 00:05:00
Activities – Microsoft Project 2016 for Beginners 00:00:00
Module - 7
Navigate the Visio Environment 00:15:00
Create a Basic Drawing 00:30:00
Use the Help System 00:15:00
Use Drawing Components 00:30:00
Modify a Drawing 00:15:00
Work with Callouts and Groups 00:15:00
Create a Basic Organization Chart 00:30:00
Do More with Organization Charts 00:15:00
Make a Basic Floor Plan 00:30:00
Model a Room Layout 00:15:00
Create a Cross-Functional Flowchart 00:30:00
Modify a Cross-functional Flowchart 00:15:00
Create Network Diagrams 00:15:00
Use Shape Data 00:15:00
Use Layers 00:30:00
Work with Shape and Connector Styles 00:15:00
Work with Themes and Variants 00:15:00
Work with Containers 00:15:00
Activities – Microsoft Visio 2016 for Beginners 00:00:00
Mock Exam
Final Exam

Certificate of Achievement

CPD Accredited Certification

You will be eligible for CPD Accredited Certificates after completing this Course successfully.
Certification is available –
  1. In PDF for £2.99
  2. Hard copy for £8.99

Course Reviews

4.7

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

No Reviews found for this course.

  • PRIVATE
  • 1 year
  • Number of Units288
  • Number of Quizzes0
  • 3 days, 19 hours
EVERYTHING FOR LIFETIME £129
477 STUDENTS ENROLLED
    Thames-college-logo-white-2021

    We are a business that specialises in providing CPD & QLS accredited courses for anyone looking to advance their professional career.

    Address : 75 Nansen Road, Saltley, Birmingham, England, B8 3JP

    Email : info@thamescollege.org

    Phone Number : ​020 8124 5465

    Payment Methods

    lead-payment-logos

    Copyright © 2024 Thames College. All Right Reserved.

    top