Excelgoodies
+1 650 491 3131
Excelgoodies +1 650 491 3131
+1 650 491 3131  

COURSES

TRENDING REPORTING COURSES

TAILORED BI REPORTING COURSES

BY INDUSTRY

Aviation

Retail

Healthcare

Banking & Finance

Manufacturing

Telecommunications

Insurance

Hospitality

Transportation

E-commerce

BY FUNCTION

Accounting & Finance

Operations

Customer Service

Human Resources

Marketing

Sales

Supply Chain

Project Management

Excelgoodies
NEW

UPCOMING BATCHES

STUDENT STORIES

INDUSTRY INSIGHTS / BLOG

TECHNOLOGY CONSULTING

Tally Integration using VB Progamming

3200 Hours

Before Automation

400 Hours

After VBA Automation

2800 Hours

Saved per month

  • Industry:
  • Lighting

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.

  • Department:
  •  Finance & Accounts
  • Tool(s) Used:
  • Microsoft Excel VB Programming (Macro)

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
Total 8.75 Hours 1 Minute 8.75 Hours

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:

  • Date:
  • Sunday, July 11
  • Time:
  • 10:00 AM - 12:30 PM (ET)

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?

  • Next: