TRENDING REPORTING COURSES
Power BI | MS-SQL | ETL with SSIS | VBA | SSAS
Advanced Excel | MIS Reporting | Power Query
VB Programming | VBA | MS-Office Automation
Power BI | Power Pivot | Power Query | Basic DAX
Advanced Excel | MIS Reporting | Model Building
TAILORED BI REPORTING COURSES
BY INDUSTRY
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)
| Activity # | Description | Frequency | Time Consumed - Manually | Time Consumed - After Automation | Total Time Savings Per Activity (per day) | Total Time Saved Per month |
|---|---|---|---|---|---|---|
| 1 | Line Managers Escalation report –PS Unit | 4 | 180 Mins | 15 Mins | 165 Mins | 660 Mins |
| 2 | Directors report –PS Unit | 8 | 45 Mins | 10 Mins | 35 Mins | 280 Mins |
| 3 | To be approved hours report –PS Unit | 8 | 20 Mins | 5 Mins | 15 Mins | 120 Mins |
| 4 | Line Manager Escalation Report- ITSPS Unit | 4 | 180 Mins | 20 Mins | 160 Mins | 640 Mins |
| 5 | Line Manager Escalation Report – Time Management Unit | 4 | 360 Mins | 75 Mins | 285 Mins | 1140 Mins |
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% |
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:
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.
