Microsoft Office 2019 Excel - Advanced

4.6( 5 REVIEWS )
121 STUDENTS
Buy Now
£299 £69 (inc. VAT)
  • 365 Days
  • Advanced
  • Wishlist
  • Accredited By CPD & IAP
  • 35Guided Learning Hours
  • Course Material
  • 11Number of Modules

What Will I Learn?

Learn how to share and protect workbooks
Learn how to automate workbook functionality
Understand forecasting data
Learn to use Lookup functions and Formula Auditing

Overview 

The course Microsoft Office 2019 Excel – Advanced is the third part of a series of three courses that will build on your foundational and intermediate knowledge acquired in Excel Part 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 – Advanced 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.

Why study at Global Edulink?

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.

Global Edulink offers the most convenient path to gain recognised skills and training that will give you the opportunity to put into practice your knowledge and expertise in an IT or corporate environment. You can study at your own pace at Global Edulink and you will be provided with all the necessary material, tutorials, qualified course instructor, narrated e-learning modules and free resources which include Free CV writing pack, free career support and course demo to make your learning experience more enriching and rewarding.

  • Who is this Course aimed at?
  • Entry Requirement
  • Method of Assessment
  • Certification
  • Progression and Career Path
  • Individuals aspiring to advance in their skills in the Microsoft Excel platform
  • Anyone interested in working in a modern office environment
  • 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.

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

Upon successfully completing the Certificate in Microsoft Office 2019 Excel – Advanced, 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

Key Features

Gain an Accredited UK Qualification

Access to Excellent Quality Study Materials

Learners will be Eligible for TOTUM Discount Card

Personalised Learning Experience

UK Register of Learning Providers Reg No : 10053842

Support by Phone, Live Chat, and Email

Course Curriculum

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

Students feedback

4.6

Avarage rating (5)
4.6
5 Star
4 Star
3 Star
2 Star
1 Star
    A B

    Albert Bennett

    June 21, 2020 - 3:51pm
    Great support

    There was a very supportive team on hand, ensuring that students are taken care of during the training. As a first time learner, I was nervous about taking this course. But, I’m glad that I decided to sign up. I had such a positive learning experience.

    E S

    Euan Shaw

    June 07, 2020 - 9:26am
    Solid resources

    The course provided solid resources to refer back to whenever needed. The tutor was an expert on this subject matter and provided a superb training. I found the content very useful and hope it will help me as I take steps towards progressing further in my career.

    C H

    Cooper Hill

    May 30, 2020 - 10:12pm
    Gained the necessary information

    I gained the necessary information that I required to help me be proficient in Excel, and complete my day to day tasks efficiently.

    A K

    Ayden Knight

    May 10, 2020 - 9:44am
    Successful outcome

    I had a successful outcome. The training was of a good standard, and better than I expected.

    A K

    Adam Khan

    May 04, 2020 - 1:12am
    Overall, very good

    This course was overall, very good. This is the third level of a 3 part series in Excel 2019. I absolutely enjoyed taking all three parts, because I gained a wealth of knowledge. The third part built on the foundational and intermediate levels.

Buy Now
£299 £69 (inc. VAT)
  • 365 Days
  • Advanced
  • Wishlist
  • Accredited By CPD & IAP
  • 35Guided Learning Hours
  • Course Material
  • 11Number of Modules
WhatsApp chat