Booking options
£12
£12
On-Demand course
2 hours
All levels
Excel is an essential tool for any business, and knowing the right formulas and functions can help you work more efficiently and effectively. This course will teach you everything you need to know about Excel formulas and functions, from Autosum and Relative references to Vlookup and Hlookup functions and everything in between. With this knowledge, you'll be able to save time and effort when working with spreadsheets, making you a valuable asset to any employer.
In this course, you'll learn how to use Excel formulas and functions to perform calculations, analyse data, and automate tasks. You'll discover how to use the If, And, Or, and nested If functions to make logical comparisons, as well as how to use the Countif, Sumif, Averageif, Sumifs, and Countifs functions to count, sum, and average data based on specific criteria. You'll also learn how to use Vlookup and Hlookup functions to search for and retrieve data from other parts of your spreadsheet and how to use the Match and Index functions to locate data in large tables. Finally, you'll discover how to use date and time formulas and functions, text functions, and tracing formulas to work more efficiently in Excel.
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).
10 CPD hours / points Accredited by CPD Quality Standards
The course is ideal for highly motivated individuals or teams who want to enhance their professional skills and efficiently skilled employees.
There are no formal entry requirements for the course, with enrollment open to anyone!
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
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.
With a team of industry professionals producing and delivering our course content, you can be sure the skills and knowledge you learn apply to your career aspirations in manag...