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
32 Hours
Before Automation
4 Hours
After VBA Automation
28 Hours
Time Saved per month
Company Profile: It is a worldwide management consulting firm – conducting qualitative and quantitative analysis, to evaluate management decisions across the public and private sectors.
Need for Automation:
Collating individual work log file of Employees – from different sources and getting the desired analysis for further decisions, takes approx. 8 man-hours monthly and, is kind of tedious in nature. Thereby, automation of this task shall leave us with more productive working hours.
Cost-Benefit Analysis (Post Macro Implementation)
| Activity # | Activity Description | Frequency | No. Of Times Activity Performed in a Month | Time Consumed Manually (each time) | Time Consumed for Automated Activity (each Time) | Total Time Savings Per Activity (per day) | Total Time Saved Per Month |
|---|---|---|---|---|---|---|---|
| 1 | Importing Data from word | 4 | 4.5 Hrs | 30 Mins | 4 Hrs | 16 Hrs | |
| 2 | Manipulated it with customized input | 4 | 3.5 Hrs | 30 Mins | 3 Hrs | 12 Hrs |
Cost-Benefit Analysis (Post Macro Implementation)
Activity Description
Importing Data from word
No. Of Times Activity Performed in a Month
4
Time Consumed Manually (each time)
4.5 Hours
Time Consumed for Automated Activity (each Time)
30 Minutes
Total Time Savings Per Activity (per day)
4 Hours
Total Time Saved Per Month
16 Hours
Activity Description
Manipulated it with customized input
No. Of Times Activity Performed in a Month
4
Time Consumed Manually (each time)
3.5 Hours
Time Consumed for Automated Activity (each Time)
30 Minutes
Total Time Savings Per Activity (per day)
3 Hours
Total Time Saved Per Month
12 Hours
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.
