Power BI | MS-SQL | ETL with SSIS | VBA | Python
Advanced Excel | MIS Reporting | Power Query
VB Programming | VBA | MS-Office Automation
Power BI | Power Pivot | Power Query | Basic DAX
Advanced Excel | MIS Reporting | Model Building
Course on Business Reporting & Process Automation
Course on Business Process Automation
36-hours Course | 90-Scenarios | Live VBA Project | View Schedule
36-hours Course | 90-Scenarios | Live VBA Project View Schedule
This is a 36-hour program, designed for Advanced Excel users, to automate routine Excel reports or processes using VBA Programming & Excel macros coupled with 90+ small-scale scenarios, 7 case studies and, a Live VBA project (post-training) to get a knack of real-time automation.
It doesn't matter if you have zero knowledge of programming. This section starts with the basics of programming for a layperson - establishing a solid foundation for the development of a full-fledged macro, to the most complex coding concepts.
Is VBA a valuable skill?
Yes – If you are a “BUSINESS USER” (non-programmer).
From a reporting perspective, Excel is hundred times more powerful when you learn VBA.
This section will teach how to plug in all the concepts learned in your first section to build a real-time, full-fledged Excel report automation. It will guide you to automate your routine Excel-related processes and tasks - efficiently and effectively.
15 best practices for VBA coding
Many people don’t understand the power of MS-Office and how all the MS-Office applications can communicate with each other or other systems to streamline workflow within your business. This section will teach you how to interact Excel with other applications.
Key benefits of MS Office Automation
Leverage Excel to capture, import, consolidate, lookup, calculate, analyze, summarize, and visualize data. Then update a variety of documents, including:
This section will guide you through the most sought-after topic - web scraping or extracting data from publicly accessible web data to make smarter decisions. You will learn to connect Excel with browsers like Chrome, IE, etc.
Pros and Cons of Web Scraping
Pros
Cons
RPA and macros have several features in common. But each has its own pros and cons. This section will focus on how to leverage the RPAs functionality of seamlessly integrating with non-office applications to automate more tasks in one workflow.
When to use both?
VBA might be a good fit if,
While RPA might be a better fit if,
We live in an increasingly API-centric world. APIs is everywhere you look. This section will teach you how to communicate or share data between VBA and other web applications such as Google, YouTube, Facebook, Twitter, etc. Using APIs.
When are APIs useful?
APIs are useful when fetching continuously varying data like stock price or currency exchange rate. Getting data from APIs is much faster than screen-scraping. Screen-scraping is also affected by UI changes. APIs with response in XML or JSON format can be called using the xmlhttp feature.
Tips for using APIs
| * |
The topics marked in red are advanced training modules - available at an additional cost.
|
It doesn't matter if you have zero knowledge of programming. This section starts with the basics of programming for a layperson - establishing a solid foundation for the development of a full-fledged macro, to the most complex coding concepts.
Yes – If you are a “BUSINESS USER” (non-programmer).
From a reporting perspective, Excel is hundred times more powerful when you learn VBA.
This section will teach how to plug in all the concepts learned in your first section to build a real-time, full-fledged Excel report automation. It will guide you to automate your routine Excel-related processes and tasks - efficiently and effectively.
Many people don’t understand the power of MS-Office and how all the MS-Office applications can communicate with each other or other systems to streamline workflow within your business. This section will teach you how to interact Excel with other applications.
Leverage Excel to capture, import, consolidate, lookup, calculate, analyze, summarize, and visualize data. Then update a variety of documents, including:
This section will guide you through the most sought-after topic - web scraping or extracting data from publicly accessible web data to make smarter decisions. You will learn to connect Excel with browsers like Chrome, IE, etc.
Pros
Cons
RPA and macros have several features in common. But each has its own pros and cons. This section will focus on how to leverage the RPAs functionality of seamlessly integrating with non-office applications to automate more tasks in one workflow.
VBA might be a good fit if,
While RPA might be a better fit if,
We live in an increasingly API-centric world. APIs is everywhere you look. This section will teach you how to communicate or share data between VBA and other web applications such as Google, YouTube, Facebook, Twitter, etc. Using APIs.
APIs are useful when fetching continuously varying data like stock price or currency exchange rate. Getting data from APIs is much faster than screen-scraping. Screen-scraping is also affected by UI changes. APIs with response in XML or JSON format can be called using the xmlhttp feature.
Tips for using APIs
| * |
The topics marked in red are advanced training modules - available at an additional cost.
|
LEARN from Microsoft Certified Trainers
EXPLORE 90+ Small Scale VBA Scenarios
PRACTICE with 7 VBA Case Studies
HANDS-ON experience with a Live VBA Project
ON-JOB Support to implement learnings
*
The topics marked in red are advanced training modules - available at an additional cost.
Alternatively, check our comprehensive Full Stack BI Reporting Course that includes all the above-mentioned topics.
We believe firmly in result-oriented Automation training. Hence, the learning at Excelgoodies doesn't stop just with the Classroom sessions. Post the Training; you will be offered an opportunity to take up a live VBA project from your company and implement all the concepts learned in real-time.
You will also be honored with the "Report Automation Specialist" Certificate on saving at least 2 hours of work per day.
 |
