Course Description

Microsoft Office 2019 Excel – Intermediate

Microsoft Office 2019 Excel – Intermediate is a course run by 1 Training, Dublin. It is a 'Online Learning' course . For more information about Microsoft Office 2019 Excel – Intermediate at 1 Training, please review the details below.

Microsoft Office 2019 Excel – Intermediate


The course Microsoft Office 2019 Excel – Intermediate is the second part of a series of three courses that will build on your foundational knowledge of Excel – Beginner. You will learn to create advanced worksheets and workbooks. This course will deepen your knowledge of Excel and get you ready to take on and perform advanced tasks related to the Excel platform. You will have an advanced ability to analyse large amounts of data and compete at a high level.

The course is extensive and will cover a range of modules such as working with functions, working with lists, analysing data, visualising data with charts, working with graphical objects and using array formulas. Each module is discussed thoroughly to ensure the learners gain an in-depth understanding of the subject matter.

The course Microsoft Office 2019 Excel – Intermediate is highly beneficial to anyone aspiring or already employed in a modern office environment. Getting qualified will further improve your opportunities of career progression, and having this certificate on your resume will demonstrate to employers that you have expanded your skills and expertise in the area.

What will I Learn?

  • Learn to work with functions proficiently
  • Learn to analyse huge amounts of data
  • Learn to use PivotTables and PivotCharts
  • Learn to visualise data with charts

Why you should consider 1Training?

As improvements and advancements are made in technology, online courses are no longer just conventional means of studying at affordable costs. In many aspects online training offers superiority to traditional learning. There is an effectiveness and convenience that traditional learning cannot provide. The overall convenience and flexibility makes it a superior learning method.

1Training offers the most convenient path to gain an internationally recognised qualification that will give you the opportunity to put into practice your skill and expertise in an enterprise or corporate environment. You can study at your own pace at 1Training and you will be provided with all the necessary material, tutorials, qualified course instructor and multiple free resources which include Free CV writing pack, Nus Discounted Card, Free career support and course demo to make your learning experience enriching and more rewarding.

Course Curriculum Total Units : 7
1: Working with Functions
2: Working with Lists
3: Analyzing Data
4: Visualizing Data with Charts
5: Using PivotTables and PivotCharts
6: Working with Graphical Objects
7: Using Array Formulas

Who Should Attend 

  • Individuals aspiring to expand their skills in the Microsoft Excel platform
  • Anyone interested in working in a modern office environment

Method of Assessment

At the end of the course learners will also take an online multiple choice questions assessment test. This online multiple choice questions assessment test is marked automatically so that you will receive an instant grade and know whether you have passed the course.


Learners who successfully complete the course will be awarded the Microsoft Office 2019 Excel – Intermediate Certificate.

The Microsoft Office 2019 Excel – Intermediate course at 1 Training is listed in's national courses finder.
Training Provider1 Training
Course LocationDublin
Course TypeOnline Learning
Course Fee20
Entry Requirements• This course is available to all students, of all academic backgrounds. However, a sound educational background would be an advantage. • Learners should be ages 16 or over to undertake the qualification. • Basic understanding of English language, literacy, numeracy and ICT are required to attend this course. • Individuals who have taken the Microsoft 2019 Excel -Beginner course.
Carear Path• Administrative Assistant • Finance Assistant • Project Coordinator
Phone+44 208 610 9650
For more information about 1 Training, please visit our College page on by clicking here.

Course Provider

1 Training

63/66 Hatton Garden, 5th Floor, Suite 23, London. EC1N 8LE, Dublin, United Kingdom. Eircode: EC1N 8LE

Make Enquiry

Please insert your contact details and any additional information you require and we will forward your request to 1 Training

Captcha code        I confirm I have read the Cookie Information, Terms and Conditions and Privacy Policy and I agree to join the community.


1 Training
63/66 Hatton Garden, 5th Floor, Suite 23, London. EC1N 8LE
United Kingdom
Visit Website