• No products in the basket.



  • 695 Students

  • Certified

Learning Outcome


Learning how to use Excel can be a smart investment since maximum jobs require you to have knowledge of basic Microsoft Excel.

If you are about to get in the job market or looking forward to making a change in your career, then this Excel 2016 Formulas and Functions course can exceedingly help you.

Course Design

The course is delivered through our online learning platform, accessible through any internet-connected device. There are no formal deadlines or teaching schedules, meaning you are free to study the course at your own pace.

You are taught through a combination of

  • Video lessons
  • Online study materials

How is the course assessed?

This course does not involve any assessment.

Will I receive a certificate of completion?

Upon successful completion, you will qualify for the UK and internationally-recognised certificate and you can choose to make your achievement formal by obtaining your PDF Certificate at a cost of £9 and Hardcopy Certificate for £15.

Why study this course

Whether you’re an existing practitioner or aspiring professional, this course will enhance your expertise and boost your CV with key skills and an accredited qualification attesting to your knowledge.

The Excel 2016 Formulas and Functions is open to all, with no formal entry requirements. All you need is a passion for learning, a good understanding of the English language, numeracy and IT, and to be over the age of 16.

Course Curriculum

Getting Started with Microsoft Excel 2016
Use Excel Commands 00:10:00
Create and Save a Basic Workbook 00:19:00
Enter Cell Data 00:12:00
Use Excel Help 00:05:00
Basic Formulas and Functions
Create Worksheet Formulas 00:15:00
Insert Functions 00:17:00
Reuse Formulas and Functions 00:17:00
Formulas and Functions Activities
Create Formulas in a Worksheet 01:00:00
Activity – Create Formulas in a Worksheet 00:05:00
Insert Functions in a Worksheet 00:30:00
Activity – Insert Functions in a Worksheet 00:05:00
Reuse Formulas 00:30:00
Activity – Reuse Formulas 00:05:00
Customize Formula Options 00:30:00
Activity – Customize Formula Options 00:05:00
  • £425.00 £25.00 ex Vat
  • 1 year
  • Number of Units15
  • Number of Quizzes0
  • 4 hours, 25 minutes

Course Reviews

  1. Nicely explained

    I really enjoyed the course but I could not fine the exercise files.


    Excellente course,with easy guidelines to follow.

  3. Interesting

    Explanations a little long winded, but apart from that it was useful.



Get accredited certificates

New skills

Add skills to your CV


Test your skills

Dedicated Support

for any questions

Set your own speed

Self-paced learning

Enjoy first 7 days free

Start for free

COPYRIGHT © 2021 One Education