+1 650 491 3131

Cost Centre Report Automation

10 Hours

Before Automation

30 Minutes

After VBA Automation

9.5 Hours

Time Saved per month

  • Industry:
  • Banking, Financial Services

Company Profile: British multinational banking and financial services company headquartered in London, England. It operates a network of more than 1,200 branches and outlets across more than 70 countries

  • Department:
  •  Finance
  • Tool(s) Used:
  • Microsoft Excel VB Programming (Macro)

Need for Automation:

The First week of every month, requires 23 cost Centre reports and more than 20 singular reports to be generated, consuming 10 man-hours per month. Consistently the YTD spending figures should be refreshed and once in three months, the estimate should be changed in the solidified cost focus report – increasing the possibility of duplicate glue and human-prone errors – which in turn requires reconciliation.

Cost-Benefit Analysis (Post Macro Implementation)

Activity # Description Frequency Time Consumed - Manually Time Consumed - After Automation Total Time Savings Per Activity (per day) Total Time Saved Per month
1 Cost Centre Reports One time in a month 10 Hours 30 Minutes 9 hrs 30 mins 114 hrs
Total 8.75 Hours 1 Minute 8.75 Hours

Cost-Benefit Analysis (Post Macro Implementation)


Cost Centre Reports

Frequency (Monthly)

One time in a month

Time consumed manually

10 Hours

Time Consumed for automated activity

30 Minutes

Total time savings per activity

9 Hours 30 Minutes

Total time saved Per month

114 Hours

Join our 10-day online session and learn how to automate your Excel Reports and Processes using VBA Programming. No prior programming experience needed!.

Upcoming Schedule:

  • Date:
  • Sunday, July 11
  • Time:
  • 10:00 AM - 12:30 PM (ET)

Proficiency with Excel formulas is a prerequisite. Not sure about your skills? Schedule a pre-assessment at 650-491-3131 to gauge your Excel proficiency.

You'll dive into 90 practical scenarios, explore 7 case studies, and complete a Live VBA Project.

Ready to learn Excel VBA Macro?