Save for later

Excel/VBA for Creative Problem Solving, Part 1

This course is a part of Excel/VBA for Creative Problem Solving, a 3-course Specialization series from Coursera.

"Excel/VBA for Creative Problem Solving, Part 1" is aimed at learners who are seeking to augment, expand, optimize, and increase the efficiency of their Excel spreadsheet skills by tapping into the powerful programming, automation, and customization capabilities available with Visual Basic for Applications (VBA). This course is the first part of a three-part series and Specialization that focuses on the application of computing techniques in Excel/VBA to solve problems. In this course (Part 1), you will: 1) create macros to automate procedures in Excel; 2) define your own user-defined functions; 3) create basic subroutines to interface with the user; 4) learn the basic programming structures in VBA; and 5) automate Excel’s Goal Seek and Solver tools and use numerical techniques to create “live solutions” to solve targeting and optimization problems. New to computer programming? The extremely intuitive and visual nature of VBA lends itself nicely to teaching and learning - what a fun way to learn to code! No prior knowledge in programming nor advanced math skills are necessary yet seasoned programmers will pick up new and creative spreadsheet problem solving strategies. After you have learned the basics of VBA, each module will introduce foundational and broad problems inspired by situations that you might encounter in the real world. To pass each module, you'll need to pass a mastery quiz and complete a problem solving assignment. This course is unique in that the weekly assignments are completed in-application (i.e., on your own computer in Excel), providing you with valuable hands-on training.

Get Details and Enroll Now

OpenCourser is an affiliate partner of Coursera.

Get a Reminder

Not ready to enroll yet? We'll send you an email reminder for this course

Send to:

Coursera

&

University of Colorado Boulder

Rating 4.8 based on 381 ratings
Length 6 weeks
Effort 5 weeks of study, 2-4 hours/week
Starts May 11 (3 weeks ago)
Cost $49
From University of Colorado Boulder via Coursera
Instructor Charlie Nuttelman
Download Videos On all desktop and mobile devices
Language English
Subjects Programming Engineering Science
Tags Computer Science Algorithms Physical Science And Engineering Research Methods

Get a Reminder

Get an email reminder about this course

Send to:

Similar Courses

What people are saying

According to other learners, here's what you need to know

recommend this course in 13 reviews

I would highly recommend this course for a fairly wide range of experience levels.

I strongly recommend this course to those who have no VBA experience and want to learn VBA.

I recommend this course to everyone in business life.

Highly recommend this course to anyone seeking to learn how to start using VBA.

Since I am an engineer and enjoy numerical methods I especially like this and would enjoy a course that might be described as “Numerical Recipes in VBA” .I would recommend this course to novices seeking an introduction through to experienced users wanting a deeper understanding and foundation for future work in VBA for Excel.

I would recommend this course for anyone looking for an introduction to VBA.

True learning beyond getting certs, I would strongly recommend this course.

I would highly recommend this course to anybody who is looking for the opportunity to learn VBA and enhance Excel skills.

I really liked this course, it taught me a lot of things I dind´t know and that will be very useful for my professional development.Thank you very much I recommend this course to everyone.

I highly recommend this course.

I would recommend this course to anyone who wants to dig into Excel VBA.

I would highly recommend this course to my friends!

Read more

highly recommended in 13 reviews

Highly recommended!

The deduction of 1 star is because I wish I can get the PPT available to download :) Still highly recommended for this course!

But all things considered, highly recommended.

This course is highly recommended to anyone who wishes to leverage their excel and VBA skills.

Highly recommended to anyone using Excel/VBA on a daily basis.

Highly recommended.

Highly recommended for beginners This course is beyond expectations, and helps refreshing some math methods.

Highly Recommended!

learnt a lot and the quizzes and little questions at the end of the videos are really help ful Highly recommended for everyone who want to start programming, be it for professional reasons or just for the sake of learning.

Read more

easy to follow in 9 reviews

Yet easy to follow.

Course with (i) an excellent organization (starts with the basics and evolves to more advanced topics); (ii) easy to follow videos (concise instructor with practical examples); and (iii) challenging quizzes and assignments, that apply VBA to real world problems.

Well explained and easy to follow.

The instruction by Prof. Nuttelman is extremely fluid and easy to follow, even for the most complex concepts presented in this course.

very clear instruction and easy to follow.covered many topics of VBA, very useful in my daily work.

Videos are easy to follow.

Very easy to follow but I have the content I was looking for to get me started.

Very informative and easy to follow.

Read more

looking forward in 12 reviews

I'm looking forward to Part 2.

I am looking forward to part 2.

Looking forward to the remaining course!

I loved the part 1 of the course, looking forward for the next ones!

Looking forward for Part 2 and Part 3.

Looking forward to seeing this specialization through.

I am looking forward to Prof. Nuttelman’s second Excel/VBA course.

Very much looking forward to the next part!

I'm looking forward to part II.

Looking forward to taking Parts 2 and 3.

Read more

right away in 5 reviews

The best part is I can apply the skills learner here right away!

I could start using right away what i've learned in real life problems.

I'm now equipped to go ahead and apply the concepts learnt from this course right away.

The only minus part is that for a few parts in the course, sometimes the instructor have misread or mistype few information, although it was covered right away with correction marks.

Read more

dr. nuttelman in 5 reviews

Dr. Nuttelman was also very responsive.

I sent it to Dr. Nuttelman and he was able to look over my code and point out the problem.

Even though there is an engineering bias in the course, and I don't have an engineering background, Dr. Nuttelman ensures you'll have enough explanation to follow along and complete assignments.Dr.

The reason that content was not presented is that Dr. Nuttelman simply does not know the answer to that question, as his background is in academia and engineering.

Really appreciate the active engagement from Dr. Nuttelman and other moderators on the forum who gave excellent advice.

Read more

Careers

An overview of related careers and their average salaries in the US. Bars indicate income percentile.

Business Analyst - Incident and Problem Management $54k

Problem Management Manager $68k

Product Problem Analyst $71k

Problem Analyst Consultant $78k

Problem and Incident Management Leader $84k

Incident & Problem Management Business Analyst $84k

Freelance Problem Solver $85k

Problem Management Specialist $86k

Problem Solver Contractor $87k

Technical Analyst / Problem Solver $92k

ITIL Problem Analyst $96k

Principal Problem Solver $175k

Write a review

Your opinion matters. Tell us what you think.

Coursera

&

University of Colorado Boulder

Rating 4.8 based on 381 ratings
Length 6 weeks
Effort 5 weeks of study, 2-4 hours/week
Starts May 11 (3 weeks ago)
Cost $49
From University of Colorado Boulder via Coursera
Instructor Charlie Nuttelman
Download Videos On all desktop and mobile devices
Language English
Subjects Programming Engineering Science
Tags Computer Science Algorithms Physical Science And Engineering Research Methods

Similar Courses

Sorted by relevance

Like this course?

Here's what to do next:

  • Save this course for later
  • Get more details from the course provider
  • Enroll in this course
Enroll Now