Excelgoodies +1 650 491 3131

Manual Mapping and Attrition Simulator

49.5 Hours

Before Automation

9.3 Hours

After VBA Automation

40.2 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:
  •  Human Resource
  • Tool(s) Used:
  • Microsoft Excel VB Programming (Macro)

Need for Automation:

The Human Resource team spends approx. 36 hours monthly on generating BAU and HR related reports – ad hoc in structure. Considering the importance to be given to the intuitive attrition analysis for effective decision-making, automation was required to remove this manual work on dicing, slicing and data cleanup to a great extent, allowing users to dynamically play with the data.

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 Manual Mapping 180 15 Minutes 3 Minutes 12 Minutes 2160 Minutes (36 Hrs)
2 Attrition Simulator 9 30 Minutes 2 Minutes 28 Minutes 252 Minutes (4.2 Hrs)
Total 8.75 Hours 1 Minute 8.75 Hours

Cost-Benefit Analysis (Post Macro Implementation)

Frequency (Monthly)

180 Times

Time consumed manually

15 Minutes

Time Consumed for automated activity

3 Minutes

Total time savings per activity

12 Minutes

Total time saved Per month

2160 Minutes (36 hrs)

Frequency (Monthly)

9 Times

Time consumed manually

30 Minutes

Time Consumed for automated activity

2 Minutes

Total time savings per activity

28 Minutes

Total time saved Per month

252 Minutes (4.2 hrs)

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 evaluate your Excel proficiency.

Explore 90+ practical scenarios, delve into 7 case studies, and complete a live VBA project.

Ready to learn Excel VBA Macro?