Excel for Accounting

This course is ideal for those who are working in or studying accounts, and have little to no knowledge of Excel. In this tutorial you will learn how to master data manipulation in Excel, the IF function, Conditional formatting and MACROS, VBA, Balance sheets with the use of Excel, Importing and exporting data to CSV with SAGE 50 Accounts, and other useful formulas and functions including but not limited to, V lookup and H lookup, which are two of the most useful functions for accountants.

Level 4

£9.95

  • PDF Workbook
  • 6 Video Tutorials
  • Multiple Choice Exercise
  • Final Exam
  • Certificate of Completion

Meet the instructor

—

Samantha Robinson 

Samantha has over 10 years experience in the field of employee training. She manages an Administration Department as well as our Direct B2B training programmes, providing businesses with in-depth face-to-face training solutions for their employees. Her training specialities include business administration and organisational development, Microsoft provider training and software development.