GET MONTHLY INSIGHTS
Be the first to know about new Microsoft Excel courses, upcoming batch schedules, certifications and more.
@
Be the first to know about new Microsoft Excel courses, upcoming batch schedules, certifications and more.
Prove you're human: Type the code shown.
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.
Take 12-day session, and we will teach you how to Automate your Excel Reports and Processes using VB Programming and, save hours of work for you and the Company. You don’t need to know programming. All you should have is the adequate knowledge of Excel Functions.
Upcoming Schedule:
All our sessions are Classroom, Instructor-Led. If you feel, you need to assess your proficiency with Excel Formulae before reserving the seat, Schedule your pre-assessment with the support team at .
Throughout the course, you will be facilitated with 90 small-scale scenarios, 7case studies, and a Live VBA Project to implement the realtime automation back at work.