Report Automation Specialist using Excel VB Programming Eligibility: On implementing a successful live VBA project View Sample Certificate |
|
Excel VBA Developer Eligibility: On clearing post-training assessments/exams View Sample Certificate |
Mr. Sami, Microsoft Certified Trainer, with his qualifications in Finance, HR & Information Technology brings in 14 years of Industry experience. He has successfully trained 9500+ professionals by now, and the counting is still on.
He has undertaken assignments with the renowned IRS, The World Bank, Tata Chemicals, Buckman Laboratories, Standard Chartered, ING Barings and much more. His nature of going that Extra Mile has got him the startling popularity amongst the Excelgoodies prominent clients.
Eligibility: On implementing a successful live VBA project
Sample Certificate: View here
Eligibility: On clearing post-training assessments/exams
Sample Certificate: View here
Training Schedule
| Session | Date | Time |
|---|
Avail additional 10% Corporate Benefit*
on the total course fee for
5+
participants.
Get you team BI ready, today.
36 hours of Instructor-led training
90+ VBA Scenarios
7 large VBA automation (case studies)
30-Days post-training support (via Email)
Report Automation Specialist Certification
We believe firmly in result-oriented Automation training. Hence, the learning at Excelgoodies doesn't stop just with the Classroom sessions. Post the Training; you will be offered an opportunity to take up a live VBA project from your company and implement all the concepts learned in real-time.
You will also be honored with the "Report Automation Specialist" Certificate on saving at least 2 hours of work per day.
Mr. Sami, Microsoft Certified Trainer, with his qualifications in Finance, HR & Information Technology brings in 14 years of Industry experience. He has successfully trained 9500+ professionals by now, and the counting is still on.
He has undertaken assignments with the renowned IRS, The World Bank, Tata Chemicals, Buckman Laboratories, Standard Chartered, ING Barings and much more. His nature of going that Extra Mile has got him the startling popularity amongst the Excelgoodies prominent clients.
One of the best training classes attended so far. A very professional approach, well designed way of teaching. The trainer made sure that even the most slowest learner understands the concepts well. Their true intentions to make sure that everybody who attends should not complete just for the sake of completion but should understand all the concepts was very evident.
They were encouraging us to attend reclasses we dint understand any topic or wanted to learn one more time. Worthyful of the money and time spent. My special thanks and appreciations to sami sir and sai sir for their incredible teaching. Definitely would happy to recommend to others.
I am impressed with the methodology with excel goodies. It was a great learning experience for me at Excel goodies. A professional training institutions and clear road map given to students to achieve their goals.
Top class training program with step by step guidance. Had gained much knowledge in Excel VBA.! Especially Mr.Sami guided us a lot in best way. It was an very good experience with Sami and Sai. Thanks a lot to both of them. :)
I went through the VBA training here at Excelgoodies. The tutors are extremely knowledgeable and helpful. The training programme flow is well planned and helps us to scale up to doing automation in our work place. I found it very useful and it definitely helps anyone doing Excel consolidation and routine reports.
The tutors give individual focus and ensure that all students in the group have properly understood each topic. They even take the same topic again in case we do not understand. I strongly feel there is value for money for the coaching they give. At the end of the course, I could do live projects in my organisation !! Thanks to Excelgoodies :)
My overall experience at Excel Goodies was very very good - All along I used to browse the web to get a VBA Code for my requirement now and then, but the training / guidance offered at Excel Goodies by Mr.Sami and Mr.Sai has really put me in a position whereby, I can really read through the codes and understand how it works and start constructing my own.
Infact I have been looking for a Guru to teach me the fundamentals on VBA Automation for quite a long period, in order to implement my thought process on automating many of the day to day activities that are carried out at my work place and by my clients. When I was casually discussing my passion with my relative, he immediately recommended Excel Goodies to me for doing this course.
Now I am really thankful to him. I strongly recommend Excel Goodies to those who have a passion to master their Excel skills and to venture into VBA Automation, and I am planning to put my son who is a budding CMA Professional into this course. All the very best to all prospective students and Thanks to Mr.Sami & Mr.Sairam and Excel Goodies for giving me a nice learning experience.
Excelgoodies surprises me on how well they cater their programs so perfectly structured and carried out. Cannot ask for better. The programs very well co-ordinated and tailor-tweaked along the course to ensure the best is delivered. Strongly recommend excelgoodies!
Awesome and Structured well professionalled Centre I have seen so far.. the way they organized each sessions was fantastic. I'm very impressed with the vision you guys having against the training program..
Mr.Sami and Mr.Sai thank you so much for your time and patience with us..I'm lucky that I had completed my course in 2019 and starting 2020 with the pride of learning from Excelgoodies.. Rock On - All the best to the team.
I have taken up the VB course during Jan 2019 in ExcelGoodies(EG) - I will strongly recommend Working Professional/Finance Students to take it up the course here in ExcelGoodies. EG is highly professional in terms of conducting trainings, coaching and guiding people in right direction.
My Special kudos to Sami/Sai sir for the wonderful coaching style/techniques followed throughout the 3 months course. Until i joined the course i felt like VB is coding language which Non-Engineering students cannot understand but Sami sir break the assumption and made it clear that anyone can learn VB if they really aspire to learn it.
Thanks once again !!!! Looking forward to opt many course in future in EG (Ex: Power BI, Advance Excel Techniques etc).
My training experience was good... Both the trainers are very knowledgeable as well as very kind... I am a commerce graduate but they have trained me very well with my small amount of excel knowledge.... Whenever I asked coding related clarifications, they helped me immediately... Thanks to Sai and Sami sir..
Mr. Sami/Sai I believe that you have great mastery and expertise in Excel and VBA automation. You have an art in breaking up complex principles into simple and understandable teaching methods.
Excelgoodies has enhanced my skills and taken me to a all new level. I trust you will support me in completing my project. I would surely refer this institute to my colleagues.
Contact Us
Excelgoodies Software Private Limited
No.56, 1 & 2 Floor, North Boag Road,
T-Nagar, Chennai - 17
Tel: +91 9176633248
You will learn to use the right and hybrid technology for end-to-end advanced power reporting.
Tools: Power BI, Power Pivot, VBA, Excel,
M-Programming, MS-SQL, SSIS, and many more.
Power BI
Micorsoft T-SQL
MS-SQL Integrated Services
Python
Microsoft Excel VBA
MS-Excel
Power Query
