Excel/VBA for Creative Problem Solving, Part 1
Excel/VBA for Creative Problem Solving,
"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 a Reminder
Rating | 4.8★ based on 381 ratings |
---|---|
Length | 7 weeks |
Effort | 5 weeks of study, 2-4 hours/week |
Starts | Jul 3 (43 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
Similar Courses
What people are saying
recommend this course
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
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
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
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
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
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.
Please login to leave a review
Rating | 4.8★ based on 381 ratings |
---|---|
Length | 7 weeks |
Effort | 5 weeks of study, 2-4 hours/week |
Starts | Jul 3 (43 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