Spreadsheet Functions in MS Excel

Overview:

This is a comprehensive CPD course designed to equip users with a strong foundation in applying spreadsheet formulas and functions for business and financial tasks. Starting with basic arithmetic operations and advancing to logical functions, lookups, and nested formula applications, this course covers every essential function professionals need to work confidently in Excel. Participants will learn through practical examples, including data analysis, pass/fail assessments, variance categorisation, and financial ratio computations using HLOOKUP and VLOOKUP. With additional coverage of circular referencing and named ranges, this course is ideal for anyone aiming to elevate their Excel skills and accuracy.

Course Content:

In this course, you will gain knowledge about the following topics:

• Introduction to Formulas and BODMAS in Excel
  
• Core Excel Functions and Syntax
  
• Relative and Absolute Referencing
  
• Using Named Ranges
  
• Text and Date Functions
  
• Logical Functions with Practical Use Cases
  
• Lookup Functions: HLOOKUP and VLOOKUP
  
• Function Nesting and Circular Referencing

Learning Objectives:

Upon completing this course, you should be able to:

• Write, understand, and apply basic mathematical formulas using arithmetic operators and BODMAS rules
  
• Use built-in functions such as SUM, AVERAGE, INT, ABS, CONCATENATE, IF, TODAY, NOW, HLOOKUP, and VLOOKUP
  
• Apply relative and absolute referencing techniques in Excel formulas for dynamic and consistent calculations
  
• Leverage logical functions to perform comparisons and conditional checks in financial and operational scenarios
  
• Use named ranges and the Function Wizard to simplify formula construction and enhance readability
  
• Perform date and text manipulations using date functions and text functions like CONCATENATE
  
• Conduct practical analyses using IF functions for pass/fail evaluations, variance classification, and nested logic
  
• Implement lookup functions to retrieve data from horizontal and vertical tables with error handling using IFERROR

Who Will Benefit:

• Accounting and Finance Professionals
  
• Auditors and Internal Reviewers
  
• Business Analysts and Consultants
  
• Excel Users at All Levels