Automation of Vendor / Customer Document Status Retrieval

1 Hour

Before Automation

15 Minutes

After VBA Automation

22.5 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) and MS-Access (database)

Need for Automation:

I am required to collate the workload and the current status of every activity for my team which approx. takes 90 minutes of my daily activity – which then will be forwarded to my team manager for resource allocation. In order, to spend more time on the productive work, and avoid getting frustrated with the monotonous work, I look forward to automate this activity.

Cost-Benefit Analysis (Post Macro Implementation)

Description

Macro for Extracting Vendor/ Customer Documents Status Report

Frequency (Monthly)

30 Times

Time consumed manually

60 Minutes

Time Consumed for automated activity

15 Minutes

Total time savings per activity

45 Minutes

Total time saved Per month

1350 Minutes

Time Savings 22.5 Hours
FTHR Benefit 0.75 FTE

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?