OK, I get that programming makes Excel even more powerful. But, why would I want to be able to do that?
A couple of reasons. First, the Benjamins.
Do well in this course, and you'll have skills employers will pay for.
No offense, but I don't see myself in a cubicle, writing code all day.
This course won't turn you into a full-time programmer. What it will do is help you learn skills useful in every aspect of business. Accounting, finance, MIS, operations, HR, marketing, sales... they all use data to make decisions. You'll learn how to write programs to help analyze the data, and improve decision making.
Every programming class I teach, there are students who really get into it.
That happened to me. I was a business student, in the '70s. Yes, I'm old. Anyway, I took an intro statistics course. The instructor, John Duncan, added some programming, on mainframes in those days. I hadn't even seen a computer before. Turned out, I liked programming, and was good at it.
That one course changed my life. From then on, all my education was focused on information systems. I ended up with a bachelors degree, two masters, and a Ph.D. For decades, I've been doing work that doesn't suck, and being paid well for it.