TRENDING REPORTING COURSES
Power BI | MS-SQL | Power Apps | Power Automate
Power BI | MS-SQL | ETL with SSIS | VBA | SSAS
Power BI | Power Pivot | Power Query | Basic DAX
Advanced Excel | MIS Reporting | Model Building
Advanced Excel | MIS Reporting | Power Query
VB Programming | VBA | MS-Office Automation
Formulas | Pivots | Advance Dashboards
TAILORED BI REPORTING COURSES
BY INDUSTRY
72.3 Hours
Before Automation
82 Minutes
After VBA Automation
70.9 Hours
Saved per month
Company Profile: An international financial institution headquartered in Washington, D.C., it provides loans to countries worldwide for capital programs.
Need for Automation:
In our HR department, a crucial monthly responsibility involves delivering a Vacancy Status Report to our business partners. This comprehensive report not only updates partners on current vacancies but also encourages valuable feedback. The current manual effort, where each of our 7 Recruitment team members consolidates data individually from a single source, has prompted our commitment to automation.
Recognizing inherent inefficiencies, we've launched a project to automate report generation using Microsoft Excel VB Programming. This strategic move aims to simplify the process, enabling our team to use time more efficiently and focus on strategic responsibilities. Ultimately, this automation effort is designed to enhance overall productivity and ensure the timely and accurate dissemination of critical recruitment information.
Cost-Benefit Analysis (Post Macro Implementation)
Activity # | Description | Frequency | Time Consumed - Manually | Time Consumed - After Automation | Time Saved | Time Saved Per Month |
---|---|---|---|---|---|---|
1 | Collect files from multiple folder | 6 | 3 Minutes | <1 Minutes | 2 Minutes | 12 Minutes |
2 | Consolidated Data | 6 | 20 Minutes | <1 Minutes | 19 Minutes | 114 Minutes |
3 | Vacancy Status Report | 35 | 120 Minutes | <2 Minutes | 118 Minutes | 4130 Minutes |
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
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:
Proficiency with Excel formulas is a prerequisite. Not sure about your skills? Schedule a pre-assessment at 650-491-3131 to evaluate your Excel proficiency.
Explore 90+ practical scenarios, delve into 7 case studies, and complete a live VBA project.