GET MONTHLY INSIGHTS
Be the first to know about new Microsoft Excel courses, upcoming batch schedules, certifications and more.
@
Be the first to know about new Microsoft Excel courses, upcoming batch schedules, certifications and more.
Prove you're human: Type the code shown.
8 Hours
Before Automation
80 Minutes
After VBA Automation
6.67 Hours
Time Saved per month
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.
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:
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.
