Course Description

Microsoft Office 2019 Excel – Advance

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

Microsoft Office 2019 Excel – Advance


The course Microsoft Office 2019 Excel – Advance is the third part of a series of three courses that will build on your foundational and intermediate knowledge acquired in Excel Beginner & Intermediate. Taking this course will give you a truly in-depth Excel experience. You will have the ability to collaborate with colleagues, apply elaborate formulas and gain the full functions of the power of Excel. Excel can do all the work for you, and this is what the core focus of this training is all about. You will become an expert at extracting vast amounts of data that is generated by the organisation.

The course is extensive and will cover a range of modules such as sharing and protecting workbooks, automating workbook functionality, forecasting data, importing and exporting data, internationlising workbooks and working with Power Pivot. Each module is discussed thoroughly to ensure the learners gain an in-depth understanding of the subject matter.

The course Microsoft Office 2019 Excel – Advance 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 multiple workbooks and worksheets
  • Learn how to share and protect workbooks
  • Learn how to automate workbook functionality
  • Understand forecasting data
  • Learn to use Lookup functions and Formula Auditing

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 : 11
1: Working with Multiple Worksheets and Workbooks
2: Sharing and Protecting Workbooks
3: Automating Workbook Functionality
4: Using Lookup Functions and Formula Auditing
5: Forecasting Data
6: Creating Sparklines and Mapping Data
7: Importing and Exporting Data
8: Internationalizing Workbooks
9: Working with Power Pivot
10: Advanced Customization Options
11: Working with Forms and Controls

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 – Advance Certificate.


The Microsoft Office 2019 Excel – Advance course at 1 Training is listed in's national courses finder.
Training Provider1 Training
Course LocationDublin
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 – Intermediate 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.