Name: Complete Microsoft Office 2016
Price: 24.99 GBP
Rating: 4.7 (9 reviews)

Microsoft Office is the world’s most popular office software. The suite is now an essential in everyday business life wherever you go in the world.

This Complete Microsoft Office 2016 covers the whole Microsoft suite, so whether you’re a beginner, or have some experience, you’ll soon have a wealth of knowledge and skills. The course is designed to help you accomplish office tasks easily and with greater efficiency, Microsoft Office is the choice of many office professionals. You’ll likely find it in nearly every business around the globe, and this training will help ensure you stay on top of ever-changing improvements in office productivity.

Learning Outcomes:

Discover new and improved features in Excel 2016
How create, save, and open a workbook
How to use and how to customize the Quick Access Toolbar
The basics of entering and editing data in a workbook

Method of Assessment:

Upon conclusion of the course, there’s an online multiple-choice quiz assessment, which will determine whether you have passed the course. The test is marked immediately and results are published instantly (60% pass mark).

Certification:

Certificates can be obtained at an additional cost of £9.99 for PDF, £16.99 for Printed Hardcopy format and £24.99 for Both for Both PDF and Hardcopy Certificates.

Requirements

There are no academic entry requirements for this course, and it is open to students of all academic backgrounds.

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 Beginner	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 Beginner	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
	Mock Exam – Complete Microsoft Office 2016	00:30:00
Final Exam
	Final Exam – Complete Microsoft Office 2016	00:30:00