Development
QLS
Business
Healthcare
Health & Fitness
Technology
Teaching
Lifestyle
Design
About This Course
Introduction
If you are looking forward to learning each and every single details of Microsoft Office, then you are at the right place. Microsoft Office 2016 Online- Word, Excel, PowerPoint, Outlook, Access is designed for beginners to grasp Microsoft Office and all of its features. This course will teach all the essential functions of Word, Excel, PowerPoint, Outlook and Access.
Course description
Initially, you will learn about the basic features of Microsoft Word such as creating a new document, personalizing the Microsoft Word interface, adding graphics, etc. Besides, you will learn about the techniques of 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, adjust cells, create columns, rows and much more. Next, Microsoft PowerPoint will help you to learn to navigate the PowerPoint environment, create and save PowerPoint presentation, delivering advanced text editing etc.
Microsoft Outlook will help you to set up and use Outlook on Windows. It will also assist you in creating and sending messages, managing contacts, using the calendar, managing tasks, working with notes and much more.
Overall, this course gives you all information to access Microsoft Office 2016. Register today and get benefit from this course.
Course design
The course is delivered through our online learning platform, accessible through any internet-connected device. There are no formal deadlines or teaching schedules, meaning you are free to study the course at your own pace.
You are taught through a combination of
- Video lessons
- Online study materials
- Mock exams
- Multiple-choice assessment
How is the course assessed?
To successfully complete the course you must pass an automated, multiple-choice assessment. The assessment is delivered through our online learning platform. You will receive the results of your assessment immediately upon completion.
Will I receive a certificate of completion?
Upon successful completion, you will qualify for the UK and internationally-recognised certificate and you can choose to make your achievement formal by obtaining your PDF Certificate at a cost of £9 and Hardcopy Certificate for £15.
Why study this course
Whether you’re an existing practitioner or aspiring professional, this course will enhance your expertise and boost your CV with key skills and an accredited qualification attesting to your knowledge.
The Microsoft Office 2016 Online- Word, Excel, PowerPoint, Outlook, Access is open to all, with no formal entry requirements. All you need is a passion for learning, a good understanding of the English language, numeracy and IT, and to be over the age of 16.
Course Curriculum
-
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
-
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:15: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
-
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
-
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
-
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
-
Working With Records
00:15: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
-
The Access Options Dialog Box
01:00: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
Subscribe to this course and 2,000+ top‑rated Training Express courses for your organization.
Try imperial academy business
Add to Cart
