Microsoft Excel 2016 for Professionals Online Training

CPD certificates are accepted by thousands of professional bodies and government regulators here in the UK and around the world. Many organisations look for employees with CPD requirements, which means, that by doing this course, you would be a potential candidate in your respective field.

 

The Quality Licence Scheme is a brand of the Skills and Education Group, a leading national awarding organisation for providing high-quality vocational qualifications across a wide range of industries.

Working With Multiple Worksheets And Workbooks

• Use Links and External References – Introduction
• Use Links and External References
• Use 3-D References – Introduction
• Use 3-D References
• Consolidate Data – Introduction
• Consolidate Data

Using Lookup Function And Formula Auditing

• Use Lookup Functions – Introduction
• Use Lookup Functions
• Trace Precedent and Dependent Cells – Introduction
• Trace Precedent and Dependent Cells
• Watch and Evaluate Formulas – Introduction
• Watch and Evaluate Formulas

Watch and Evaluate Formulas

• Collaborate on a Workbook – Introduction
• Collaborate on a Workbook
• Compare and Merge Workbooks – Introduction
• Protect Worksheets and Workbooks
• Protect Worksheets and Workbooks

Automating Wordbook Functionality

• Apply Data Validation
• Apply Data Validation
• Search for Invalid Data and Formulas with Errors – Introduction
• Search for Invalid Data and Formulas with Errors
• Work with Macros – Introduction
• Work with Macros
• Edit a Macro

Create Sparklines and Map Data

• Create Sparklines – Introduction
• Create Sparklines
• Map Data – Introduction
• Map Data

Forecasting Data

• Determine Potential Outcomes Using Data Tables – Introduction
• Determine Potential Outcomes Using Data Tables
• Determine Potential Outcomes Using Data Scenarios – Introduction
• Determine Potential Outcomes Using Data Scenarios
• Use the Goal Seek Feature – Introduction
• Use the Goal Seek Feature
• Forecast Data Trends – Introduction
• Forecast Data Trends

This comprehensive Microsoft Excel 2016 for professionals online training course is suitable for anyone looking to improve their job prospects or aspiring to accelerate their career in this sector and want to gain in-depth knowledge of Microsoft Office Excel.

• There are no academic entry requirements for this Microsoft Excel 2016 for professionals online training course, and it is open to students of all academic backgrounds.
• As long as you are aged seventeen or over and have a basic grasp of English, numeracy and ICT, you will be eligible to enrol.

On successful completion of the course, you will be required to sit an online multiple-choice assessment. The assessment will be evaluated automatically and the results will be given to you immediately.

Endorsed Certificate from Quality Licence Scheme

After successfully passing the MCQ exam you will be eligible to order the Endorsed Certificate by Quality Licence Scheme. The Quality Licence Scheme is a brand of the Skills and Education Group, a leading national awarding organisation for providing high-quality vocational qualifications across a wide range of industries. It will give you a competitive advantage in your career, making you stand out from all other applicants and employees. There is a Quality Licence Scheme endorsement fee to obtain an endorsed certificate which is £65.

Certificate of Achievement from Lead Academy

After successfully passing the MCQ exam you will be eligible to order your certificate of achievement as proof of your new skill. The certificate of achievement is an official credential that confirms that you successfully finished a course with Lead Academy. Certificate can be obtained in PDF version at a cost of £12, and there is an additional fee to obtain a printed copy certificate which is £35.