Menu

Get your summer started right with our sizzling savings!Click Here

Menu
  • No products in the basket.

Microsoft Office 2019 Excel - Advance

4.4( 5 REVIEWS )
132 STUDENTS
ACCREDITED BY
Microsoft Office 2019 Excel Advance

Overview 

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.

Key Features

Gain an accredited UK qualification

Access to excellent quality study materials

Learners will be eligible for TOTUM Discount Card

Personalized learning experience

One year’s access to the course

Support by phone, live chat, and email

  • 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.
  • Individuals aspiring to advance in their skills in the Microsoft Excel platform
  • Anyone interested in working in a modern office environment

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.

Career Path

Upon successfully completing the Certificate in Microsoft Office 2019 Excel – Advance, you will gain an accredited certification that will help you prove your skills and expertise in the Excel 2019 platform. Qualifying in this course will give you the opportunity to demonstrate your expertise to potential employers and organisations. Below listed are a few of the job titles this course will be worthwhile for and you can land and progress further in your career with fruitful advancements.

  • Administrative Assistant
  • Finance Assistant
  • Project Coordinator
  • 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.
  • Individuals aspiring to advance in their skills in the Microsoft Excel platform
  • Anyone interested in working in a modern office environment

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.

Career Path

Upon successfully completing the Certificate in Microsoft Office 2019 Excel – Advance, you will gain an accredited certification that will help you prove your skills and expertise in the Excel 2019 platform. Qualifying in this course will give you the opportunity to demonstrate your expertise to potential employers and organisations. Below listed are a few of the job titles this course will be worthwhile for and you can land and progress further in your career with fruitful advancements.

  • Administrative Assistant
  • Finance Assistant
  • Project Coordinator
Course Curriculum Total Units : 11
1: Working with Multiple Worksheets and Workbooks
Working with Multiple Worksheets and Workbooks
2: Sharing and Protecting Workbooks
Sharing and Protecting Workbooks
3: Automating Workbook Functionality
Automating Workbook Functionality
4: Using Lookup Functions and Formula Auditing
Using Lookup Functions and Formula Auditing
5: Forecasting Data
Forecasting Data
6: Creating Sparklines and Mapping Data
Creating Sparklines and Mapping Data
7: Importing and Exporting Data
Importing and Exporting Data
8: Internationalizing Workbooks
Internationalizing Workbooks
9: Working with Power Pivot
Working with Power Pivot
10: Advanced Customization Options
Advanced Customization Options
11: Working with Forms and Controls
Working with Forms and Controls
WhatsApp chat