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.
50 Hours
Before Automation
11.67 Hours
After VBA Automation
38.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 in to MIS team for Service Mobiles. One of my tasks is to generate report for service handsets (thrice in a week) – total quantity of products available in each outlet, total quantity available with supplies, Total stock available at warehouse for each product, period-wise quantity analysis, supplier-wise pendency, legal reports etc., received across 350+ branches.
This report is to understand the status on the defective handsets and resolved customer grievances. As the whole process is tedious and consumes more time, thus a need for automation to reduce the workload.
Cost-Benefit Analysis (Post Macro Implementation)
Description
Stock Report Generation
Frequency
20 Days
Time consumed manually
30 Minutes
Time Consumed for automated activity
5 Minutes
Total time savings per activity
25 Minutes
Total time saved Per month
500 Minutes
Description
SDC Report Generation
Frequency
20 Days
Time consumed manually
30 Minutes
Time Consumed for automated activity
5 Minutes
Total time savings per activity
25 Minutes
Total time saved Per month
500 Minutes
Description
Branch Report Generation
Frequency
20 Days
Time consumed manually
30 Minutes
Time Consumed for automated activity
5 Minutes
Total time savings per activity
25 Minutes
Total time saved Per month
500 Minutes
Description
Brand Report Generation
Frequency
20 Days
Time consumed manually
30 Minutes
Time Consumed for automated activity
10 Minutes
Total time savings per activity
20 Minutes
Total time saved Per month
400 Minutes
Description
Legal Report Generation
Frequency
20 Days
Time consumed manually
30 Minutes
Time Consumed for automated activity
10 Minutes
Total time savings per activity
20 Minutes
Total time saved Per month
400 Minutes
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.
