Microsoft Office 2016 Essentials

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 sub queries, 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

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.

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.