Automation of Work Using Excel - Excel VBA Programming for Non-Majors

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