Loading page content
If someone spends hours each week or month copying figures between spreadsheets, that work can usually be automated, often with tools you already pay for in Microsoft 365.
Tools we use
Sound familiar?
The same steps are repeated every week: open the export, copy the range, paste it into the master file, fix the formulas.
Only one person knows how the report is built, so it stops when they are on holiday or leave.
A wrong range or a missed row can change the numbers without anyone noticing.
By the time the monthly pack is ready, it is too late to act on what it shows.
Projects from
£750
Most automation projects fall within our Starter or Business dashboard prices. Monthly support from £250 keeps everything running as your processes change.
See pricingWe look at your current setup, ask what decisions you need to make, and tell you honestly whether we can help.
You get a written scope, a timeline and one fixed price. No day rates, no surprises.
We build it, walk your team through it, and leave documentation so you are never stuck.
Based in Edinburgh
Collinalitics is a founder-led consultancy based in Edinburgh. We meet in person across Edinburgh and the Lothians, and work remotely with businesses across Scotland and the UK.
Something else on your mind? Ask it in a free 30 minute review.
Usually not. Power Query is built into Excel, and Power Automate is included in many Microsoft 365 business plans. We use what you already have wherever possible.
It depends on the process. Before quoting, we estimate the hours you spend now and what would be left afterwards, so you can judge whether it is worth it.
Often, yes, either through a direct connection or a scheduled export. We check what your system supports during the free review.
The automation is documented so it can be updated. Monthly support from £250 covers changes, fixes and new reports.
Automations run inside your own Microsoft 365 account, so your data stays in systems you already control.
Book a free 30 minute review. We will look at your setup and tell you what we would fix first and what it would cost.