How can Excel Insights help you?
Do you need a quick solution to an Excel problem? Are you struggling to find money in your budget to hire a full-time Excel expert? Don't worry! Excel Insights could be the answer you're looking for.
Find Out MoreCase Studies
See our selection of case studies to illustrate how we can help save your business money and streamline your operations.
Find out MoreLatest Articles
VLOOKUP? Try INDEX & MATCH instead…
The INDEX and MATCH functions are vastly underused, and can provide a more effective solution than VLOOKUP in many situations. An example for a basic INDEX/MATCH formula is shown below: using “=INDEX(‘data range’,MATCH(‘search value’,’search range’,0)” A B 1 Type Number 2 Cars 2 3 Vans 3 4 Motorcycles 4 5 Bicycles 5 To [...]
Read moreExcel Quick Tip – Snapshot Tool (or Camera)
There’s a feature of Excel that’s not widely known, so for those of you who don’t already know about the Snapshot/Camera tool, here’s how to use it: The snapshot tool allows you to create a picture object that acts like a ‘live feed’ into another worksheet or workbook (spreadsheet). It allows you to magnify charts, [...]
Read moreData Table With Input Form
Free Download! There are two versions of this Excel template, one with a VBA userform for input, the other with the input form on another sheet – please feel free to download whichever version you’d prefer to adapt. The VBA code may be easily adapted to include additional fields, by following the logic outlined within [...]
Read moreCase Studies
Cost Saving Tracker / Business Improvement Database
Medium Scale Project: Data tables with input forms, audit log, and central reporting of values and progress of projects.
Read moreSupplier Management Balanced Scorecard System
Large Scale Project: A prototype Supplier Management database, enabling the client to track and measure supplier performance.
Read moreEmployee & Contractor Timesheet Application
Small Scale Project: An automated timesheet solution that streamlined payroll processes and saved the company over £4000 per year.
Read more