What spreadsheet skills should I develop before starting an accounting degree?
Before starting an accounting degree, develop confidence with spreadsheet basics: entering and formatting data, using relative and absolute cell references, writing formulas, and applying functions such as SUM, IF, COUNTIF, and lookup functions. Also practise sorting and filtering, tables, simple charts, pivot tables, checking errors, and presenting figures clearly and accurately.
Key points
- Learn to organise accounting data in rows, columns, and tables, with consistent labels and number formats.
- Practise tracing formulas, checking totals, identifying errors, and keeping clear supporting notes.
- Keyboard shortcuts and efficient data entry can improve speed, but accuracy and transparency matter more.
- You do not need advanced programming or macros before beginning; build those skills later if your course requires them.
Things to check
- The spreadsheet software and level of skill expected can vary by university, course, and country, so check the programme’s module descriptions or preparation guidance.