Udemy

Excel Automation: Learn VBA & Macros From Scratch!

立即報名
  • 841 名學生
  • 更新於 4/2025
4.5
(261 個評分)
CTgoodjobs 嚴選優質課程,為職場人士提升競爭力。透過本站連結購買Udemy課程,本站將獲得推廣佣金,有助未來提供更多實用進修課程資訊給讀者。

課程資料

報名日期
全年招生
課程級別
學習模式
修業期
7 小時 4 分鐘
教學語言
英語
授課導師
Kamal Vaswani
評分
4.5
(261 個評分)

課程簡介

Excel Automation: Learn VBA & Macros From Scratch!

Learn to Automate your work in Excel using VBA | NO coding experience required | Simple language for Absolute Beginners

This course is built for Existing Excel users who would like to make their life more simpler and smarter by automating manual/repetitive work in Excel.


FAQs

Q: I've never done coding before and have no background to VBA. Can I still learn it?

A: Yes, This course is mainly targeted to those who are absolutely new to coding/programming. I've trained over 5000 students with no programming background successfully. 

Q: I'm not a great learner, I find difficulty understanding and working with codes/programming. can I learn it?

A: I consider myself as the worst student. So if I can learn it, you can too. 

Q: Why is coding/programming considered so difficult? Can a person with not a great memory learn it?

A: Anything is difficult to remember and understand, if you do not have ample background to it, which answers the "WHYs?" of those concepts. Moreover, I'm myself the person who's not too great at memory, and that makes me ensure that I use simple language, with relatable examples and provide ample background to the concepts in my course. 


Q: I know how to record macros and I'm doing pretty well? What more this course has to offer?

A: Recording is just one part of your learning. there are many more concepts in VBA which a person should know, to get smarter and more efficient at coding. This course doesn't revolve around recording the macros only. It focuses more on how to Write the macros from scratch. The idea is to make sure you are able to understand the codes so well, that it becomes easy for you to make more smarter macros going forward. Refer to the course contents of this course to know the details of what will be covered in this course.


 "If you feel something is complicated or not your cup of tea, its majorly because you tried jumping on the advanced concepts rather than absorbing the basics first"  -  

This course is an effort to provide ample background of each concepts and stresses on the fundamental areas to ensure that you learn it correctly and can re-implement the concepts when required.


After completing this course you will be able to:

  1. Build your own full fledged macros from scratch

  2. Write your macros

  3. Understand your macros

  4. Edit/Modify your macros to improve performance

  5. Create your own User Defined Functions

  6. Auto execute Macros on Several Events.

  7. Re implement the concepts to different problems

  8. Start Loving to code (in case you currently don't)

Looking forward to having more interactions with you in the course.

Happy Learning!

課程章節

  • 1 個章節
  • 52 堂課
  • 第 1 章 Introduction

課程內容

  • Fundamentals of coding, to be able to Understand, Read & Write your own codes
  • Understand the syntax so you can read an existing code and make changes where necessary
  • Combined use of Writing & Recording to build full fledged Automations of your own
  • Save time by Automating repetitive or Routine work


評價

  • R
    Raveesh Kumar Yadav
    4.5

    It matches my expectations as a beginner. The flow and detailing of the course is suitable for person like me who is a beginner. Simple and technically sound.

  • N
    Nithin Jacob Koilpillai
    5.0

    Excellent course, anyone can take it, very clear and easy explanation by the instructor

  • A
    Anil Tumma
    4.5

    Very good

  • M
    Mudassir Abdul Rahim Shaikh
    3.5

    overall course is good but there is lots more that you have not explain like what is dim what is integer and lot more like this which help us to assign variable

立即關注瀏覽更多

本網站使用Cookies來改善您的瀏覽體驗,請確定您同意及接受我們的私隱政策使用條款才繼續瀏覽。

我已閱讀及同意