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
39 Hours
Before Automation
8.67 Hours
After VBA Automation
30.33 Hours
Time Saved Per Month
Company Profile: Headquartered in India, it is a leading multi-brand retail chain that deals in mobile phones and connections, accessories, recharges and Internet data cards.
Need for Automation:
I am responsible for complete Fund Management for the Company – right from adding funds, payments, to generating required reports like supplier-wise payments, department-wise payments etc. On an average, I spend around 90 minutes a day for these activities and sometimes even half-a-day in case of mismatch in the number. Reconciling data becomes really challenging at times and hence, automation of these activities could help me focus on other tasks and also would release me from the stress of reconciliation.
Cost-Benefit Analysis
Activity # | Description | Frequency (Monthly) | Time Consumed - Manually | Time Consumed - After Automation | Total Time Savings Per Activity (per day) | Total Time Saved Per month |
---|---|---|---|---|---|---|
1 | Fund Management | 26 | 90 Minutes | 20 Minutes | 70 Minutes | 1820 Minutes |
Cost-Benefit Analysis (Post Macro Implementation)
Description
Poorvika Fund Management
Frequency
26
Time consumed manually
90 Minutes
Time Consumed for automated activity
20 Minutes
Total time savings per activity
70 Minutes
Total time saved Per month
1820 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.