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

11. February 2020

A notebook for Excel and Google Sheets

Computational notebooks have taken the DataScience world by storm over the last few years - and for a good reason.

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....

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.

12. February 2021

Facewatch drives sales with client reports

GRID-powered client reports help Facewatch generate sales.

21. October 2017

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

The world has a love/hate relationship with spreadsheets.

06. March 2018

Your biggest competitor is a spreadsheet

If you are in the software industry, odds are that your biggest competitor is a custom spreadsheet created by your...

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...

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...

25. November 2019

Spreadsheets lack people skills 

Spreadsheets are frequently shared or their findings reported on but the manner in which this is commonly done is counter-productive...