• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar
Health Connective

Health Connective

  • About
  • Projects
    • Surgical Case Review Portals
    • Online Product Catalog
    • Field-Based Program Tracking System
    • Account Management Dashboard
    • Surgical Device Certification System
    • Internal Resources Website for Marketing Division
    • Co-Branding Dashboard
  • Resources
    • Insights
      • Marcom
      • R&D
    • Healthcare Marketing Conferences
    • How to Build a Better Dashboard
    • Building an App for That: A 3-Step Planning Guide
  • Get Started
    • Discovery Process
    • Consultation

Your Spreadsheet Is Holding You Back

January 11, 2023

I love spreadsheets, too. They work. They really do… until they don’t.

Spreadsheets Are Awesome

Can we take a moment to appreciate what Microsoft Excel, Google Sheets, Apple Numbers, and all the other spreadsheet software out there can do for us? They help us with financial tracking and calculations, but that’s only a fraction of what people use spreadsheets for. 

As I’m writing this, I have two spreadsheets open. One is tracking my time for the day so I know how many hours I worked and when I took breaks for lunch, my haircut, getting ready for some travel, and whatever other needs popped up during the day. The other spreadsheet is a list of priority tasks for the rest of the week, which allows me to easily adjust my priorities when emergent needs arise.

I have another spreadsheet to track all the content that will go on this website and the related social media posts needed to share that content further. 

I could go on and on about how I use spreadsheets, and you likely could, too. 

There’s a whole section of TikTok blowing up over how to use spreadsheets more effectively. It’s wild.

All that, and yet…

Your spreadsheet is holding you back. 

When to Leave the Spreadsheet Behind

This isn’t an effort to get you to delete your favorite spreadsheet software entirely. I just want to point you to a few use cases where an Excel doc or Google Sheets link might be too limiting. 

1. You Need to Share Data Widely with Customers, Other Key Stakeholders

A spreadsheet can certainly be shared with more people, but there’s a look of “hey, I just slapped this together before our call” that goes with a spreadsheet. If you’re trying to inspire confidence from your customers with a fully branded experience, then you likely want a dedicated system specifically for this use case.

More importantly, you lose all context when sharing important information in a spreadsheet. Usually, the data is collected and organized by some governing thought process or system that is not immediately apparent to a reviewer. If it’s important enough to share, then it’s probably trying to communicate something. The spreadsheet reinforces the info and proves the point you want to make but in isolation could even be harmful to the stated goal. 

(Shameless promotional plug: this is the kind of work we’ve done for medtech companies.)

Analyst Employee Working On Spreadsheet Using Laptop
Your spreadsheet contains some of the data you need, but it may be lacking in branding and context.

2. You Need to Be More Efficient with Your Teams’ Time

If you need to share information through a spreadsheet with a large group at a time—even internally, your audience will have to be made up of power users of that spreadsheet software in order to apply the right sorts and filters. They’ll also need to understand the relationships between all of the data to begin working with it. 

Surprisingly enough, not everyone knows how to work a pivot table.

A well crafted application interface makes it quicker and easier for users to get what they need and requires little to no training.

3. You Need Other Sources to Be Able to Feed in Data Securely 

Google Sheets made things easier to be able to grab data from other sources. With tools like Zapier, you don’t even have to know how to code to grab that information. 

Still, if you need to lock down the security of these tools for regulatory purposes, you can’t use Zapier. You can look to teams like Redox to help with passing critical healthcare data in and out of EHRs, or you can work with others to develop any number of custom solutions. 

By leaving the spreadsheet behind, you can work with systems that will allow records to be matched against one another from a variety of systems. For example, you can match your own custom records to Salesforce records to help explain which sales reps are generating the most business, and then distill that info into key metrics that can be presented back in a dashboard.

Budget planning, spreadsheet with report graph
Be careful with editing those cells! You might just delete some data you needed without noticing.

4. You Need a More Error-Proof System

I think we’ve all accidentally messed something up in a calculation or accidentally deleted an important cell within a spreadsheet without realizing it. If you’re sharing data across multiple users, the potential for this kind of error only increases. Yes, these systems will often allow you to revert to a version of the sheet where the info can be added back, but you run the risk of losing any new data added in since that error.

Large software has its own potential vulnerabilities, but it’s much easier to build in consistency in your data transformations.

Time to Reframe

As you share data more widely, you’ll start to get feedback from your audience, and they don’t necessarily think about the data in the same way you did when you were building out your initial spreadsheet. Visualizations that seem the most logical to you may not resonate with your audience. 

