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

19. May 2022

How to write a board report

Need to write a board report? We’ve got a free template & tons of tips!

03. March 2022

We can all be numbers people!

Our CEO Hjalmar believes we can all be numbers people. Here’s how he sees GRID making everyday data work easier.

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

09. March 2022

Empowering homebuyers with smart GRID tools

Win the House You Love helps American homebuyers make confident financing decisions 🏠

07. January 2022

What's next for GRID?

In 2022, we're transforming GRID to become the primary tool of choice for modern teams working with numbers.

11. March 2021

Easy, no-code calculators grow your business

Creating an embedded calculator based on your spreadsheet data is a simple way to build a powerful, customized web tool.

04. November 2021

Introducing Conversations: a new way to explore & explain data

Now we’re really talking. We’re thrilled to announce the launch of Conversations, a game-changing new feature designed to facilitate communication...

27. October 2021

Interactive GRID features that boost user engagement

GRID was built for interactive exploration. When you consider ways to attract and engage new clients on your website, GRID...

30. September 2021

Build a price quote calculator in 5 easy steps 

Embed interactive features like calculators on a website, and voilà! They become super-engaging conversion rate boosters 🚀