Microsoft Office Excel 2019

  • Get trained as a professional in microsoft excel 
  • Excel for all level of learners – beginners to advance!
  • Learn smart skill to enhance your career
  • Professional training with certificate and more!
microsoft excel 2019 logo

E-Learning Course:

Study at your own pace! 12 Month Access to learn at the comfort of your home – Anytime!! Anywhere!!!

Microsoft Office Excel 2019 Training

Gain comprehensive understanding of Microsoft excel in this three levels (Beginner, Intermediate & Advance) training bundle. This course is suitable for all level of users and will enable learner to understand the fundamentals of Microsoft Excel up to the advanced level.

Learner will be introduce to Microsoft Office Excel 2019, how to use office excel as a beginner or expert, how to format and modify excel sheets, how to perform calculation and using excel formula bars, SmartArt, Graphical Cell, Using Tables and Charts, Workbook and Worksheets, using PivotTables and Pivot Charts, data with charts, data validation, lookup functions, power pivot, data mapping and much more.

At the end of this course, learner should be well equipped as a professional excel user.

Studying this course from LPT via elearning route means you get quality, up to date training and contents, study materials, instructor led training, quizzes, test, plus the ability to study anywhere anytime, with 247 access to the learning portal for 12 months.

What's Included

During the course of your study, you will be tested via quizzes and mock exams where required. The course is delivered via interactive learning videos and study materials with 12 months access to study 247 anywhere anytime.

This course is a training video developed by industry experts with up to date information and the best learning outcome. It include module exercises, interactive courses plus:

Certificate of completion
247 course Access
365 Days Access
Reviews, Quiz & Mock Exam
24/7 Support
Interactive & Scenario based video learning
Compatibility on mobile, tablet, laptop and desktop

Course Introduction

Part 1

Getting Started with Microsoft Office Excel 2019

Navigate the Excel User Interface

Use Excel Commands

Performing Calculations

Modifying and Formatting Worksheet

Printing and Managing Workbook

Adding Borders and Colours to Worksheets

Basic Excel Customization

Part 2

Working with Lists and Functions

Analysing Data:

Create and Modify Tables

Intermediate and Advance Conditional Formatting Application

Visualizing Data with Charts

Creating Charts

Modifying and Formatting Charts

Use Advanced Chart Features

Using PivotTables and Pivot Charts

Create a PivotTable

Analyse Pivot Table Data

Present Data with Pivot Charts

Filter Data by Using Timelines and Slicers

Working with Graphical Objects

Insert and Modifying Graphical Objects

Using Array Formulas


Part 3

Working with Multiple Worksheets and Workbooks

Use Links and External References

Use 3-D References

Consolidate Data

Sharing and Protecting Workbooks

Collaborate on a Workbook

Protect Worksheets and Workbooks

Automating Workbook Functionality

Using Lookup Functions and Formula Auditing

Forecasting, Creating Sparklines and Mapping Data

Importing and Exporting Data

Internationalizing Workbooks

Working with Power Pivot

Advanced Customization Options

Working with Forms and Controls

Upon completing this training, learner be assessed by taking an online multiple choice questions with automatic grading.


Will i get a certificate after completing this course?

Learner will receive a CPD Accredited Certificate in Microsoft office Excel 2019, upon course and exam completion.

What other methods of learning do you offer?

We offer this course as a Self-paced Elearning Course, Virtual Online Class, Blended Learning, Group Booking or In-house training. Contact us or search our website for other delivery type for this course title.

Rate & Review this course

We love feed backs! Kindly rate and review this course via the button below.

Submit your review



Create your own review
Microsoft Office Excel 2019

Average rating:  

 0 reviews



  • Study Smart! Learn on the go - Anytime! Anywhere!!
  • Get Trained On Career Boosting Skills With Ease !
  • Professional Support & Friendly Customer Service!
  • Interactive Learning Videos & Study Materials!
  • COMPATIBILITY: Windows, Mac, iPhone, iPad, Laptop, PC, Mobile


Related Courses

Select your currency
USD United States (US) dollar