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
3200 Hours
Before Automation
400 Hours
After VBA Automation
2800 Hours
Saved per month
Company Profile: It is a US based company primarily engaged in the Metal Halide research, design & manufacturing operations and is internationally recognized as the innovator in the lighting industry.
Need for Automation:
The tally, enterprise resource planning software, recording user interface is not optimal for mass data entry and these manual inputs of data are prone to too many human errors making it difficult for reconciliation. Hence, the need for an automation to overcome the Tally limitation, avoid clerical error, reduce multiple ledger postings and allow a real-time integration between various ERP’s.
Cost-Benefit Analysis (Post Macro Implementation)
| Activity # | Description | Frequency | Time Consumed - Manually | Time Consumed - After Automation | Time Saved | Time Saved Per Month | Total Savings in Man Days |
|---|---|---|---|---|---|---|---|
| 1 | Payment Entry | 50000 | 3200 Hours | 400 Hours | 112 Hours | 2800 Hours | 350 Days Per Month |
| 2 | Ledger Creation | 750 | 400 Hours | 25 Hours | 15 Hours | 375 Hours | 47 Days Per Month |
| 3 | Validating The Entries | 50750 | 845 Hours | 34 Hours | 845 Hours | 105 Days Per Month |
Cost-Benefit Analysis (Post Macro Implementation)
Description
Payment Entry
Frequency (Monthly)
50000 Times
Time consumed manually
3200 Hours
Time Consumed for automated activity
400 Hours
Total time savings per activity
112 Hours
Total time saved Per month
2800 Hours
Description
Ledger Creation
Frequency (Monthly)
750 Times
Time consumed manually
400 Hours
Time Consumed for automated activity
25 Hours
Total time savings per activity
15 Hours
Total time saved Per month
375 Hours
Description
Validating The Entries
Frequency (Monthly)
50750 Times
Time consumed manually
845 Hours
Time Consumed for automated activity
Total time savings per activity
34 Hours
Total time saved Per month
845 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.
