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
10 Hours
Before Automation
30 Minutes
After VBA Automation
9.5 Hours
Time Saved per month
Company Profile: British multinational banking and financial services company headquartered in London, England. It operates a network of more than 1,200 branches and outlets across more than 70 countries
Need for Automation:
The First week of every month, requires 23 cost Centre reports and more than 20 singular reports to be generated, consuming 10 man-hours per month. Consistently the YTD spending figures should be refreshed and once in three months, the estimate should be changed in the solidified cost focus report – increasing the possibility of duplicate glue and human-prone errors – which in turn requires reconciliation.
Cost-Benefit Analysis (Post Macro Implementation)
| Activity # | Description | Frequency | Time Consumed - Manually | Time Consumed - After Automation | Total Time Savings Per Activity (per day) | Total Time Saved Per month |
|---|---|---|---|---|---|---|
| 1 | Cost Centre Reports | One time in a month | 10 Hours | 30 Minutes | 9 hrs 30 mins | 114 hrs |
Cost-Benefit Analysis (Post Macro Implementation)
Description
Cost Centre Reports
Frequency (Monthly)
One time in a month
Time consumed manually
10 Hours
Time Consumed for automated activity
30 Minutes
Total time savings per activity
9 Hours 30 Minutes
Total time saved Per month
114 Hours
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 gauge your Excel proficiency.
You'll dive into 90 practical scenarios, explore 7 case studies, and complete a Live VBA Project.
