MGBA - Midland Group Business Advisors

Practical advice from the independent experts

0333 444 8522
practical-advice@ukba.co.uk
  • Google+
  • LinkedIn
  • Twitter
Members Area

Navigation

  • Home
  • Benefits to Businesses
    • General Data Protection Regulation
    • Marketing
    • Business Fundraising
    • Selling Your Business
    • Intellectual Property
    • Sustainability and Environmental Impact
  • Downloads
    • E-books and White Papers
    • Newsletters
  • News
  • Who We Are
    • Business Advisors
    • Local Groups
    • Our Mission and Vision
    • Join Us as a Business Advisor
  • Contact

Excel automation

March 23, 2017 By Bob Lewis-Basson

Not more spreadsheets to analyse and chart…

Always a regular cry in the office.  Reports produced on a regular basis need to be embellished, with charts that involve some fairly complicated calculations – cross-reference look-ups, previous month comparisons, and all that sort of thing.

Probably, now this is done largely by hand.  The data sits in several spreadsheets and/or databases, and is extracted, filtered, pivoted and everything else that was necessary to get it ready, before feeding into a chart.  When the chart was ready, it is pasted into the report.

Wouldn’t it be great with the data is all in one place, and with a single front-end, the necessary criteria set from drop-downs.  Once these selections have been made (locations, benchmarks, which dataset to use, and so on) you click a button and go and make coffee.  Actually, you haven’t really got time to make coffee as the process takes just a couple of minutes – if that.

In this instance, any number of queries can be run; sometimes one query, sometimes several to generate the data.  Each one automatically loading a into an Excel workbook, in to the right columns, in the right order to aid presentation.  Then, your screen explodes into a fresh multi-coloured set of charts based on the information just collated! And is that the pivot table I slave over every month appearing before my very eyes!

In the past that has meant spending anything between a couple of hours to a couple of days for more complex reporting every period. Multiply that by twelve, and it becomes a not insignificant amount of time in a year m to get these twelve reports, graphs and charts prepared.

Say it was half a day of someone’s time, at the average salary of £26,000 – that’s a cost of around £60+ to the business for each report, or chart.  Each and every time.

If reporting is weekly, that’s going to be more than £3,000 every year – more likely a lot more than that.  If it now takes 30 minutes to do the whole job, that’s a total of just over 4 days for the whole year’s worth (at one report a week).  The four days will cost under £500.  So you get to keep £2,500 to do something else with.

What would you like to do with it?

Excel automation by Bob Lewis-Basson – 07802 441 728

Filed Under: All blogs, Business Planning, Managing your business finances, Operations and Technology, People, Strategy

  • Home
  • Benefits to Businesses
  • Downloads
  • News
  • Who We Are
  • Contact

Copyright © 2021 · Dynamik-Gen On Genesis Framework · WordPress · Log in

This website uses cookies to improve your experience. We'll assume you're ok with this, but you can opt-out if you wish.Accept Read More
Privacy & Cookies Policy

Privacy Overview

This website uses cookies to improve your experience while you navigate through the website. Out of these, the cookies that are categorized as necessary are stored on your browser as they are essential for the working of basic functionalities of the website. We also use third-party cookies that help us analyze and understand how you use this website. These cookies will be stored in your browser only with your consent. You also have the option to opt-out of these cookies. But opting out of some of these cookies may affect your browsing experience.
Necessary
Always Enabled

Necessary cookies are absolutely essential for the website to function properly. This category only includes cookies that ensures basic functionalities and security features of the website. These cookies do not store any personal information.

Non-necessary

Any cookies that may not be particularly necessary for the website to function and is used specifically to collect user personal data via analytics, ads, other embedded contents are termed as non-necessary cookies. It is mandatory to procure user consent prior to running these cookies on your website.