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
Certification is available –
- In PDF for £2.99
- Hard copy for £8.99
Course Reviews
4.7
- 5 stars0
- 4 stars0
- 3 stars0
- 2 stars0
- 1 stars0
No Reviews found for this course.
- PRIVATE
- 1 year
- Advanced
- Number of Units288
- Number of Quizzes0
- 3 days, 19 hours
More courses for you
No related courses found