MS Office Essential Updates 2019 - E-Learning Package

MS Office Essential Updates 2019 - E-Learning Package - CPDUK Accredited.

Welcome to The Mandatory Training Group's online MS Office Essential Updates 2019 training course. All our online training courses, programmes and qualifications are accredited by the CPD Certification Service (CPDUK).

MS Office Essential Updates 2019

Teacher - Barbara Evers and Kathy Jones

Learner - Christina Tankersley and Jason Farr

This online MS Office Essential Updates 2019 training package will teach you how to use all the features in MS Office 2019. You will master the essential knowledge and skills employers expect in Word, Outlook, Excel and PowerPoint with this MS Office Essential Update 2019.

Course content

This online MS Office Essential Updates 2019 training package covers the following modules:

Course aims

This MS Office Essential Updates 2019 e-learning package aims to:

• Develop knowledge and skills on the use of spreadsheets in both business and personal life
• Familiarise with common Excel functions used in the Office.

Learning objectives

On completion of this MS Office Essential Updates 2019 eLearning package, the learner will be able to:

• What’s New in Excel 2019?
• Describe the new IFS, TEXTJOIN, and SWITCH functions
• Demonstrate the new Ink Tools, including Ink to Shape and Ink Replay
• Discuss the changes to Cut/Copy and Selection features
• What’s New in Outlook 2019?
• Demonstrate how Outlook integrates with OneDrive for attachments
• Describe the function of the Focused Inbox
• Insert SVG images and Icons into email messages
• Discuss new calendar and accessibility features
• What’s New in Word 2019?
• Illustrate  the use of the new 3D model images in Word documents
• Use the new Dictate function to add text in a Word document
• Discuss the use of the Editor and Researcher tools.

Learning outcomes

Once you have completed this online MS Office Essential Updates 2019 training package, the learner will be able to:

• Identify the most common Excel functions used in the Office.
• Demonstrate a solid understanding of the basics of MS Excel.
• Create both basic and advanced spreadsheets.
• Create and format spreadsheets, charts, pivot tables.
• Enter data, organise data, perform calculations with simple functions.
• Work with multiple worksheets, format the appearance of data and cells, build charts, and create PivotTables. 
• Use the IF, VLOOKUP, and COUNTIF family of functions. 
• Import and export data to and from Excel.
• Describe the changes to Cut/Copy and Selection features.

MS Office Essential Updates 2019 - E-Learning Package - CPDUK Accredited.