Automation with MS Excel VBA

Current Status
Not Enrolled
Get Started

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


Christian Ibañez, CLSSYB

Student Feedback


Course Rating


53 Reviews on “Automation with MS Excel VBA

  1. 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.

    1. Thanks Gilbert!. That is why standardization should always comes first become automation.

    1. 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.

  2. 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.

    1. Thanks Edmar. Programming is really challenging at first but when you become good at it, the sky is the limit. Please consider exploring VBA.

  3. 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!

    1. I hope this brings value to you in terms of the programming skills necessary for Advanced Excel. Thanks

  4. 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!

  5. 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.

  6. 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.

    1. Thanks Hannah. Advanced Excel skills allow you to solve a lot of problems.

  7. 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.

  8. 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.

  9. 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! 😀

  10. A very informative and interesting topic. Surely will use it in my future journey. Thank you sir Christian and ASK LEX PH ACADEMY.

  11. 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!

  12. 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!

  13. 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 !!!