TRENDING REPORTING COURSES
Power BI | MS-SQL | ETL with SSIS | VBA | SSAS
Advanced Excel | MIS Reporting | Power Query
VB Programming | VBA | MS-Office Automation
Power BI | Power Pivot | Power Query | Basic DAX
Advanced Excel | MIS Reporting | Model Building
TAILORED BI REPORTING COURSES
BY INDUSTRY
60 Hours
Before Automation
3.67 Hours
After VBA Automation
56.33 Hours
Time Saved per month
Company Profile: It is a private equity holding company, headquartered in New York with operating and portfolio companies located in the United States, India and Brazil.
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 automating this activity.
Microsoft Excel VB Programming (Macro) and MS-Access (database)
| Activity # | Description | Frequency | Time Consumed - Manually | Time Consumed - After Automation | Total Time Savings Per Activity (per day) | Total Time Saved Per month |
|---|---|---|---|---|---|---|
| 1 | The entire team’s data are consolidated into a single file and daily report on the day’s work is generated and sent to the client | 20 Working Days | 1 Hour | 5 Minutes | 55 Mins | 18 hours 20 Minutes |
| 2 | Workload report is generated using the data from the daily report and is updated to a database, and emailed to Manager | 20 Working Days | 1 Hour | 2 Minutes | 58 Mins | 19 hours 20 Minutes |
| 3 | Performance Report based on the input received is generated by connecting to the database and the entire data is exported to table in the excel sheet. From that data, a single report is created for the received input | 20 Working Days | 1 Hour | 4 Minutes | 56 Mins | 18 hours 40 Minutes |
Cost-Benefit Analysis (Post Macro Implementation)
Description
The entire team’s data are consolidated into a single file and daily report on the day’s work is generated and sent to client
Frequency
20 Working Days
Time consumed manually
1 Hour
Time Consumed for automated activity
5 Minutes
Total time savings per activity
55 Minutes
Total time saved Per month
18 Hours 20 Minutes
Description
Workload report is generated using the data from the daily report and is updated to a database, and emailed to Manager
Frequency
20 Working Days
Time consumed manually
1 Hour
Time Consumed for automated activity
2 Minutes
Total time savings per activity
58 Minutes
Total time saved Per month
19 Hours 20 Minutes
Description
Performance Report based on the input received is generated by connecting to the database and the entire data is exported to table in the excel sheet. From that data a single report is created for the received input.
Frequency
20 Working Days
Time consumed manually
1 Hour
Time Consumed for automated activity
4 Minutes
Total time savings per activity
56 Minutes
Total time saved Per month
18 Hours 40 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.
