Ms Excel
Microsoft Excel: Spreadsheet Functions
Formulas, IF logic tests, VLOOKUP, HLOOKUP, and cell references
4 CPD credits on completion
Enrol Now
Certificate on completion
Downloadable resources
Self-paced learning
About This Course
Course Information
This course covers the creation of formulas and how to use the built-in calculation capabilities
Certificate on Completion
This course is made up of videos, questions and additional reading materials and accounts for 4 units of CPD. One unit is the equivalent of one hour of learning. A certificate will be issued once you have completed all 4 units.
Course Sections
This Course is made up of the following sections:
- Common Spreadsheet Functions (Video)
- Logic Tests (Video)
- Lookups (Video)
- Spreadsheet Functions (Notes)
- Spreadsheet Functions (Multiple Quizzes)
What You Will Learn
- Apply SUM, AVERAGE, COUNT, MIN, MAX, and other common spreadsheet functions
- Distinguish between relative, absolute, and mixed cell references when copying formulas
- Explain how IF and nested IF functions evaluate logic tests and return conditional results
- Apply VLOOKUP and HLOOKUP to extract data from horizontal and vertical tables
- Describe how INDEX and MATCH provide a flexible alternative to VLOOKUP
- Identify when to use XLOOKUP as a modern replacement for VLOOKUP and HLOOKUP
Who This Course Is For
- Accountants who regularly build or maintain spreadsheets with formulas
- Finance professionals who need to look up and cross-reference data across multiple tables
- Excel users who want to move beyond basic arithmetic into logic tests and lookup functions
- Anyone preparing for roles that require frequent Excel-based reporting
Prerequisites
- Basic ability to use Excel, enter data, and work with simple arithmetic operators (+, -, *, /)
- No prior experience with functions or formulas is assumed
Frequently Asked Questions
Course Details
CPD Credits4
CertificateYes
Pricing
Pricing
Invest in your professional development with flexible payment options.
Everything included in your subscription:
CPD certificate on completion
Downloadable resources
Self-paced learning
Expert-led content
24/7 access
Mobile friendly
Ready to Start Learning?
Join thousands of finance professionals who have advanced their careers with Learnsignal CPD courses.
Enrol Now