MS Excel Online Training Course (2016)

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.

Course Overview

• Introduction and Course Overview

Working With Functions

• Work With Function – Introduction
• Work with Ranges – Introduction
• Name and Edit Ranges
• Use Defined Names in a Formula
• Locate and Use Specialized Functions
• Work with Logical Functions – Introduction
• IF Function
• AND, OR and NOT Function
• Combine Functions
• Functions Similar to the IF Function
• Work with Date and Time Functions – Introduction
• Today Now and Date Functions
• Networkday, Weekday, Workday and Isoweeknum Functions
• Work with Text Functions – Introduction
• Left, Right and MID Functions
• Find Function
• Text to Columns Feature
• Concatenate Function
• Upper, Lower and Proper Functions

Working With Lists

• Short Data – Introduction
• Sort Data
• Filter Data – Introduction
• Filter Data
• Query Data with Database Functions
• Database Functions
• Outline and Subtotal Data – Introduction
• Use Subtotals to Summarize Data

Analyzing Data

• Create and Modify Tables – Introduction
• Create and Modify Tables
• Use Summary Functions in Tables
• Apply Intermediate Conditional Formatting – Introduction
• Apply Intermediate Conditional Formatting
• Apply Advanced Conditional Formatting – Introduction
• Use Logical Functions to Apply Conditional Formatting

Visualizing Data With Charts

• Create Charts – Introduction
• Create Charts
• Modify and Format Charts – Introduction
• Modify and Format Charts
• Use Advanced Chart Features – Introduction
• Create a Dual-Axis Chart
• Create a Chart Template
• Visualizing Data with Charts – Best Practice

Using PivotTables And PivotCharts

• Create a PivotTable – Introduction
• Create a PivotTable
• Analyze PivotTable Data – Introduction
• Analyze PivotTable Data
• Present Data with PivotCharts – Introduction
• Present Data with PivotCharts
• Filter Data by Using Timelines and Slicers – Introduction
• Filter Data by Using Slicers and Timelines

This comprehensive intermediate Microsoft office Excel 2016 – 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 intermediate Microsoft office Excel 2016 – 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.

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.