Automation of Work Using Excel - Excel VBA Programming for Non-Majors
This course is designed to teach the basics of programming through VBA (Visual Basic for Applications) and to further improve work efficiency in practical work linked with Excel data.
1. Course Introduction
This course covers the fundamentals of programming through Excel VBA (Visual Basic for Applications), and aims to improve work efficiency in practical situations that involve Excel data. Starting with Excel, this course includes comparisons of code implemented in other languages, such as C and Java, to facilitate a quicker understanding when transitioning to other programming languages. Furthermore, even if you're not familiar with basic computer principles, the course covers fundamental concepts, so if you follow along slowly, you'll gain a comprehensive understanding of programming. By completing the homework assigned by the instructor, writing your own code, and mapping out the process, you'll quickly build a solid foundation. Become a powerhouse of work efficiency with Excel VBA programming!
[Download lecture materials]
Rounds 1-4 >> https://bit.ly/2GRw2vO
Quarterfinals-Quarterfinals >> https://bit.ly/2H5yDj3
2. Course Objectives
- You can understand code, variables, and errors.
- You can understand the programming process.
- You can create an Excel program to automate your work.
- Learn the fundamentals of programming and be able to read and interpret code implemented in VB, C, Java, etc.
- You can implement macro functions and GUI (Graphical User Interface) in Excel.
3. Introduction of the lecture professor
If you live, you can teach the lectures
Professor Kang, who holds a master's degree in computer engineering, has experience as a programming instructor for students entering the department. He also has experience developing mobile apps and MFC-based applications. He is currently engaged in research related to image processing and is preparing to become a renowned programming educator.
4. Course Target
- For those who are interested in programming and want to get started easily.
- For those who want to improve work efficiency through simple programming in data management-related practices.
- Anyone who needs to implement GUI in Excel.
- Anyone
Curriculum
All
43 lectures ∙ (4hr 17min)
Reviews
All
5 reviews
3.8
5 reviews
idemian16048Reviews 1
∙
Average Rating 5.0
- hyelipark0345
Reviews 1
∙
Average Rating 5.0
5
2% enrolledI highly recommend this to beginners of Excel VBA! I am almost new to Excel VBA, but I got the hang of it after listening to this lecture. The instructor explained it thoroughly and in an easy-to-understand manner, so I enjoyed the lecture :) Since this lecture is for beginners, I think it would be good if there were more in-depth follow-up lectures. ㅎㅎ I recommend this lecture to beginners of Excel VBA!!
- etru9150512
Reviews 8
∙
Average Rating 4.8
3
100% enrolledAfter listening to the lecture, I understand what other people's evaluations mean. It seems easy at first, but later on, you run so fast that you can't keep up...... You said that you're targeting non-majors, but I don't know what the point is of showing Java and C language code to non-majors. It's a foreign language anyway... I wish you had focused more on explaining VBA. The grade summary table you make in the middle part is about 300 lines, so it seems too much for a beginner. I wish you had used several easier examples. The class part went by so quickly that I can't even think of looking at it again. I wish the latter part of the lecture was a little more detailed.
- ultlalala20358
Reviews 1
∙
Average Rating 3.0
3
100% enrolledThe lecture was disappointing because it was like cramming information as it went on They slowly made us understand each step, But as it went on, it was disappointing that it just crammed information in, saying, "You can use a lot of information like this without understanding it." In the end, it was inconvenient to have to find each and every code that was shown as an example and find out what it was and how to use it... Since you said it was for non-majors, rather than trying to understand everything through this lecture, If you focus on 'knowing' that you can do ~~ and use ~~ with VBA, I think you will be able to finish it as a satisfactory lecture. It was a regrettable lecture that the pace in the beginning did not last all the way.
- hyin94146992
Reviews 1
∙
Average Rating 3.0
3
100% enrolledAutomation of Work Using Excel - Excel VBA Programming for Non-Majors I think it is an advantage that it is easy to approach for beginners. However, it was a bit disappointing that the PowerPoints that were skipped during the lecture could not be downloaded and that there were not many lectures, so I was not able to experience many things.