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.
56.67 Hours
Before Automation
9.33 Hours
After VBA Automation
47.33 Hours
Time Saved per month
Company Profile: It is an Indian multinational information technology and outsourcing company headquartered in Bengaluru and New Jersey.
Need for Automation:
Since most of the reports are shared with the top management – sensitive and critical in nature, requires accuracy and quick around time. The Current process requires 660 man-hours monthly to collate the scattered and varied reports. Automation can omit the human-prone errors and also help us meet the deadline set by clients and the top-management.
Cost-Benefit Analysis (Post Macro Implementation)
Description
Line Managers Escalation report –PS Unit
Frequency
4 Times
Time consumed manually
180 Minutes
Time Consumed for automated activity
15 Minutes
Total time savings per activity
165 Minutes
Total time saved Per month
660 Minutes
Description
Directors report –PS Unit
Frequency
8 Times
Time consumed manually
45 Minutes
Time Consumed for automated activity
10 Minutes
Total time savings per activity
35 Minutes
Total time saved Per month
280 Minutes
Description
To be approved hours report –PS Unit
Frequency
8 Times
Time consumed manually
20 Minutes
Time Consumed for automated activity
5 Minutes
Total time savings per activity
15 Minutes
Total time saved Per month
120 Minutes
Description
Line Manager Escalation Report- ITSPS Unit
Frequency
4 Times
Time consumed manually
180 Minutes
Time Consumed for automated activity
20 Minutes
Total time savings per activity
160 Minutes
Total time saved Per month
640 Minutes
Description
Line Manager Escalation Report – Time Management Unit
Frequency
4 Times
Time consumed manually
360 Minutes
Time Consumed for automated activity
75 Minutes
Total time savings per activity
285 Minutes
Total time saved Per month
1140 Minutes
| Total Manual Time saved per month | 47 hours |
| Total manual time consumed | 56.67 Hours |
| Total time consumed with macro | 9.33 Hours |
| % of manual time saved | 84% |
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.
