Excel and spreadsheet help: a guide for pros

What customers ask, how to win the job, and what to put on your profile.

Offering excel and spreadsheet help

You fix and build spreadsheets for clients, so they judge you on correct numbers, clear layouts and a file they can maintain. Explaining what changed and why is as important as the fix itself.

What customers ask

  • Why are my totals wrong?
  • Can you make a dashboard?
  • Will I be able to update it myself?
  • Can you automate this report?
  • How long will it take?

How to win the job

  • On the first call, ask what the file is used for, who uses it, and the numbers that look wrong
  • Review the formulas and links and list each problem you find
  • Keep the original file and show the client the before and after numbers
  • Protect the cells that must not change and explain how to edit the rest
  • Train the client on the file in a short session and leave a written guide
  • Check the macros on the client's software version before handover

What to put on your profile

  • Examples of spreadsheets you fixed, with the problem and the result
  • The software versions and tools you work with
  • Your review and handover process in plain words
  • Your contract terms for ownership of the files

Follow-up that helps the customer

  • Offer a yearly review of the file as the business grows
  • Suggest a dashboard or report when the client needs one
  • Send a note on keeping backups of the file

Licenses and permits

Spreadsheet help is usually not licensed. Check state and local rules for business registration and for how client financial data is stored and protected, and keep your insurance and confidentiality terms current.

Questions

What do I do when a client's file has a formula that is wrong on purpose?

Explain the effect on the numbers in writing, and ask the client to confirm the logic before you change it.

How do I handle a client who wants macros for a file that goes to other people?

Explain the security warnings they will see and the trust needed to run macros, and suggest a safer design if one exists.

Pro reviewers

Pros who offer excel and spreadsheet help remotely can improve this guide, like Wikipedia. We check every edit before it goes live. Every approved edit is credited in the edit history and on the pro's profile.

Edit history

How guide reviews work

More web and software development guides for pros

Start here

About this guide

Get excel and spreadsheet help requests

Customers pick you by name. Signup is free, and you pay only for leads you accept.

Join as a pro
Sign up free