Course Contents

If you think that creating macros is too complicated or beyond your capacity, don't worry, this course is intended for those of us who are just starting out in programming, so it starts from zero.
People will learn about the VBA Language, Explore the features, Acquaintance with the Object Library and Many more.
We will help participants to implement the gained knowledge from training and automate the project to save TAT and FTE.

Phase 1: Knowledge Transfer: Microsoft Excel VBA and Macro [16 Hrs]
- Write VBA Code to automate the things you do in Excel and work 10X Faster
- The TAT saving Tips and Tricks will enhance the efficiency or productivity of the participants.
- People will have better control over the data by using our Data Harness Techniques.
- The Best Industrial Practices will help people to design the reports with international standards.
- Use VBA Code to do things in Excel that otherwise wouldn't be possible
- Common Troubleshoot Techniques can save a lot of time at the workplace.
- Save precious time at work by automating repetitive Excel tasks
- Consolidate Multiple Sheets and Multiple Files with VBA Robust Code.
- Creating Add-Ins and making all the impossible tasks Possible.
- People can add value to their data with our unique Data Visualization Styles.
Two weeks of Lead time for Hands on Practice and understanding the whole concept of VBA
Once the Training is over, client has to share the BRD (Business Requirement Document) in detail with all the necessary output formats and sample data. A dedicated personnel or POC has to be assigned by the client to clarify our queries and assist in sharing the information, if any. We will make all our case studies and working ready with in that 14 days lead time or before commencing with the automation.
Phase 2: End to End Automation: Automation of Project with step by step of VBA Coding in MS Excel [16 hours]
- BRD to be prepared by the Client. ASIS and TO BE has to be clearly defined.
- Facilitator will start explaining the customized Code step by step.
- Debugging and Error Tracing Phase by Phase.
- Recap of concept and other object library and add on to the report.
- Testing of Tool and accomplishing the status of Go Live.
- Question and Answers and Clarification of Queries

N/A

Who Can Attend:
This training would be very useful to participants who are well versed with excel and would like to step in to the world of automation and would like to do the process improvements by learning Excel VBA & Macro. Various industries and functional specializations such as MIS, Finance, Marketing, Operations, Human Relations, Information Technology and Administration folks can attend the program.

Instructor Profile

Amardeep Excel4All

Microsoft Office Specialist, has a wide experience in Hardware as well as Software. He has been conducting corporate trainings for the last 15 years on National & International Level. Has given consistent performance and is adaptable to new technologies.