Spreadsheet tools that bring joy

I’m Jac, a developer and automation expert from Cambridge, UK.

I create tools and scripts that save you time, simplify your workflow, and make your day more joyful. Many of these tools are spreadsheet-based, e.g. Microsoft Excel, as that’s often the quickest place to get started.

If you’d like to discuss a project with me, please get in touch.

What I do

I can help you improve your workflow in a range of ways:

Programming

Automate cumbersome tasks in Microsoft Office (Excel, Word, PowerPoint etc.) using VBA (Visual Basic for Applications, i.e. macros). Extract and process data, generate reports, edit documents etc. with a click of a button.
Create custom Office add-ins to automate tasks across Excel, Word, Outlook, PowerPoint etc. using the Office.js JavaScript API.
Create custom Python scripts and applications.
Automate Google Sheets, Docs and Forms using Google Apps Script.

Custom Excel spreadsheets

Create bespoke Excel tools, models and calculators, e.g. for pricing, time management, planning etc.
Update existing tools to streamline and fix problems.
Provide formula and spreadsheet design expertise.

Testimonials

“Jac solved a real headache for us, by creating a tool which auto-generates personalised Excel timesheets for workers. Until now creating, reconciling and fixing timesheets was a long and mind-numbing manual task which I dreaded. Jac has been an absolute pleasure to work with and her wizardry has saved me lots of time and admin! I wouldn’t hesitate for a moment to recommend her.”

Why “Spreadsheet Joy”?

Spreadsheets are a great place to start with workflow automation!

Most people are familiar with spreadsheets to some extent – although not everyone realises how powerful they can be. It’s likely that you already have some handy spreadsheets you’re using in your day-to-day business. Wouldn’t it be great if you could get these spreadsheets to do X, Y, Z as well?

Maybe there’s a tedious, manual process you find yourself repeating over and over again – wouldn’t it be good to automate that? Or maybe you’re looking for more consistency in your business processes – how can you make sure things are done the right way every time?

Adding automation and validation to your spreadsheets and documents is a great way to make them more efficient and more robust. Plus, it’s easy to make further updates in future, if needed. And everyone who’s familiar with Excel, Word etc. will be able to use them.

This is where I started out on my journey into automation – making spreadsheet tools to extract environmental data, process them and put them into reports. It was the fastest way to create time-saving tools that could be used instantly by everyone in my team.

Of course, you cannot automate everything with a spreadsheet – nor should you try! There are some tasks that are better handled another way, e.g. using a database or a Python script. I am happy to advise on what’s best for your project, so please get in touch to discuss.