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


90 Reviews on “Automation with MS Excel VBA

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

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

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

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

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

    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.

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