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
8 Hours
Before Automation
80 Minutes
After VBA Automation
6.67 Hours
Time Saved per month
Company Profile: It is a Danish business conglomerate with activities in the transport and logistics and energy sectors. It has been the largest container ship and supply vessel operator in the world since 1996, headquartered in Copenhagen.
Need for Automation:
I am responsible for sending the corrected Credit Statements to customers on a week on week basis (consuming 108 man-hours effort monthly) for which, the data has to be pulled from SAP, filtered and reconciled with the actuals before emailing it to the respective customers (at times exceeding 100 proposals per day). The activity is really time-consuming and is a high potential for errors, hence an end-to-end automation from pulling out data from SAP to emailing customers shall leave me with enough time to focus on other areas.
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 | Report Automation | 4 Times | 2 Hours | 20 Mins | 1.4 Hours | 6.6 Hours |
Cost-Benefit Analysis (Post Macro Implementation)
Description
Report Automation
Frequency (Monthly)
4 Time
Time consumed manually
2 Hours
Time Consumed for automated activity
20 Minutes
Total time savings per activity
1.4 Hours
Total time saved Per month
6.6 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.
