Course Overview
English, Filipino ā Self-paced (1 hr 13 mins)
About the Course
The major application of automation for a transactional environment or office environment is reported. In VBA, it is a computer programming language developed and owned by Microsoft. You can create macros to automate repetitive work and data processing functions in VBA.
In this course, youāll learn about automation. Youāll also learn why we automate things and thatās because a business wants to produce more and they want to increase their productivity and at the same time, it is efficient.
Course Objective
- To learn about Automation, reason why we need to automate things
- To know the Excel VBA for automation
Course Outline
- Automation
- Reason to automate things
- Automation in a Transactional Environment
- Reports generation
- Excel VBA for Automation
- VBA
- Demo of a Reporting Automation using Excel VBA
- Business Impact
- Conclusion/Summary
Target Participants
All interested individuals who want to learn about Automation with the use of Microsoft Excel VBA.
Certificate Requirements
- Completion of recorded webinar + quiz
- Pass the 10 item multiple choice with 100% mark
- Comment your feedback to the main page of the course
This is a great topic.
Automation is good but the raw data should be also good.
There will be problems if the raw file has an error.
Thanks Gilbert!. That is why standardization should always comes first become automation.
Informative
Thanks Raisa!
i learned something i can apply in my work š thanks!
very interesting because it saves a lot of time doing a report
I agree. Because we all know that reporting is one of the things that we regularly do, no matter what you are level in the organization.
thank you For Learnings
I hope you enjoyed the Course Jairah.
Informative
Thanks Yvon!
Very Informative Discussion. Thank you for sharing your experience and knowledge to everyone. God bless everyone.
Thanks Karen. I hope this inspired you to explore VBA.
A fun and challenging experienced, I gained knowledge about how to tinker with data using MS Excel. I highly advise this course to people who plan a career in Data Science this will helps you widen your gaze about data’s and start jotting notes on what the speaker(MR. Christian IbaƱez) is trying to teach you. It will help you understand what he is trying to do in the Excel. All in all it was a great video, and I would like to thank ASK LEX PH ACADEMY to have this kind of courses being offer here is ASK LEX PH ACADEMY especially I would like to thank Mr. Christian IbaƱez for sharing his tips and knowledge to us.
Thanks Edmar. Programming is really challenging at first but when you become good at it, the sky is the limit. Please consider exploring VBA.
This is very informative, thankyou for sharing learnings and experience in MS excel and VBA
Thank you Christian!
Thank you for a great discussion regarding Automation. honestly I don’t have enough knowledge yet on MS Excel and this course helped me a lot upon fulfilling the knowledges that I need for Data Science. More power ASK LEX PH Academy!
I hope this brings value to you in terms of the programming skills necessary for Advanced Excel. Thanks
Very informative. Thank you for sharing your knowledge in excel and VBA.
Hi! Thank you for the talk, it was very helpful and im sure the tips and skill i learn thru this seminar will be used in my future work in the industry š super thank you and Godbless!
I’ve already earned basic VBA in high school but this time, I leaned the concept of Automation with MS Excel VBA and its raw data that may help me in my future career.
A very informative talk and interesting topic. MS Excel is always a go to when presenting data, and knowing about VBA would save time doing some work.
This is really interesting. Thank you for the learnings sir.
I’m really interesting to know more about Automation with MS excel VBA that will be used in my future career, Thank you.
This seminar is very knowledgeable. Thank you for sharing your knowledge to everyone. This will be a big help for us students now and in the near future.
Thank you for the Learnings. Godbless
It is really an interesting topic. Hope to learn more about Excel and VBA. Thank you!
Watching this webinar got me curious and might try learning Automation using Excel VBA. Thank you so much!
Interesting topic, I hope there will be more of these kind of topics in the future, thank you sir and thank you Ask Lex PH.
I’ve learned a lot that I can apply in my work š thanks!
Thanks Hannah. Advanced Excel skills allow you to solve a lot of problems.
Thank you so much!
Thank you Derlee!
thank you for Learnings.
Nice topic! VBA is a great tool for repetitive report regeneration that requires accuracy even in database using forms and sending automated reports via gmail.
Thanks for sharing your previous projects and some online resources! In our department we used it in a PR/PO Monitoring and in inventory reports.
Thank you very much! I learned a lot.
Nice overview about automation with MS Excel VBA. Thank you for this free webinar and interesting topic. It will be a big help in the future. I’ll definitely apply this to give me a good visualisation in my report because of its accuracy and quality. Thank you so much.
Very interesting and informative topic. Thank you for sharing knowledge and to ASK LEX Ph Academy for the platform.
Thank you, Sir IbaƱez!
nice information about automation and excel
Thank you Ask Lex PH Academy and Sir Christian for this great discussion. You have given me the idea of automation in Microsoft applications and I have a feeling that this would be very useful in the future. I didn’t know that Microsoft applications can also be programmed for a much efficient and better use.
Again, Thank You and God Bless! š
Very informative and interesting. Thank you ASK LEX Ph Academy for sharing new knowledge about Automation with MS Excel VBA.
A very informative and interesting topic. Surely will use it in my future journey. Thank you sir Christian and ASK LEX PH ACADEMY.
This webinar makes me curious about VBA. Thank you Engr Christian for the new learnings.
very informative
good
For people who work with excel for lengthy periods of time or who perform repetitive tasks in excel, learning VBA is well worth the effort. This will also come in handy for data checking. Thank you for this, Sir IbaƱez!
The course gave an informative discussion about automation and its benefits in generating reports. It is definitely effective in having a productive and efficient work with high value. Thank you, Engr. IbaƱez and ALPHA!
It was a very clear and informative presentation. I can definitely use this in the future in different fields. Thank you very much for this free webinar !!!
brief but informative introduction about excel VBA. thanks a lot~
Thank you sir for the short summary of how powerful VBA tool is.
informative and helpful