Gsheet
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

22. August 2022

Drive sales with interactive price quote calculators 

Save your sales team time & guide clients to better informed decisions.

14. September 2022

Launching Scratchpad: GRID as an end-to-end data tool

The perfect solution for daily analysis & reporting.

24. August 2022

How IonQ uses GRID to support strategic decision-making

Jordan Shapiro tells us how GRID helps IonQ executives make data-driven decisions.

27. June 2022

Interactive GRID features for engaging teamwork  

Interactive GRID features are extremely effective in enabling collaborative analysis — especially when used in combination.

04. November 2021

Introducing Conversations: a new way to explore & explain data

We’re thrilled to announce the launch of Conversations, a game-changing new feature designed to facilitate communication and collaboration in context.

23. March 2021

GRID launches empowering spreadsheet-to-web software 

We’re launching our revolutionary spreadsheet-to-web tool that will give superpowers to spreadsheet users around the world!

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

14. December 2018

The 20 Best Spreadsheet Quotes

We've deep dive into the world of spreadsheets and come across a lot of insightful, witty and distressing quotes. Here...

31. July 2019

Spreadsheets, we have a problem!

GRID is built to allow spreadsheet users to make even more of their spreadsheet skills and assets by overcoming some of...