Review.io
  • user_iconLOGIN
  • cart_icon

    No products in the basket.

Microsoft Office 2019

Level 7 QLS endorsed | 24/7 Student Support

883 Students enrolled on this course 4 (1 Reviews)

clock Last updated March 20, 2024

Complete Microsoft Office 2019 Overview

The Microsoft Office 2019 is designed to educate you with everything you need to use the universal software – Microsoft Office to your advantage and boost your work efficiency. Through this course, you will master the incredibly useful applications of Microsoft Office such as Word, Excel, PowerPoint, Access, and Outlook.

This comprehensive Microsoft Office course at QLS Level 7 course also helps in identifying new and enhanced features of all applications in MS Office. In addition, you will get the chance for improving your Microsoft Office skills for work, new career prospects, or simply enhancing your CV.

Successful completion of this course will give an edge to your career and help to build your abilities in using the applications more confidently and efficiently.

Why Choose this Course

Course Design

The course is delivered through our online learning platform, accessible through any internet-connected device. Furthermore, 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-

Certificate of Achievement

Endorsed Certificate of Achievement from the Quality Licence Scheme

Once the course has been completed and the assessment has been passed, all students are entitled to receive an endorsed certificate. This will provide proof that you have completed your training objectives, and each endorsed certificate can be ordered and delivered to your address for only £119. Please note that overseas students may be charged an additional £10 for postage.

CPD Certificate of Achievement from Janets

Upon successful completion of the course, you will be able to obtain your course completion e-certificate. Print copy by post is also available at an additional cost of £9.99 and PDF Certificate at £4.99.

Endorsement

This course and/or training programme has been endorsed by the Quality Licence Scheme for its high-quality, non-regulated provision and training programmes. This course and/or training programme is not regulated by Ofqual and is not an accredited qualification. Your training provider will be able to advise you on any further recognition, for example progression routes into further and/or higher education. For further information please visit the Learner FAQs on the Quality Licence Scheme website.

Method of Assessment

In order to ensure the Quality Licensing scheme endorsed and CPD acknowledged certificate, learners need to score at least 60% pass marks on the assessment process. After submitting assignments, our expert tutors will evaluate the assignments and give feedback based on the performance. When the student passes the assessment, thry can apply for a certificate.

Who is this course for?

The Microsoft Office 2019 is suitable for anyone who wants to gain extensive knowledge, potential experience, and expert skills in the related field. This is also a great opportunity for all student from any academic backgrounds to learn more about this subject.

Course Curriculum

