Spreadsheets for Accounting

Includes

• 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

Prerequisites

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.