+1 650 491 3131

Daily Tracker Automation

60 Hours

Before Automation

3.67 Hours

After VBA Automation

56.33 Hours

Time Saved per month

  • Industry:
  • Business Process Outsourcing

Company Profile: It is a private equity holding company, headquartered in New York with operating and portfolio companies located in the United States, India and Brazil.

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

Need for Automation:

I am required to collate the workload and the current status of every activity for my team which approx. takes 90 minutes of my daily activity – which then will be forwarded to my team manager for resource allocation. In order, to spend more time on the productive work, and avoid getting frustrated with the monotonous work, I look forward to automating this activity.

Microsoft Excel VB Programming (Macro) and MS-Access (database)

Activity # Description Frequency Time Consumed - Manually Time Consumed - After Automation Total Time Savings Per Activity (per day) Total Time Saved Per month
1 The entire team’s data are consolidated into a single file and daily report on the day’s work is generated and sent to the client 20 Working Days 1 Hour 5 Minutes 55 Mins 18 hours 20 Minutes
2 Workload report is generated using the data from the daily report and is updated to a database, and emailed to Manager 20 Working Days 1 Hour 2 Minutes 58 Mins 19 hours 20 Minutes
3 Performance Report based on the input received is generated by connecting to the database and the entire data is exported to table in the excel sheet. From that data, a single report is created for the received input 20 Working Days 1 Hour 4 Minutes 56 Mins 18 hours 40 Minutes
Total 8.75 Hours 1 Minute 8.75 Hours

Cost-Benefit Analysis (Post Macro Implementation)

Description

The entire team’s data are consolidated into a single file and daily report on the day’s work is generated and sent to client

Frequency

20 Working Days

Time consumed manually

1 Hour

Time Consumed for automated activity

5 Minutes

Total time savings per activity

55 Minutes

Total time saved Per month

18 Hours 20 Minutes

Description

Workload report is generated using the data from the daily report and is updated to a database, and emailed to Manager

Frequency

20 Working Days

Time consumed manually

1 Hour

Time Consumed for automated activity

2 Minutes

Total time savings per activity

58 Minutes

Total time saved Per month

19 Hours 20 Minutes

Description

Performance Report based on the input received is generated by connecting to the database and the entire data is exported to table in the excel sheet. From that data a single report is created for the received input.

Frequency

20 Working Days

Time consumed manually

1 Hour

Time Consumed for automated activity

4 Minutes

Total time savings per activity

56 Minutes

Total time saved Per month

18 Hours 40 Minutes

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?