Up until now, you’ve been able to decide exactly where each piece of information should live, in the way that made the most sense to you, but there are a lot of ways to share information. Other ways might be more broadly understood. Keep an open mind as you let others get involved to develop a system around the data. 

You’ll be surprised at what’s possible.


Consultative Service Now Available

Maybe you don’t need to build a new application at your company just yet, but you have an idea that’s percolating. Or, maybe you’ve got a marketing system that could use an outsider’s perspective.

We’ve got a way to help. We now offer consultation calls that include a marketer and a programmer. The idea is to help you troubleshoot at the conceptual level so you can work with your team to implement the fix.

If you’re interested, be sure to check out our new offering.

Michael Roberts
Michael Roberts

Michael spends a great deal of time with the healthcare industry both professionally and personally, which gives him the perspective of what stakeholders on either side of the care equation need.

He began coding in 2008 and subsequently shifted his attention entirely to online marketing. Michael completed his MBA in 2018, focusing on the intersection of healthcare and marketing.

  • Michael Roberts
    https://www.healthconnectivetech.com/insights/author/michaelrhealthconnectivetech-com/
    Medtech Companies Need to Create Meaningful Customer Communities
  • Michael Roberts
    https://www.healthconnectivetech.com/insights/author/michaelrhealthconnectivetech-com/
    Are We Carving Out Enough Time to Think? 
  • Michael Roberts
    https://www.healthconnectivetech.com/insights/author/michaelrhealthconnectivetech-com/
    Control Marketing Anxiety with Deliberate Boundaries
  • Michael Roberts
    https://www.healthconnectivetech.com/insights/author/michaelrhealthconnectivetech-com/
    Five Reasons Why IT Doesn't Want to Support Your Next Martech Purchase
Justin Bantuelle
Justin Bantuelle
Chief Operating Officer & Web Technology Director at Health Connective

Justin Bantuelle balances the responsibilities of both the Chief Operating Officer and the Web Technology Director after having worked with Health Connective for more than a dozen years. Justin regularly leads the cross-disciplinary teams in building out and updating applications for Fortune 500 companies.

Justin keeps his technical abilities sharp by contributing to an eclectic mix of open-source and personal projects on Github.

  • Justin Bantuelle
    https://www.healthconnectivetech.com/insights/author/justinhealthconnectivetech-com/
    Automation Essentials
  • Justin Bantuelle
    https://www.healthconnectivetech.com/insights/author/justinhealthconnectivetech-com/
    Testing Essentials
  • Justin Bantuelle
    https://www.healthconnectivetech.com/insights/author/justinhealthconnectivetech-com/
    Five Reasons Why IT Doesn't Want to Support Your Next Martech Purchase
  • Justin Bantuelle
    https://www.healthconnectivetech.com/insights/author/justinhealthconnectivetech-com/
    Want to Avoid Headaches? Insist on Repeatability

Marcom

Primary Sidebar

Table of Contents

  • Spreadsheets Are Awesome
  • When to Leave the Spreadsheet Behind
    • 1. You Need to Share Data Widely with Customers, Other Key Stakeholders
    • 2. You Need to Be More Efficient with Your Teams’ Time
    • 3. You Need Other Sources to Be Able to Feed in Data Securely 
    • 4. You Need a More Error-Proof System
  • Time to Reframe
  • Consultative Service Now Available

Sign Up for the Marcom Newsletter

Twice a month, we send the latest content from the Health Connective site to help you with the planning of your projects and your team dynamics.

Popular Marcom Posts

  • When Should a Medtech Company Build a Custom Application?
  • 5 Keys to Creating an Effective Physician Finder
  • Tips for Running a Successful Co-Branded Campaign for Medtech Companies

Search

Welcome!

Michael Roberts

In these blog posts, we share tips from our work with marcom teams, including how to evaluate whether or not you need a custom application, how to effectively communicate what you need to developers (whether in-house or third-party), and how to demonstrate value to the C-suite and your customers.

--Michael Roberts, Marketing Director

Recent Marcom Posts

  • Medtech Companies Need to Create Meaningful Customer Communities
    January 25, 2023
  • Your Spreadsheet Is Holding You Back
    January 11, 2023
  • Are We Carving Out Enough Time to Think? 
    December 27, 2022
  • About
  • Insights
  • Cookie Policy
  • Privacy Policy
  • Get Started
  • Consultation Package
Health Connective

(504) 581-4636
TwitterLinkedIn