15. September 2018

What’s your level? Six levels of spreadsheet user sophistication

In preparing everything from the product features and UI to the go-to-market plan and messaging for GRID, we have realized that it will be helpful to look at users’ spreadsheet knowledge by levels of sophistication.

Through conversations with spreadsheet users, expert consultants and through deep analysis of a corpus of more than 100 thousand spreadsheets (more on that later) we have come to the following conclusion.

We’d be interested to hear if these levels make sense to you and which level you believe you belong to:

  1. Spreadsheet consumer Has Excel installed (or has logged on to Google Sheets) Opens and views files provided by others

  2. Spreadsheet basic user Creates new Excel files (or Google Sheets documents) Enters data and basic formulas +, -, *, /, SUM(), AVERAGE(), ROUND()

  3. Spreadsheet intermediate user Uses more sophisticated functions such as IF(), FIND(), NOW(), SUBTOTAL(), … Uses - but does not create - pivot tables May name cells and ranges

  4. Spreadsheet pro Uses VLOOKUP() (and soon thereafter INDEX(MATCH()) ) Creates pivot tables May use Data Tables

  5. Spreadsheet developer Has the Developer tab turned on Creates forms (Excel) or uses Google Forms Records macros

  6. Spreadsheet scripter Writes VBA code (Excel) or Apps Scripts (Google) Uses PowerQuery and PowerPivot

More blog posts

23. March 2021

GRID launches empowering spreadsheet-to-web software 

It’s launch time, and we couldn’t be more thrilled. Something special happens when a team this passionate unites behind a...

21. October 2017

3 things you don’t understand about spreadsheets (Part 1)

The world has a love/hate relationship with spreadsheets.

27. October 2017

3 things you don’t understand about spreadsheets (Part 2)

This is part 2 of 3 in a series of posts about the nature and history of spreadsheets.

28. August 2018

Excel vs. Google Sheets usage — nature and numbers

One of the most common questions I get is if Excel is still important, implying that “everybody” must be using...

16. October 2018

The 3 types of spreadsheets

We have been taking quite a deep dive into the world of spreadsheets lately. We have analyzed tens of thousands of...

03. November 2017

3 things you don’t understand about spreadsheets (part 3)

This is the third and final part of a series of blog posts on the origin and nature of sspreadsheets.

14. December 2018

The 20 Best Spreadsheet Quotes

In GRID’s deep dive into the world of spreadsheets, we’ve come across a lot of insightful, witty and sometimes somewhat distressing quotes....

08. February 2019

Excel — a Domain Specific Language for Finance?

One of my biggest inspirations when doing background research before starting GRID was Felienne Hermans. I met Felienne first at Strata in London...

07. May 2019

The Case for Modern Productivity Tools

Several startups are realizing the power of spreadsheets and the spreadsheet “metaphor” as an end-user development approach: A way to...