Automation of Credit Card Statement – Analysis, Generation & Email

2 Hours

Before Automation

20 Minutes

After VBA Automation

7 Hours

Saved per month

  • Industry:
  • Business Process Outsourcing

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.

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

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)

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

Take 12-day session, and we will teach you how to Automate your Excel Reports and Processes using VB Programming and, save hours of work for you and the Company. You don’t need to know programming. All you should have is the adequate knowledge of Excel Functions.

Upcoming Schedule:

  • Date:
  • Time:

All our sessions are Classroom, Instructor-Led. If you feel, you need to assess your proficiency with Excel Formulae before reserving the seat, Schedule your pre-assessment with the support team at .

Throughout the course, you will be facilitated with 90 small-scale scenarios, 7case studies, and a Live VBA Project to implement the realtime automation back at work.

Ready to learn Excel VBA Macro?