Microsoft Office 2019 Excel – Intermediate

Microsoft Office 2019 Excel – Intermediate

Overview 

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.

Certification

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