It is important for both accounting students and professionals working in the financial sector to have at least a basic understanding of spreadsheet functionality. By taking this course you will not only learn skills that speed up daily tasks, remove errors from calculations and could one day impress your employers and colleagues – but it will also increase your digital literacy, helping you to perform better on computer based examinations and therefore, improving your accountancy exam pass rates.
This course has been designed for both spreadsheet beginner sand competent Excel users. Depending on your experience, you can either work your way through the six chapters in order or start midway through the course.
The online course comes with a full set of course notes. Each chapter has video lectures recorded by a First Intuition tutor, as well as spreadsheet practice for you to test what you have learned and apply your knowledge to a spreadsheet scenario.
The course starts off with basic principles including common terminology, shortcuts and basic functionality. It then progresses to formatting and basic formulae, before investigating more advanced formulae like ‘VLOOKUP’ and ‘IF’ functions. The course concludes by looking at data manipulation including a comprehensive guide to pivot tables.
All the skills learned in this course are valuable to students during their studies and remain applicable during their career. Chapter 6 contains a final practice exercise which utilises the various skills learned within the course.
The First Intuition tutor has provided solutions to each exercise and includes a video debrief for the final practice exercise, so students can follow the spreadsheet expert’s method and compare it to their own.