Spring SaleUp to 80% OFF!

X

spring-sale-banner-offer-80-percent
self-paced-training

Self-Paced Online Learning

Learn on your own accord, wherever you want, whenever you want.

self-paced-training

4 Instalment Plan on checkout

You have the option to choose from four easy instalment plans.

self-paced-training

14 Days Money Back Guarantee

Hassle-free guarantee on purchase, ensuring quality & your peace of mind.

£27 £125
Buy Now
MS Excel Online Training Course (2016)

MS Excel Online Training Course (2016)

trustpilot-rating

Course Fee

£27

£125

discount white 78% OFF

👉 CPD UK Accredited PDF Certificate Included

4 interest-free payments 4 interest-free payments of £6.75

14 Days Money Back Guarantee
Duration: 146 Minutes
Instant Access
Instant Access
Quality Guarantee

Quality Guarantee

Promising training excellence, satisfaction gurantee

Accredited by

Accredited by

CPD UK & Quality License Scheme

Tutor Support

Tutor Support

Unlimited support via email, till you complete the course

Recognised Certification

Recognised Certification

Accepted by thousands of professional bodies

Start Anytime

Start Anytime

With 1 year access to the course materials

Online Learning

Online Learning

Learn from anywhere, whenever you want

Why MS Excel Online Training (2016) Course right for you?

Are you looking to begin your Microsoft Office Excel career or want to develop more advanced skills in Microsoft Office Excel? Then this intermediate Microsoft office Excel 2016 – online training course will set you up with a solid foundation to become a confident office admin and help you to develop your expertise in Microsoft Office Excel.

This intermediate Microsoft office Excel 2016 – online training course is accredited by the CPD UK & IPHM. CPD is globally recognised by employersprofessional organisations and academic intuitions, thus a certificate from CPD Certification Service creates value towards your professional goal and achievement. CPD certified certificates are accepted by thousands of professional bodies and government regulators here in the UK and around the world.

Whether you are self-taught and you want to fill in the gaps for better efficiency and productivity, this intermediate Microsoft office Excel 2016 – online training course will set you up with a solid foundation to become a confident office admin and develop more advanced skills. Gain the essential skills and knowledge you need to propel your career forward as a office admin.

The intermediate Microsoft office Excel 2016 – online training course will set you up with the appropriate skills and experience needed for the job and is ideal for both beginners and those currently working as a office admin.

This comprehensive intermediate Microsoft office Excel 2016 – online training course is the perfect way to kickstart your career in the field of Microsoft Office Excel. This intermediate Microsoft office Excel 2016 – online training course will give you a competitive advantage in your career, making you stand out from all other applicants and employees.

If you’re interested in working as a office admin or want to learn more skills on Microsoft Office Excel but unsure of where to start, then this intermediate Microsoft office Excel 2016 – online training course will set you up with a solid foundation to become a confident office admin and develop more advanced skills.

As one of the leading course providers and most renowned e-learning specialists online, we’re dedicated to giving you the best educational experience possible. This intermediate Microsoft office Excel 2016 – online training course is crafted by industry expert, to enable you to learn quickly and efficiently, and at your own pace and convenience.

MS Excel Online Training (2016) Course Details


CPD Certification Service
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.

 

Quality License Scheme Certificate (20% off)
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

Endorsed Certificate
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

CPD Certificate
After successfully passing the MCQ exam, you will be eligible to order your certificate of achievement as proof of your new skill. You will get the CPD-accredited PDF certificate free of cost, which is included with the course. There is an additional fee to obtain a printed copy of the CPD-accredited certificate, which is £35.

Success Stories

Course Reviews

FAQs

CPD is globally recognised by employers, professional organisations and academic intuitions, thus a certificate from CPD Certification Service creates value towards your professional goal and achievement. CPD-certified certificates are accepted by thousands of professional bodies and government regulators here in the UK and around the world.

Although QLS courses are not subject to Ofqual regulation, they must adhere to an extremely high level that is set and regulated independently across the globe. A course that has been approved by the Quality Licence Scheme simply indicates that it has been examined and evaluated in terms of quality and fulfils the predetermined quality standards.

For CPD accredited PDF certificate it will take 24 hours, however for the hardcopy CPD certificate takes 5-7 business days and for the Quality License Scheme certificate it will take 7-9 business days.

Yes, you can pay via Invoice or Purchase Order, please contact us at info@lead-academy.org for invoice payment.

Yes, you can pay via instalments at checkout.

Our platform provides easy and comfortable access for all learners; all you need is a stable internet connection and a device such as a laptop, desktop PC, tablet, or mobile phone. The learning site is accessible 24/7, allowing you to take the course at your own pace while relaxing in the privacy of your home or workplace.

No, there is no age limit for online learning. Online learning is accessible to people of all ages and requires no age-specific criteria to pursue a course of interest. As opposed to degrees pursued at university, online courses are designed to break the barriers of age limitation that aim to limit the learner’s ability to learn new things, diversify their skills, and expand their horizons.

After successfully purchasing the course, you will receive an email within 24 hours with the login details of your course. Kindly check your inbox, junk or spam folder, or you can contact our client success team via info@lead-academy.org

0
    0
    Your Cart
    Your cart is emptyReturn to Shop

    Upgrade to get Lifetime ACCESS to ALL COURSES for only £149.00

    Lifetime Membership to All Courses. Certain courses are not included. Can't be used in conjunction with any other offer.