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
50 Hours
Before Automation
11.67 Hours
After VBA Automation
38.33 Hours
Time Saved Per Month
Company Profile: Headquartered in India, it is a leading multi-brand retail chain that deals in mobile phones and connections, accessories, recharges and Internet data cards.
Need for Automation:
I am in to MIS team for Service Mobiles. One of my tasks is to generate report for service handsets (thrice in a week) – total quantity of products available in each outlet, total quantity available with supplies, Total stock available at warehouse for each product, period-wise quantity analysis, supplier-wise pendency, legal reports etc., received across 350+ branches.
This report is to understand the status on the defective handsets and resolved customer grievances. As the whole process is tedious and consumes more time, thus a need for automation to reduce the workload.
Cost-Benefit Analysis
Activity # | Description | Frequency (Monthly) | Time Consumed - Manually | Time Consumed - After Automation | Total Time Savings Per Activity (per day) | Total Time Saved Per month |
---|---|---|---|---|---|---|
1 | Stock Report Generation | 20 Days | 30 Minutes | 5 Minutes | 25 Minutes | 500 Minutes |
2 | SDC Report Generation | 20 Days | 30 Minutes | 5 Minutes | 25 Minutes | 500 Minutes |
3 | Branch Report Generation | 20 Days | 30 Minutes | 5 Minutes | 25 Minutes | 500 Minutes |
4 | Brand Report Generation | 20 Days | 30 Minutes | 10 Minutes | 20 Minutes | 400 Minutes |
5 | Legal Report Generation | 20 Days | 30 Minutes | 10 Minutes | 20 Minutes | 400 Minutes |
Cost-Benefit Analysis (Post Macro Implementation)
Description
Stock Report Generation
Frequency
20 Days
Time consumed manually
30 Minutes
Time Consumed for automated activity
5 Minutes
Total time savings per activity
25 Minutes
Total time saved Per month
500 Minutes
Description
SDC Report Generation
Frequency
20 Days
Time consumed manually
30 Minutes
Time Consumed for automated activity
5 Minutes
Total time savings per activity
25 Minutes
Total time saved Per month
500 Minutes
Description
Branch Report Generation
Frequency
20 Days
Time consumed manually
30 Minutes
Time Consumed for automated activity
5 Minutes
Total time savings per activity
25 Minutes
Total time saved Per month
500 Minutes
Description
Brand Report Generation
Frequency
20 Days
Time consumed manually
30 Minutes
Time Consumed for automated activity
10 Minutes
Total time savings per activity
20 Minutes
Total time saved Per month
400 Minutes
Description
Legal Report Generation
Frequency
20 Days
Time consumed manually
30 Minutes
Time Consumed for automated activity
10 Minutes
Total time savings per activity
20 Minutes
Total time saved Per month
400 Minutes
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?