GET MONTHLY INSIGHTS
Be the first to know about new Microsoft Excel courses, upcoming batch schedules, certifications and more.
@
Be the first to know about new Microsoft Excel courses, upcoming batch schedules, certifications and more.
Prove you're human: Type the code shown.
4 Hours
Before Automation
13 Minutes
After VBA Automation
87 Hours
Saved per month
Company Profile: It is the world's largest custodian bank and asset servicing company, headquartered in New York City.
Need for Automation:
The operation team invests a huge amount of time manually every month (around 240 minutes approx.) in generating the trip sheets for both Pickup and Drops. It also factors in the human errors. Hence, looking for a solution, which could really save the man-hour and help us optimize the vehicle allocation to occupancy ratio.
Solution Abstract:
The entire process is divided into three phases; Clubbing, Vendor development and Trip Sheet Generation.
Cost-Benefit Analysis (Post Macro Implementation)
For Pickup :
Frequency (Monthly)
All Business days of the company
Time consumed manually
30 Minutes
Time Consumed for automated activity
3 Minutes
Total time savings per activity
27 Minutes
Total time saved Per month
621 Mins (10 hrs)
Frequency (Monthly)
All Business days of the company
Time consumed manually
120 Minutes
Time Consumed for automated activity
5 Minutes
Total time savings per activity
115 Minutes
Total time saved Per month
2645 Mins (44 hrs)
Frequency (Monthly)
All Business days of the company
Time consumed manually
90 Minutes
Time Consumed for automated activity
5 Minutes
Total time savings per activity
85 Minutes
Total time saved Per month
1955 Mins (32.5 hrs)
For Drop :
Frequency (Monthly)
All Business days of the company
Time consumed manually
30 Minutes
Time Consumed for automated activity
3 Minutes
Total time savings per activity
27 Minutes
Total time saved Per month
594 Mins (10 hrs)
Frequency (Monthly)
All Business days of the company
Time consumed manually
40 Min/Shift 40*13=520 Min
Time Consumed for automated activity
15 * 13= 195 Minutes
Total time savings per activity
325 Minutes
Total time saved Per month
7150 Mins (119 hrs)
Frequency (Monthly)
All Business days of the company
Time consumed manually
90 Minutes
Time Consumed for automated activity
5 Min/shift (5 * 13 = 65)
Total time savings per activity
25 Minutes
Total time saved Per month
550 Mins (32.5 hrs)
Time Consumed Manually
640 Minutes
Time Consumed for automated activity
263 Min
Total Time Savings Per Activity
377 Minutes
Total time saved Per month
8294 Mins (138 hrs)
Take 12-day session, and we will teach you how to Automate your Excel Reports and Processes using VB Programming and, save hours of work for you and the Company. You don’t need to know programming. All you should have is the adequate knowledge of Excel Functions.
Upcoming Schedule:
All our sessions are Classroom, Instructor-Led. If you feel, you need to assess your proficiency with Excel Formulae before reserving the seat, Schedule your pre-assessment with the support team at .
Throughout the course, you will be facilitated with 90 small-scale scenarios, 7case studies, and a Live VBA Project to implement the realtime automation back at work.
