Microsoft Excel VbaComputer ProgrammingProblem SolvingArraysDebugging
Excel/VBA for Creative Problem Solving Specialization
Optimize Your Excel Spreadsheets With VBA. Learn how to automate your Excel spreadsheets with Visual Basic for Applications
12,590 already enrolled!
Offered By
Skills you will gain
About this Specialization
26,966 recent views
This Specialization is for learners wishing to dramatically change the way that they use Excel spreadsheets by unleashing the power to automate and optimize spreadsheets using Visual Basic for Applications (VBA). The first two courses will teach learners the basics of VBA through the use of dozens of educational screencasts and a series of quizzes and in-application programming assignments. Finally, in Part 3 of the course, learners will complete 3 "real world" and somewhat open ended projects, which are graded through peer review.
Applied Learning Project
Learners will complete one easy project (chosen from two potential projects), one intermediate project (chosen from two potential projects), and a third, required Monte Carlo simulation project (intermediate in difficulty). Projects include: Real-Time Currency Converter, Geography Toolbox, Ultimate Organizer, Regression Toolbox, Monte Carlo Simulation, and Grade Manager.
Shareable Certificate
Earn a Certificate upon completion
100% online courses
Start instantly and learn at your own schedule.
Flexible Schedule
Set and maintain flexible deadlines.
Beginner Level
No prior experience required.
Approx. 3 months to complete
Suggested 11 hours/week
English
Subtitles: English
How the Specialization Works
Take Courses
A Coursera Specialization is a series of courses that helps you master a skill. To begin, enroll in the Specialization directly, or review its courses and choose the one you'd like to start with. When you subscribe to a course that is part of a Specialization, you’re automatically subscribed to the full Specialization. It’s okay to complete just one course — you can pause your learning or end your subscription at any time. Visit your learner dashboard to track your course enrollments and your progress.
Hands-on Project
Every Specialization includes a hands-on project. You'll need to successfully finish the project(s) to complete the Specialization and earn your certificate. If the Specialization includes a separate course for the hands-on project, you'll need to finish each of the other courses before you can start it.
Earn a Certificate
When you finish every course and complete the hands-on project, you'll earn a Certificate that you can share with prospective employers and your professional network.
There are 3 Courses in this Specialization
Excel/VBA for Creative Problem Solving, Part 1
1,458 ratings
"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).
Excel/VBA for Creative Problem Solving, Part 2
510 ratings
"Excel/VBA for Creative Problem Solving, Part 2" builds off of knowledge and skills obtained in "Excel/VBA for Creative Problem Solving, Part 1" and 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).
Excel/VBA for Creative Problem Solving, Part 3 (Projects)
159 ratings
In this course, learners will complete several VBA projects. It is highly recommended that learners first take "Excel/VBA for Creative Problem Solving, Part 1" and "Excel/VBA for Creative Problem Solving, Part 2". This course builds off of skills learned in those two courses. This is a project-based course. Therefore, the projects are quite open-ended and there are multiple ways to solve the problems. Through the use of Peer Review, other learners will grade learners' projects based on a grading rubric.
About University of Colorado Boulder
CU-Boulder is a dynamic community of scholars and learners on one of the most spectacular college campuses in the country. As one of 34 U.S. public institutions in the prestigious Association of American Universities (AAU), we have a proud tradition of academic excellence, with five Nobel laureates and more than 50 members of prestigious academic academies.
Reviews
4.9
TOP REVIEWS FROM EXCEL/VBA FOR CREATIVE PROBLEM SOLVING
by JMJan 6, 2020
Excellent course and excellent specialization. Charlie, thank you so much, you are a great professor and a nice person.
by MSJan 26, 2018
Great course! I like it goes straight to implementation and is practice-oriented. What could be improved maybe is sound quality of lectures. And maybe it would be great to have some VBA notes in pdf.
by IFSep 20, 2018
the course was very informative and helpful.\n\nHowever, it would be easier to concentrate on VBA if people who don't use mathematical formulas that much would not have to deal with maths that much.
by JHApr 2, 2020
Very good course with clear examples throughout to help you develop. The online format of the course is great as it allows you to pause and work through the activities presented at your own speed.
by LRJul 4, 2018
I'm not one to write reviews - this course is fantastic and a game changer. Prof Nuttelman is a very engaging speaker and makes what could seem a very dry topic come across as interesting, fascin
by MCFeb 25, 2019
Part 1 was great, but in part 2 i feel like i can now actually provide innovative solutions using VBA. It's a very well taught course that keeps you engaged through great quizzes and assignments.
by CKAug 1, 2018
Relatively easy, I cleared 3 weeks within 2 hours, and completed the whole module in less than 3 days. I did not spend more than 5 hours each of the 3 days. The honors exercise was interesting.
by ZBNov 14, 2019
Very good courses set up and I learned basic knowledge about VBA. The deduction of 1 star is because I wish I can get the PPT available to download :) Still highly recommended for this course!
Frequently Asked Questions
What is the refund policy?
Can I just enroll in a single course?
Yes! To get started, click the course card that interests you and enroll. You can enroll and complete the course to earn a shareable certificate, or you can audit it to view the course materials for free. When you subscribe to a course that is part of a Specialization, you’re automatically subscribed to the full Specialization. Visit your learner dashboard to track your progress.
Is financial aid available?
Can I take the course for free?
Is this course really 100% online? Do I need to attend any classes in person?
This course is completely online, so there’s no need to show up to a classroom in person. You can access your lectures, readings and assignments anytime and anywhere via the web or your mobile device.
How long does it take to complete the Specialization?
Part 1 takes 5 weeks, Part 2 takes 4 weeks, and Part 3 takes 3-4 weeks. However, many learners who can devote more time to the coursework have completed the courses at an accelerated pace.
What background knowledge is necessary?
The course is designed for those without a programming background. It will greatly help if you have a knowledge of basic algebra and at least a foundational/introductory knowledge of Microsoft Excel.
Do I need to take the courses in a specific order?
Yes, it is strongly recommended that learners take the three courses in sequential order.
Will I earn university credit for completing the Specialization?
At this time the University of Colorado Boulder does not offer a for-credit version of the Excel/VBA for Creative Problem Solving Specialization.
What will I be able to do upon completing the Specialization?
After completing this Specialization, you will be competent and confident in using VBA to manipulate data in Excel spreadsheets, implement user forms to professionally interact with users, and have a strong foundation in programming skills.
More questions? Visit the Learner Help Center.
