• Industry:
• Professional services, Technology services

Company Profile: It is a global management consulting and professional services firm that provides strategy, consulting, digital, technology, and operations services. A Fortune Global 500 company, incorporated in Dublin, Ireland.

• Department:
• Operations

• Tool(s) Used:
• Microsoft Excel VB Programming (Macro)

Need for Automation:

Preparing payment voucher for India entity, is a weekly task for us – every Friday – consuming 18 man-hours, for all our suppliers. We will get the invoices list and booking of the month. Based on the Invoice list, voucher template needs to be populated along with invoices backup sheet – to be prepared in a prescribed format. The bookings file comes with 28 columns whereas the back up sheet needs to be prepared only with 17 columns, which are not in order and also every week on an average 90-100 invoice needs to be bifurcated for 10-15 suppliers. This is completely manual, time-consuming and tedious at times. Since it is a weekly affair, during month close it becomes challenging to manage both month-ends and this task. Automation of this process will enable the team to perform it in no time and month-end activities can be managed in a better way.

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)

• :

Ready to learn Excel VBA Macro?