No products in the basket.
LOGIN

Welcome to

Course Cloud

the best place for online learning!

Keep me logged in

Forgot Password?

Don’t have an account yet? Sign Up

Already have an account? Log In

By signing up, I accept Course Cloud’s Terms & Conditions

Microsoft Office 2019 (Updated and New Features 2022)

What Will I Learn? Learn the essential functions of Microsoft Office including Microsoft Word, Microsoft Excel, Microsoft PowerPoint, and Microsoft …

★ ★ ★ ★ ★

4.8(13 reviews)

62 enrolled on this course

What Will I Learn?

Learn the essential functions of Microsoft Office including Microsoft Word, Microsoft Excel, Microsoft PowerPoint, and Microsoft Access

Explore the formatting and editing tools with this Microsoft Office Bundle

Understand how to create and format spreadsheets in Microsoft Excel

Discover how to create professional presentations in Microsoft PowerPoint

Explore the basic and advanced functions of Microsoft Access

Course Overview

Learn new skills and develop your professional knowledge with our Advanced Diploma in Microsoft Office and learn from home at a pace that suits you. The Microsoft Office 2019 (Updated and New Features 2022) course has been expertly designed for you to complete through distance e-learning and achieve a professional qualification without leaving your own home!

Learn and Explore the New Features of Microsoft Office 2019 (Updated and New Features 2022) in this course.

From creating documents and spreadsheets, to presenting information in a slide show and managing projects, this Microsoft Office 2019 (Updated and New Features 2022) course is your step-by-step guide to getting it all done. Get started now, and be on your way to mastering Word, PowerPoint, Excel, and more.

Learn the skills you’ll need to improve your CV and land the job of your dreams. Complete the Advanced Diploma in Microsoft Office to earn an industry-recognized credential that will help you excel in the workplace.

Become confident of your abilities and use them to develop your profile online and in the marketplace.

Preview

Certificate of achievement

CPD Certification from Course Cloud

After successfully completing the course, you will be able to get the UK and internationally accepted certificate to share your achievement with potential employers or include it in your CV. The PDF Certificate + Transcript is available at £6.99 (Special Offer - 50% OFF). In addition, you can get a hard copy of your certificate for £12 (Shipping cost inside the UK is free, and outside the UK is £9.99).

Method of Assessment

To successfully complete the course, you will have to take an Assignment. You will have to score at least 60% to pass the exam and qualify for Quality Licence Scheme endorsed, and CPD endorsed certificates. After passing the exam, you can apply for the certificates.

In addition, you are advised to complete the Assignment questions provided at the end of the course to enhance the depth of your knowledge regarding the course and further assess your learning. Our expert tutors will evaluate your submitted answers and will give you feedback on your current performance along with any further advice or support.

Course Curriculum

Microsoft Office 2019 (Updated and New Features 2022)
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:16: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:12:00
	Create and Use Templates	00:08:00
Printing Workbooks
	Preview and Print a Workbook	00:10:00
	Set Up the Page Layout	00:09: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:06: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:05: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 2016 (Beginner)	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:02: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 Presentatin
	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 (Updated and New Features 2022)	00:00:00