Mastering Microsoft Excel 2016 – 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 2016 - Advanced - Online Training Course - CPDUK Certified.
Welcome to our online Mastering Microsoft Excel 2016 advanced training course. All our online training courses, programmes and qualifications are accredited by the CPD Certification Service (CPDUK).
Mastering Microsoft Excel 2016 Advanced
Teacher - Barbara Evers
Learner - Christina Tankersley
This advanced training course will teach you the advanced features of Microsoft Excel 2016.
Barbara Evers will train you to create and modify pivot tables, create easy-to-view charts and graphs and use conditional formatting and sparklines to highlight data trends through this course.
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 2016 advanced training course is suitable for anyone who wants to advance their understanding of Microsoft Excel 2016. These skills will improve the learner’s experience and employability opportunities.
What is covered in this course?
This online Mastering Microsoft Excel 2016 - Advanced training course includes the following:
- Unit 1: Intro
- Unit 2: Selecting and navigating
- Unit 3: Keyboard navigation and basic data entry
- Unit 4: The ribbon
- Unit 5: The quick access toolbar
- Unit 6: Creating a new spreadsheet
- Unit 7: Compatibility issues
- Unit 8: Cell data and data types
- Unit 9: Accessing help
- Unit 10: Creating worksheet formulas
- Unit 11: Insert functions
- Unit 12: Re-using formulas and functions
- Unit 13: Insert, delete and adjust columns and rows
- Unit 14: Find and replace
- Unit 15: Use proofing and research tools
- Unit 16: Apply text formats
- Unit 17: Apply number formats
- Unit 18: Align cell contents
- Unit 19: Applying styles and themes
- Unit 20: Conditional formatting
- Unit 21: Creating and using templates
- Unit 22: Preview and print a notebook
- Unit 23: Page layout
- Unit 24: Configure headers and footers
- Unit 25: Managing worksheets
- Unit 26: View options
- Unit 27: Managing workbook properties
- Unit 28: Working with named ranges
- Unit 29: Using named ranges in formulas
- Unit 30: Using specialised functions
- Unit 31: Working with logical functions
- Unit 32: Displaying formulas
- Unit 33: Nesting functions
- Unit 34: Date and time functions
- Unit 35: Text functions
- Unit 36: Sorting data
- Unit 37: Filtering data
- Unit 38: Using database functions
- Unit 39: Using subtotals
- Unit 40: Create and modify tables
- Unit 41: Manipulating table data
- Unit 42: Conditional formatting rules
- Unit 43: Using logical functions with conditional formatting
- Unit 44: Creating charts
- Unit 45: Modifying and formatting charts
- Unit 46: Creating a dual axis chart
- Unit 47: Chart templates
- Unit 48: Formatting shapes and objects
- Unit 49: Creating a pivot table
- Unit 50: Analysing pivot table data
- Unit 51: Pivot charts
- Unit 52: Slicers and timelines
- Unit 53: Using links and external references
- Unit 54: Using 3D references
- Unit 55: Consolidating data
- Unit 56: Using lookup functions - Part 1
- Unit 57: Using lookup functions - Part 2
- Unit 58: Tracing precedent and dependent cells
- Unit 59: Watching and evaluating formulas
- Unit 60: Comments and track changes
- Unit 61: Comparing and merging workbooks
- Unit 62: Accessibility checker
- Unit 63: Protecting worksheets and workbooks
- Unit 64: Applying data validation
- Unit 65: Search for invalid data
- Unit 66: Working with macros - Part 1
- Unit 67: Working with macros - Part 2
- Unit 68: Creating sparklines
- Unit 69: 3D Maps
- Unit 70: Data tables
- Unit 71: Using scenarios
- Unit 72: Goal seek
- Unit 73: Forecasting data trends
- Unit 74: Changing your display
- Unit 75: Importing delimited text files
- Unit 76: Data forms and form controls
- Unit 77: Calculated fields and cube functions.
Mastering Microsoft Excel 2016 - Advanced - Online Training Course - CPDUK Accredited.
Course aims
The aim of this Mastering Microsoft Excel 2016 advanced eLearning course is to broaden your knowledge of the versatility of Excel that applies to your work with the database.
Learning objectives
On completion of this Mastering Microsoft Excel 2016 advanced e-learning course, the learner will be able to:
- Demonstrate how to navigate the ribbon
- Discuss the compatibility issues between Excel 2016 and older versions of Excel
- Explain the importance of named ranges
- Write nested functions
- Demonstrate advanced functions
- Define and develop macros.
Learning outcomes
Once you have completed this online Mastering Microsoft Excel 2016 advanced training course, the learner will be able to:
- Create and modifying pivot tables
- Create easy-to-view charts & graphs
- Insert and formatting tables
- Import and export data to and from Excel
- Create various charts and graphs
- Create and use functions and formulas
- Create and effectively use Pivot Tables
- Apply data to various reporting forms like tables, graphs and pivot tables.
Why is this online Mastering Microsoft Excel 2016 - Advanced training course essential?
This online Mastering Microsoft Excel 2016 advanced training course is essential in developing Excel skills and is a powerful way to analyse data as professionals do.
Mastering Microsoft Excel 2016 - 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 | |