Is Excel The Right Tool?

Written by Ng Xian Hui, Founder of Backbone. Originally published on ISCA's Chartered Accountants Lab.

Excel, or spreadsheets in general, is the go-to tool for accountants because of its unmatched flexibility and cost-effectiveness. Its adaptability lets it handle diverse tasks such as financial modelling, data analysis, reporting and automation. As a low-cost tool bundled with Microsoft Office subscriptions, Excel provides a versatile solution that can often replace the need for several specialised applications, making it indispensable for a wide range of accounting tasks.

Key takeaways

• Excel, or spreadsheets in general, is the go-to tool for accountants because of its unmatched flexibility, multi-purpose nature and cost-effectiveness.
• But its efficacy is affected by user skills, limited security, performance issues and integration challenges.
• Users need to recognise when Excel cannot manage the complexity or scope of the analysis, and evaluate whether a more specialised business intelligence tool is required.

What is the role of Excel in accounting?

In accounting, tasks that fall outside the scope of ERP (enterprise resource planning) or accounting systems are typically managed using Excel. While ERP and accounting systems handle large-scale, standardised processes effectively, they often lack the flexibility needed for ad-hoc or highly customised tasks. Excel fills this gap by providing a dynamic platform where users can adapt and create solutions tailored to their specific needs.

Excel is often the starting point — a platform where initial ideas, processes or analyses are developed. Once these needs evolve or grow in complexity, it may become necessary to move to more specialised tools to achieve better efficiency or scalability. This adaptability, and its ability to serve as a launching pad, make Excel an indispensable tool.

What is Excel good at?

Building on its role, Excel's true strength lies in its ability to handle a wide array of tasks efficiently and effectively:

• Agility: Excel is incredibly flexible. You can quickly and easily change cell values, formulas, functions, charts or layouts with just a few clicks. Compared with other applications that may require lines of programming code for similar adjustments, Excel simplifies the process and makes it accessible to more users. Newer features such as dynamic array formulas extend that flexibility further.
• Multi-purpose: From data storage and processing to reporting, Excel can manage it all. While specialised tools often excel in their specific domains, Excel's all-in-one capability can save time and effort by consolidating tasks on a single platform. This versatility is particularly valuable for users seeking a streamlined workflow.
• Lower investment: Excel is cost-effective compared with the combined expense of specialised tools. Its subscription cost and the minimal time needed to build spreadsheets often make it the preferred choice for businesses. This affordability, coupled with its wide-ranging utility, is a key reason why Excel remains a staple in most workplaces.
• Compatibility: Excel's widespread adoption ensures compatibility and ease of collaboration. Sharing an Excel spreadsheet with colleagues or external stakeholders is straightforward, and there is a high likelihood that they will understand and interact with the content effectively.

What are Excel's weaknesses?

• Dependency on user skills: Excel is highly dependent on the user's skills. Users must select and apply the correct formulas or functions for computations — for example, knowing when to reach for XLOOKUP or VLOOKUP. If the wrong functions are used, the output may not be accurate, leading to potential errors in the results.
• Limited security: Although Microsoft improved security with the move from XLS to XLSX formats, Excel still does not provide adequate protection over data, computation logic and access controls. This limitation often drives users to choose other tools over Excel. While these weaknesses can be mitigated to some extent through VBA coding, it requires significant effort and reduces the workbook's agility.
• Performance issues: Excel performs well with a few lines of data and formulas. However, as the amount of data grows, the application tends to lag and computations can become slow. Many users have experienced this limitation when working with large datasets.
• Integration challenges: While less critical in the past, integration is now a significant requirement in today's interconnected world. Excel lacks robust native integration with other applications, particularly cloud-based ones. Tools such as Power Query can help bridge some of these gaps — for example, when streamlining consolidation with Power Query.

At a glance, Excel's strengths and weaknesses tend to sit side by side:

Strengths	Weaknesses
Agile and flexible to change	Depends heavily on user skill
Multi-purpose, all-in-one platform	Limited security and access controls
Low cost of ownership	Performance drops on large datasets
Widely compatible and easy to share	Weak native integration with other systems

How do you decide between Excel and a BI tool?

Accountants often rely on Excel to perform financial analysis. As the complexity or scope grows, it reaches a point where they need to evaluate whether to implement a more specialised BI (business intelligence) tool for data analytics. Walking through an evaluation process is key. Here is one way to approach it:

• User proficiency: Assess whether users can understand and operationalise the analysis requirements. If they are experienced and can customise Excel to meet complex needs, it may remain a viable choice. If they need pre-built templates or the automated features available in BI tools, moving to those tools could save time and reduce errors, ensuring smoother workflows.
• Data sensitivity: If the analysis is to be shared with multiple parties, evaluate whether sharing an Excel file could expose sensitive data or formulas to the risk of unauthorised or accidental changes. BI tools often provide better security controls for shared analyses.
• Data volume: Large datasets can quickly overwhelm Excel, leading to performance issues such as lagging or crashes. BI tools are designed to handle extensive data volumes efficiently, making them a better choice in such cases.
• Frequency of analysis: If the analysis needs to be performed frequently, consider a BI tool that connects seamlessly with upstream data sources, such as your accounting software. This enables real-time analysis and removes the need for repeated manual data updates.

By carefully evaluating these factors, you can decide whether to stick with Excel or move to a specialised tool for better outcomes. Always weigh the incremental costs — money, time and effort — against the incremental benefits. This gives a clearer view of whether the shift aligns with your objectives and resources.

The bottom line: should you stick with Excel?

Excel remains the first go-to tool for accountants because of its cost-effectiveness, versatility and multi-purpose nature. However, achieving optimal results requires recognising its limits and knowing when to move to specialised tools. Starting with Excel often serves as an effective foundation, letting professionals adapt and expand to specialised solutions as their needs grow and evolve.

It also encourages users to reflect clearly on their needs and requirements. That clarity can make subsequent implementation smoother and more effective, particularly in the context of automation or technology adoption — and particularly as the role of accountants continues to evolve.