Microsoft Excel 2019
Microsoft Excel 2019 New Features
Introduction to Microsoft Excel 2019 New Features 00:07:00
CONCAT 00:02:00
IFS 00:01:00
MAXIFS 00:01:00
MINIFS 00:01:00
SWITCH 00:02:00
TEXTJOIN 00:01:00
Map Chart 00:02:00
Funnel Chart 00:01:00
Better Visuals 00:06:00
Pivot Table Enhancements 00:02:00
Power Pivot Updates 00:01:00
Getting Started with Microsoft Excel
Navigate the Excel User Interface 00:28:00
Use Excel Commands 00:10:00
Create and Save a Basic Workbook 00:19:00
Enter Cell Data 00:12:00
Use Excel Help 00:05:00
Performing Calculations
Create Worksheet Formulas 00:15:00
Insert Functions 00:17:00
Reuse Formulas and Functions 00:17:00
Modifying a Worksheet
Insert, Delete, and Adjust Cells, Columns, and Rows 00:10:00
Search for and Replace Data 00:09:00
Use Proofing and Research Tools 00:07:00
Formatting a Worksheet
Apply Text Formats 00:17:00
Apply Number Format 00:08:00
Align Cell Contents 00:09:00
Apply Styles and Themes 00:12:00
Apply Basic Conditional Formatting 00:11:00
Create and Use Templates 00:07:00
Printing Workbooks
Preview and Print a Workbook 00:10:00
Set Up the Page Layout 00:08:00
Configure Headers and Footers 00:07:00
Managing Workbooks
Manage Worksheets 00:05:00
Manage Workbook and Worksheet Views 00:07:00
Manage Workbook Properties 00:05:00
Microsoft Word 2019
Microsoft Word 2019 New Features
Introduction to Microsoft Word 2019 New Features 00:14:00
Inking Tools 00:03:00
Inking Tools 1 00:07:00
Learning Tools 00:07:00
Microsoft Translate 00:03:00
LaTeX 00:05:00
Smart Lookup 00:04:00
Side to Side Scrolling 00:02:00
Scalable Vector Graphics 00:03:00
Getting Started with Word
Navigate in Microsoft Word 00:12:00
Create and Save Word Documents 00:24:00
Manage Your Workspace 00:06:00
Edit Documents 00:16:00
Preview and Print Documents 00:04:00
Customize the Word Environment 00:08:00
Formatting Text and Paragraphs
Apply Character Formatting 00:17:00
Control Paragraph Layout 00:19:00
Align Text Using Tabs 00:07:00
Display Text in Bulleted or Numbered Lists 00:03:00
Apply Borders and Shading 00:04:00
Working More Efficiently
Make Repetitive Edits 00:06:00
Apply Repetitive Formatting 00:10:00
Use Styles to Streamline Repetitive Formatting Tasks 00:14:00
Managing Lists
Sort a List 00:05:00
Format a List 00:06:00
Adding Tables
Insert a Table 00:07:00
Modify a Table 00:06:00
Format a Table 00:03:00
Convert Text to a Table 00:04:00
Inserting Graphic Objects
Insert Symbols and Special Characters 00:04:00
Add Images to a Document 00:11:00
Controlling Page Appearance
Apply a Page Border and Color 00:03:00
Add Headers and Footers 00:06:00
Control Page Layout 00:05:00
Add a Watermark 00:04:00
Preparing to Publish a Document
Check Spelling Grammar and Readability 00:07:00
Use Research Tools 00:06:00
Check Accessibility 00:03:00
Save a Document to Other Formats 00:04:00
Workbooks - Microsoft Word 2016 (Beginner)
Workbooks – Microsoft Word 2019 00:00:00
Microsoft PowerPoint 2019
Microsoft PowerPoint 2019 New Features
Introduction to Microsoft PowerPoint 2019 New Features 00:06:00
Highlighting 00:02:00
Morph Transition 00:03:00
Zoom 00:03:00
Vector Graphics 00:03:00
SVG Icons to Shapes 00:04:00
3D Modeling 00:04:00
Background Removal 00:03:00
4K 00:03:00
PowerPoint Interface
Navigate the PowerPoint Environment 00:28:00
View and Navigate a Presentation 00:15:00
Create and Save a PowerPoint Presentation 00:13:00
Use PowerPoint Help 00:10:00
Presentation Basics
Select a Presentation Type 00:08:00
Edit Text 00:13:00
Build a Presentation 00:27:00
Formatting
Format Characters 00:11:00
Format Paragraphs 00:16:00
Format Text Boxes 00:09:00
Inserting Options
Insert Images 00:10:00
Insert Shapes 00:15:00
Working with Objects
Edit Objects 00:16:00
Format Objects 00:06:00
Group Objects 00:04:00
Arrange Objects 00:07:00
Animate Objects 00:07:00
Table
Create a Table 00:09:00
Format a Table 00:03:00
Insert a Table from Other Microsoft Office Applications 00:06:00
Charts
Create a Chart 00:10:00
Format a Chart 00:10:00
Insert a Chart from Microsoft Excel 00:05:00
Review and Presentation
Review Your Presentation 00:11:00
Apply Transitions 00:05:00
Print Your Presentation 00:05:00
Deliver Your Presentation 00:08:00
Microsoft Access 2019
Microsoft Access 2019 New Features
Introduction to Microsoft Access 2019 New Features 00:05:00
Window Resize 00:01:00
Charts 00:02:00
dbf 00:01:00
Large Number 00:01:00
Property Sorting 00:01:00
Introduction to Access
Orientation to Microsoft Access 00:39:00
Create a Simple Access Database 00:10:00
Get Help and Configure Options in Microsoft Access 00:06:00
Modify Data
Modify Table Data 00:17:00
Sort and Filter Records 00:05:00
Working with Queries
Create Basic Queries 00:15:00
Sort and Filter Data in a Query 00:14:00
Perform Calculations in a Query 00:08:00
Access Forms
Create Basic Access Forms 00:07:00
Work with Data on Access Forms 00:23:00
Working with Reports
Create a Report 00:23:00
Add Controls to a Report 00:12:00
Enhance the Appearance of a Report 00:05:00
Prepare a Report for Print 00:03:00
Organize Report Information 00:15:00
Format Reports 00:12:00
Assignment
Assignment – Microsoft Office 2019 3 weeks, 4 days
Recommended Materials
Workbook – Microsoft Office 2019 2 weeks, 1 day
Order Your Certificate
Order your Certificate QLS 00:00:00

Course Reviews

4

4
1 ratings
  • 5 stars0
  • 4 stars1
  • 3 stars0
  • 2 stars0
  • 1 stars0
  1. Microsoft Office 2019

    4

    An easy to follow and comprehensive course.

£25

92% OFF

moneyback 14-Day Money-Back Guarantee
  • Level
  • Certificate Yes
  • Units 136
  • Quizzes 0
  • Duration 1 month, 1 week
  • cpd uk
  • qls
  • fully online

    Fully Online

Frequently asked questions

Can’t find the anwser you’re looking for ? Reach out to customer support team.

Are there any prerequisites for taking the course?

There are no specific prerequisites for this course, nor are there any formal entry requirements. All you need is an internet connection, a good understanding of English and a passion for learning for this course.

Can I access the course at any time, or is there a set schedule?

You have the flexibility to access the course at any time that suits your schedule. Our courses are self-paced, allowing you to study at your own pace and convenience.

How long will I have access to the course?

For this course, you will have access to the course materials for 1 year only. This means you can review the content as often as you like within the year, even after you've completed the course. However, if you buy Lifetime Access for the course, you will be able to access the course for a lifetime.

Is there a certificate of completion provided after completing the course?

Yes, upon successfully completing the course, you will receive a certificate of completion. This certificate can be a valuable addition to your professional portfolio and can be shared on your various social networks.

Can I switch courses or get a refund if I'm not satisfied with the course?

We want you to have a positive learning experience. If you're not satisfied with the course, you can request a course transfer or refund within 14 days of the initial purchase.

How do I track my progress in the course?

Our platform provides tracking tools and progress indicators for each course. You can monitor your progress, completed lessons, and assessments through your learner dashboard for the course.

What if I have technical issues or difficulties with the course?

If you encounter technical issues or content-related difficulties with the course, our support team is available to assist you. You can reach out to them for prompt resolution.

Home Search Cart Your Offers