Microsoft Office 2019

Janets

Course

Online

£ 149 VAT inc.

The best Excel courses

See all

See all

Description

  • Type

    Course

  • Level

    Advanced

  • Methodology

    Online

  • Duration

    1 Year

  • Start date

    Different dates available

  • Online campus

    Yes

  • Delivery of study materials

    Yes

  • Support service

    Yes

  • Virtual classes

    Yes

The Microsoft Office 2019 course is designed to educate you with everything that you need for using the universal software – Microsoft Office to your personal and professional 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 training course also helps in identifying new and enhanced features that are common across all applications in Office, including 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 office suite of applications more confidently and efficiently.

Facilities

Location

Start date

Online

Start date

Different dates availableEnrolment now open

About this course

There is no specific requirements for our Microsoft Office 2019 course. It is compatible and accessible from any device including Windows, Mac, Android, iOS, Tablets etc. The course requires a moderate Internet connection so it is possible to start learning with any type of Internet from anywhere at anytime without any limitations.

Upon successful completion of the course, you can instantly download your e-certificate free of cost. Print copy by post is also available at an additional cost of £9.99 and PDF Certificate at £4.99.

Earn a free e-certificate upon successful completion.
Accessible, informative modules taught by expert instructors
Study in your own time, at your own pace, through your computer tablet or mobile device
Benefit from instant feedback through mock exams and multiple-choice assessments
Get 24/7 help or advice from our email and live chat teams
Full Tutor Support on Weekdays

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Who would you like to address this question to?

Fill in your details to get a reply

We will only publish your name and question

Reviews

Subjects

  • Excel
  • Presentation
  • Office IT
  • Access
  • Powerpoint
  • Word
  • Microsoft Excel
  • Microsoft Word
  • Layout
  • Ms Office
  • Microsoft excel training
  • MS Excel
  • Ms PowerPoint
  • Microsoft Access
  • Microsoft Office
  • Ms Word

Course programme

COURSE CURRICULUM

Microsoft Excel 2019

Microsoft Excel 2019 New Features
  • Introduction to Microsoft Excel 2019 New Features
  • CONCAT
  • IFS
  • MAXIFS
  • MINIFS
  • SWITCH
  • TEXTJOIN
  • Map Chart
  • Funnel Chart
  • Better Visuals
  • Pivot Table Enhancements
  • Power Pivot Updates
Getting Started with Microsoft Excel
  • Navigate the Excel User Interface
  • Use Excel Commands
  • Create and Save a Basic Workbook
  • Enter Cell Data
  • Use Excel Help
Performing Calculations
  • Create Worksheet Formulas
  • Insert Functions
  • Reuse Formulas and Functions
Modifying a Worksheet
  • Insert, Delete, and Adjust Cells, Columns, and Rows
  • Search for and Replace Data
  • Use Proofing and Research Tools
Formatting a Worksheet
  • Apply Text Formats
  • Apply Number Format
  • Align Cell Contents
  • Apply Styles and Themes
  • Apply Basic Conditional Formatting
  • Create and Use Templates
Printing Workbooks
  • Preview and Print a Workbook
  • Set Up the Page Layout
  • Configure Headers and Footers
Managing Workbooks
  • Manage Worksheets
  • Manage Workbook and Worksheet Views
  • Manage Workbook Properties
Microsoft Word 2019

Microsoft Word 2019 New Features
  • Introduction to Microsoft Word 2019 New Features
  • Inking Tools
  • Inking Tools 1
  • Learning Tools
  • Microsoft Translate
  • LaTeX
  • Smart Lookup
  • Side to Side Scrolling
  • Scalable Vector Graphics
Getting Started with Word
  • Navigate in Microsoft Word
  • Create and Save Word Documents
  • Manage Your Workspace
  • Edit Documents
  • Preview and Print Documents
  • Customize the Word Environment
Formatting Text and Paragraphs
  • Apply Character Formatting
  • Control Paragraph Layout
  • Align Text Using Tabs
  • Display Text in Bulleted or Numbered Lists
  • Apply Borders and Shading
Working More Efficiently
  • Make Repetitive Edits
  • Apply Repetitive Formatting
  • Use Styles to Streamline Repetitive Formatting Tasks
  • Managing Lists
  • Sort a List
  • Format a List
Adding Tables
  • Insert a Table
  • Modify a Table
  • Format a Table
  • Convert Text to a Table
Inserting Graphic Objects
  • Insert Symbols and Special Characters
  • Add Images to a Document
Controlling Page Appearance
  • Apply a Page Border and Color
  • Add Headers and Footers
  • Control Page Layout
  • Add a Watermark
Preparing to Publish a Document
  • Check Spelling Grammar and Readability
  • Use Research Tools
  • Check Accessibility
  • Save a Document to Other Formats
Workbooks - Microsoft Word 2016 (Beginner)
  • Workbooks – Microsoft Word 2016 (Beginner)
Microsoft PowerPoint 2019

Microsoft PowerPoint 2019 New Features
  • Introduction to Microsoft PowerPoint 2019 New Features
  • Highlighting
  • Morph Transition
  • Zoom
  • Vector Graphics
  • SVG Icons to Shapes
  • 3D Modeling
  • Background Removal
  • 4K
PowerPoint Interface
  • Navigate the PowerPoint Environment
  • View and Navigate a Presentation
  • Create and Save a PowerPoint Presentation
  • Use PowerPoint Help
Presentation Basics
  • Select a Presentation Type
  • Edit Text
  • Build a Presentation
Formatting
  • Format Characters
  • Format Paragraphs
  • Format Text Boxes
Inserting Options
  • Insert Images
  • Insert Shapes
Working with Objects
  • Edit Objects
  • Format Objects
  • Group Objects
  • Arrange Objects
  • Animate Objects
Table
  • Create a Table
  • Format a Table
  • Insert a Table from Other Microsoft Office Applications
Charts
  • Create a Chart
  • Format a Chart
  • Insert a Chart from Microsoft Excel
Review and Presentatin
  • Review Your Presentation
  • Apply Transitions
  • Print Your Presentation
  • Deliver Your Presentation
Microsoft Access 2019

Microsoft Access 2019 New Features
  • Introduction to Microsoft Access 2019 New Features
  • Window Resize
  • Charts
  • dbf
  • Large Number
  • Property Sorting
Introduction to Access
  • Orientation to Microsoft Access
  • Create a Simple Access Database
  • Get Help and Configure Options in Microsoft Access
Modify Data
  • Modify Table Data
  • Sort and Filter Records
Working with Queries
  • Create Basic Queries
  • Sort and Filter Data in a Query
  • Perform Calculations in a Query
Access Forms
  • Create Basic Access Forms
  • Work with Data on Access Forms
Working with Reports
  • Create a Report
  • Add Controls to a Report
  • Enhance the Appearance of a Report
  • Prepare a Report for Print
  • Organize Report Information
  • Format Reports

See related categories

Microsoft Office 2019

£ 149 VAT inc.

The best Excel courses

See all

See all