• No products in the basket.


Excel 2016 Formulas and Functions



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 description

The course will be focusing on providing you with the knowledge of advanced Excel functions and how to apply these and devise them for any particular system to perform computerised tasks.

You will learn to create spreadsheets with Excel and design ranges, tables, and import and export data, and so much more. In fact, with having such knowledge employers won’t hesitate to keep you in the company.

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

Course Reviews


3 ratings
  • 5 stars2
  • 4 stars1
  • 3 stars0
  • 2 stars0
  • 1 stars0
  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.


COPYRIGHT © 2021 One Education