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
4.67 Hours
Before Automation
40 Minutes
After VBA Automation
4 Hours
Time Saved per month
Company Profile: A Fortune 500 integrated communications company, with its headquarters in Chicago, provides marketing and business communications, commercial printing, and related services.
Need for Automation:
I am required to assist Sales Representatives with the Stock Status (backorder, available quantity and order quantity) for different warehouse/plants consuming around 2 hours of man-hour weekly. An automation of this task shall leave me with enough productive hours and shall also update the Sales Rep with the accurate information in no time.
Besides, I am also required to combine multiple files with a huge quantity of data as a single file, explaining the post-production details like Customer, Product, Quantity, Price, last ship date for a particular division, region and area etc. – which will later be used by Sales Department for future production for a specific corporate or a product. This activity consumes around an hour weekly. Automating this process would leave me with enough time to address other important areas.
Cost-Benefit Analysis (Post Macro Implementation)
| Activity # | Frequency | Manual Effort | Production Time | ||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | Status Stock Report | 4 week |
|
||||||||
The Manual effort time for this project will acquire 1 hour 10 minutes and its weekly-based report. Annual Production Time for this job is 56 hours.
Now this job has been automated and effort time would be 10 minutes and APT for this job is 8 hours.
This project reduced of effort time on this job.
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.
