Spreadsheets for Accounting

Course DurationDuration: 40-50 Hours

Course LevelLevel: 3

Number of ExamsCPD Points: 100


This unit has been accredited by the CPD Certification Service.

You will receive a comprehensive workbook containing lessons, examples and activities. You also get access to our e-learning platform which contains your assessments.

Spreadsheets for Accounting


  • Printed workbook containing lessons, examples and activities
  • 6 months of access to our online portal
  • Your allocated tutor will be on hand to answer any questions and guide you through the learning process
  • There are six assessments inside our e-learning platform, all of which are tutor-marked
  • Additional online resources (help sheets, self-tests etc.)

Course Syllabus

  • Basic Mathematical Functions, e.g. =SUM Function
  • Cutting, Copying and Pasting
  • Formatting Cells and their Contents, including Conditional Formatting
  • Functions and Formulae, including:
    • Date and Time Functions
    • Absolute and Relative Cell References
  • Sorting Data
  • Subtotals
  • Rank and Percentile
  • More Advanced Functions
    • =IF Statements
    • =COUNTIF and =IFERROR Statements
    • = VLOOKUP and =HLOOKUP Functions
  • Data Validation
  • Graphs and Charts
  • Pivot Tables and Goal See Analysis
  • Checking the Validity of Results including:
    • Circular Referencing
    • Remove Duplicates
    • Tracing Precedents and Dependents
  • Preventing Unauthorised Access
  • Naming Cells and Ranges
  • Linking Worksheets


Although there are no prerequisites for this unit, you will need access to Microsoft Excel (or equivalent software) to complete this course.

Additionally, you must have basic numerical skills and a good understanding of the English language.

No exams are required.