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.
72.3 Hours
Before Automation
82 Minutes
After VBA Automation
70.9 Hours
Saved per month
Company Profile: It is an international financial institution that provides loans to countries of the world for capital programs, headquartered in Washington, D.C
Need for Automation:
Vacancy Status Report is sent to business partners on a monthly basis to keep them updated on vacancy and also to receive feedback. This involves more manual effort to consolidate and retrieve data from a single source. There are about 7 members in the Recruitment team and each of the recruiters needs to follow the cumbersome process to have this report in place. Hence, we decided to automate the report and make the team to spend their time more efficiently.
Cost-Benefit Analysis (Post Macro Implementation)
Description
Collect files from multiple folder
Frequency (Monthly)
6 Times
Time consumed manually
3 Minutes
Time Consumed for automated activity
<1 Minutes
Total time savings per activity
2 Minutes
Total time saved Per month
12 Minutes
Description
Consolidated Data
Frequency (Monthly)
6 Times
Time consumed manually
20 Minutes
Time Consumed for automated activity
<1 Minutes
Total time savings per activity
19 Minutes
Total time saved Per month
114 Minutes
Description
Vacancy Status Report
Frequency (Monthly)
35 Times
Time consumed manually
120 Minutes
Time Consumed for automated activity
<2 Minutes
Total time savings per activity
118 Minutes
Total time saved Per month
4130 Minutes
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.
