Business Professionals
Techno-Business Professionals
Power BI | Power Query | Advanced DAX | SQL - Query &
Programming
Power BI | Adv. DAX | SQL (Query & Programming) |
VBA | Python | Web Scrapping | API Integration
Power BI | Power Apps | Power Automate |
SQL (Query & Programming)
Power BI | Power Apps | Power Automate |
Microsoft Fabric | SQL | VBA | Python
Power Apps | Power Automate | SQL | VBA | Python |
Web Scraping | RPA | API Integration
Microsoft Power Apps | Microsoft Power Automate
IT Professionals
Power BI | DAX | SQL | ETL with SSIS | SSAS | VBA | Python
Power BI | SQL | Azure Data Lake | Synapse Analytics |
Data Factory | Databricks | Power Apps | Power Automate |
Azure Analysis Services
Power BI | Power Apps | Power Automate | SQL | VBA | Python | API Integration
New
Home | About Us | Contact Us
ExcelGoodies WorldwideUSA | UK | Australia | Singapore | Phillipinnes
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.
Ready to learn Excel VBA Macro?