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
49.5 Hours
Before Automation
9.3 Hours
After VBA Automation
40.2 Hours
Time Saved per month
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
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) |
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:
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.
