Course Images

Excel Must know Formulas and Functions Course

Excel Must know Formulas and Functions Course

By One Education

5.0(1)
  • 30 Day Money Back Guarantee
  • Completion Certificate
  • 24/7 Technical Support

Highlights

  • On-Demand course

  • 2 hours

  • All levels

Description

The Excel Must Know Formulas and Functions Course is designed for learners who want to build confidence in using Microsoft Excel for calculations, analysis, and organised data handling. This course focuses on the formulas and functions that are widely used in offices, businesses, and everyday spreadsheet tasks. Clear explanations guide learners through logical operations, mathematical formulas, text functions, and data-related calculations, helping users understand not just what a formula does, but why it works. The content is structured to support steady progress while keeping learning clear, focused, and engaging.

This course is delivered fully online, making it suitable for self-led study from any location. It supports learners who wish to improve accuracy, save time, and reduce errors when working with spreadsheets. From basic calculations to commonly used Excel functions, the course builds strong foundations that support better decision-making and cleaner data presentation. With a professional yet approachable tone, the course adds value for anyone looking to use Excel more confidently for administrative, analytical, or reporting tasks.

Learning Outcomes:

  • Understand how to use Excel formulas and functions effectively.

  • Learn how to use logical functions like If, And, Or, and nested If.

  • Master the use of Vlookup, Hlookup, Match, and Index functions.

  • Know how to use Countif, Sumif, Averageif, Sumifs, and Countifs functions.

  • Use date and time formulas and functions, text functions, and tracing formulas.

  • Analyse data, perform calculations and automate tasks in Excel.

Course Curriculum:

Excel Must know Formulas and Functions

  • Building basic math formulas

  • Autosum and Relative references

  • Absolute references

  • Named Ranges

  • Linking sheets and workbooks

  • If, And, Or, and the nested If functions

  • Countif, Sumif, Averageif, Sumifs, and Countifs functions

  • Vlookup and Hlookup functions

  • Match and Index functions

  • Date and time formulas and functions

  • Text functions

  • Tracing formulas

How is the course assessed?

Upon completing an online module, you will immediately be given access to a specifically crafted MCQ test. For each test, the pass mark will be set to 60%.

Exam & Retakes:
It is to inform our learners that the initial exam for this online course is provided at no additional cost. In the event of needing a retake, a nominal fee of £9.99 will be applicable.

Certification
Upon successful completion of the assessment procedure, learners can obtain their certification by placing an order and remitting a fee of __ GBP. £9 for PDF Certificate and £15 for the Hardcopy Certificate within the UK ( An additional £10 postal charge will be applicable for international delivery).

CPD

10 CPD hours / points Accredited by CPD Quality Standards

Who is this course for?

The course is ideal for highly motivated individuals or teams who want to enhance their professional skills and efficiently skilled employees.

Requirements

There are no formal entry requirements for the course, with enrollment open to anyone!

Career path

  • Data Analyst - Average Salary £30,000

  • Accountant - Average Salary £32,000

  • Financial Analyst - Average Salary £35,000

  • Business Analyst - Average Salary £35,000

  • Data Scientist - Average Salary £45,000

  • Financial Controller - Average Salary £50,000

Certificates

Certificate of completion

Digital certificate - £9

You can apply for a CPD Accredited PDF Certificate at the cost of £9.

Certificate of completion

Hard copy certificate - £15

Hard copy can be sent to you via post at the expense of £15.

Reviews

Recommended Courses