Mastering Microsoft Excel 2019 – Advanced – Online Training Course – CPDUK Certified
£39.99
Mandatory Compliance is a leading UK provider of accredited online training courses for health and social care professionals and organisations that are approved by the CPD Certification Service (CPDUK), RoSPA, IATP, IFE, IIRSM and Gatehouse Awards.
- Overview
- Objectives
- Assessment & Certification
- Why Choose Us?
- FAQs
- Reviews
Mastering Microsoft Excel 2019 - Advanced - Online Training Course - CPDUK Certified.
Welcome to our online Mastering Microsoft Excel 2019 advanced training course. All our online training courses, programmes and qualifications are accredited by the CPD Certification Service (CPDUK).
Mastering Microsoft Excel 2019 - Advanced
Teacher - Kathy Jones
Learner - Alexa Botelho
This online Mastering Microsoft Excel 2019 advanced training course will teach you the advanced tools of Excel 2019. This advanced e-learning course will help you acquire the skills needed to use Excel’s most advanced features to create professional, secure, and accurate workbooks in Excel 2019 or Excel 365.
Entry requirements - no prerequisites required
Assessment type - Complete end of course assessment (80% needed to pass and gain CPD certificate)
Certification/Qualification - Downloadable CPD certified certificate
Cost(s) of assessment and certification - Assessment and certification costs included in the course price
Course accreditation - CPD Certification Service (CPDUK)
Who is the course for?
This online Mastering Microsoft Excel 2019 advanced training course is suitable for learners who have a working knowledge of Excel 2019 or Excel 365. By the end of this course, you will feel empowered to use Excel’s most advanced features to create professional, secure, and accurate workbooks in Excel 2019 or Excel 365.
What is covered in this course?
This online Mastering Microsoft Excel 2019 advanced training course includes the following:
- Unit 1: Linking and consolidating
- Unit 2: Sharing and protecting
- Unit 3: Automating
- Unit 4: Using lookup functions
- Unit 5: Auditing formulas
- Unit 6: Forecasting data
- Unit 7: More features.
Mastering Microsoft Excel 2019 - Advanced - Online Training Course - CPDUK Accredited.
Course aims
The aim of this Mastering Microsoft Excel 2019 advanced e-learning course is to teach you to create professional, secure, and accurate workbooks in Excel 2019.
Learning objectives
On completion of this Mastering Microsoft Excel 2019 advanced eLearning course, the learner will be able to:
- Use multiple worksheets and workbooks to track, retrieve, consolidate and report on data using features like cell links, group mode, 3D reference formulas, and consolidate.
- Collaborate with others using comments, track changes, sharing, co-authoring, and Compare and Merge.
- Prepare a document for sharing by checking for accessibility and sensitive information, as well as multiple ways to protect your worksheets and workbooks from changes.
- Keep your data consistent and accurate with data validation and automate tasks with Macros.
- Perform complex calculations by developing a deep understanding of Excel’s Lookup functions like VLOOKUP, MATCH, and INDEX.
- Quickly find and address errors in your formulas with tracing, evaluate the formula and the Watch Window and add error handling with the IFNA and IFERROR functions.
- Use your data to plan and forecast trends and explore various outcomes based on variables and scenarios.
- Visualise geographic data with Map Charts and 3D Map Tours.
Learning outcomes
Once you have completed this online Mastering Microsoft Excel 2019 advanced training course; the learner will be able to:
- Share a document
- Create geographic visuals like Map Charts and 3D Map Tours
- Perform complex calculations by developing a deep understanding of Excel’s Lookup functions like VLOOKUP, MATCH, and INDEX.
- Import and export data
- Creating a web query
- Addressing formula errors
- Recording, running and editing a Macro.
Why is this online Mastering Microsoft Excel 2019 - Advance training course essential?
This online Mastering Microsoft Excel 2019 advanced training course builds on your existing Excel knowledge and teaches you how to use links, lookup functions, data validation, macros, data tables which are valuable skill sets needed in modern business.
Mastering Microsoft Excel 2019 - Advanced - Online Training Course - CPDUK Accredited.
Health & Social Care eLearning Courses - Online Training Courses - Leading UK Providers - CPDUK Accredited

Our online courses and programmes range from introductory modules at Level 1 (awareness/beginner) to advanced and expert modules up to Level 6.
Our e-learning modules count towards CPD hours for professionals in various sectors as well as meeting mandatory and statutory requirements (where relevant).
Online Health and Social Care Training Courses - E-Learning Providers - CPDUK Accredited elearning Courses.
Health & Social Care eLearning Courses - Online Training Courses - Leading UK Providers - CPDUK Accredited
The Mandatory Training Group is an accredited and trusted leading provider of statutory and mandatory training for health and social care providers across all UK regions.
Established by qualified health and social care professionals, we have extensive experience in various NHS, private and education sectors. Click here to see our full range of accredited courses, programmes and qualifications.
Staff working in health and social care environments must ensure that they complete appropriate statutory and mandatory training to provide safe and effective services.
Our health and social care training courses, programmes and qualifications were designed to provide effective learning and development opportunities for staff at all levels. Our packages include induction training, statutory and mandatory courses and continuing professional development (CPD).
Our statutory, mandatory and specialist health and social care training courses are delivered in line with the relevant UK legislation and recommended practice and standards including:
- Continuing Professional Development (CPD)
- Care Quality Commission (CQC)
- Health and Safety Executive (HSE)
- National Institute for Health and Clinical Excellence (NICE)
- Qualifications and Credits Framework (QCF).
We provide over 500 online CPD accredited training courses, programmes and qualifications. These course materials were developed to meet the needs of individuals and organisations from both the NHS and private sectors.
Some of the key benefits include health and social care workers to meet both their responsibilities and job roles, which are ideal for induction, awareness, knowledge and refresher training.
- Online, self-paced training
- 24-hour learner support
- High-quality interactive courses
- Intuitive learning management system
- Complete modules within 1-2 hours
- Meet organisational mandatory training needs
- Meet training requirements for statutory training
- Instant digital CPD certificates on completion
- Meet current UK legislation and guidelines
- Over 500 CPD courses covering multiple business sectors
- Free blended learning environment (BLE) for all organisations.
You will need access to a desktop computer, laptop, tablet or smartphone device to complete these online courses. You can start, pause/stop and return to where you left off.
Our courses utilise responsive design features, making them available on any device of your choice.
All the courses are accredited by the CPD Certification Service (CPDUK). The Mandatory Training Group is an accredited corporate provider of E-Learning courses, programmes and qualifications across all sectors. Click here to see our CPDUK accreditation.
The CPD certificates, awarded upon successful completion, can be used to log your hours against.
Online Health and Social Care Training Courses - E-Learning Providers - CPDUK Accredited elearning Courses.

We want you to be completely satisfied with your training. Thus, we offer a 14-day money-back guarantee if you are not 100% satisfied.
To request a refund, you should email our Support Team with your receipt stating why you would like to be refunded. Any courses that have been completed and those with certificates will not be valid for a refund.
Online Health and Social Care Training Courses - E-Learning Providers - CPDUK Accredited elearning Courses.
Submit your review | |