The World Runs On Excel

Home » Blog » Software » Enterprise Software » The World Runs On Excel

There’s been a lot of talk lately about the importance of Excel and that Excel is everywhere.

I’d even go as far as saying that most of the world in one way or another runs on Excel. Excel in my opinion is the best piece of software Microsoft has made so far (other people seem to agree with me, by the way). While Microsoft didn’t invent the spreadsheet – that credit goes to VisiCalc and IBM with Lotus 1-2-3 – they were the ones who popularized the use of spreadsheets to an extent that nowadays the term spreadsheet itself has become synonymous to Excel.

Excel has become a general purpose tool that’s used by business people to quickly implement software solutions. Excel is not only used for calculations but for data storage, data entry and even fully-fledged applications with complex user interactions. Most software developers would probably argue that this is a pretty dangerous development because Excel wasn’t meant to be used as a general purpose programming tool, IDE or relational database and lacks a lot of features of proper software development tools and RDBMS. Developing business tools with Excel introduces a lot of problems such as data inconsistency, a software maintenance hell and lack of version control and multi-user capabilities. These problems certainly are valid and proper software developers are – to an extent – right in bashing Excel-based solutions.

However, the point this criticism misses is that Excel is a tool that gets the job done. The results often might not be pretty or well-designed software but they quickly provide solutions to problems that might have taken a lot longer if implemented properly with proper tools. In a way, Excel is like Perl in that respect, it makes easy things easy and hard things possible. So, I’d say that as entrepreneurs and developers we shouldn’t disregard Excel-based solutions but instead should embrace them and think about how we can help Excel users with improving their solutions.

Several points come to mind as to how Excel-based software might be improved:

  • Using version control for storing and sharing Excel spreadsheets.
  • Introducing best practices for Excel-based software development.
  • Promoting code review and code reuse by storing user-created functions and macros in some kind of central repository that is accessible for everyone in an organisation.

These are just some quick thoughts. There sure are ample opportunities for entrepreneurs to provide useful services and products to Excel users.

One comment
  1. Pingback: Airtable – A true spreadsheet / database hybrid? | Björn Wilmsmann

Leave a Comment

* Checkbox GDPR is required

*

I agree

By continuing to browse the site you agree to our use of cookies. Privacy Policy

Privacy Preference Center

Strictly necessary

These cookies are necessary for the site to function.

PHPSESSID: Preserves user session state across page requests.

__cfduid: Used by the content network, Cloudflare, to identify trusted web traffic.

PHPSESSID
__cfduid

Preferences

Remembers the user's submitted data when a comment is submitted in a blog post. The purpose is to aut o-populate form fields for subsequent comments, in order to save time for the user.

wfvt_#

Statistics

Statistic cookies help us to understand how visitors interact with our websites by collecting and reporting information anonymously.

_ga: Registers a unique ID that is used to generate statistical data on how the visitor uses the website.

_gat: Used by Google Analytics to throttle request rate.

_gid: Registers a unique ID that is used to generate statistical data on how the visitor uses the website.

collect: Used to send data to Google Analytics about the visitor's device and behaviour. Tracks the visitor across d evices and marketing channels.

_ga,_gat,_gid
collect

Security

We use Wordfence to secure our website against hacking attempts: https://www.wordfence.com/

wordfence_verifiedHuman

Close your account?

Your account will be closed and all data will be permanently deleted and cannot be recovered. Are you sure?