We may earn an affiliate commission when you visit our partners.
Charlie Nuttelman
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.
Register for this course and see more details by visiting:
OpenCourser.com/course/jem3yp/excel
Two deals to help you save
Save money when you learn. Here are two deals and offers that may be relevant to this course.
All coupon codes, vouchers, and discounts are applied automatically unless otherwise noted.
Valid until July 14
Coursera Plus Annual
Work toward what's next for your career with access to 10,000+ programs. Discover emerging skills and save.
Up to
40%
off
Get offer
Valid until August 30
Google AI App Builder
Learn how to use Gemini API and API Studio with a three-course series from Google DeepMind
Take
100%
off
Get offer
What's inside
Syllabus
Getting Started
This first module introduces the course and provides some background material. Paid learners have access to the course files, which are unlocked when you complete the "Unlock Quiz".
Read more
Syllabus
Getting Started
This first module introduces the course and provides some background material. Paid learners have access to the course files, which are unlocked when you complete the "Unlock Quiz".
Read more
Traffic lights
Traffic lights
Read about what's good
what should give you pause and
possible dealbreakers
Explores VBA projects, which is standard in the programming industry
Teaches learners how to complete VBA projects, which could help learners develop their programming skills
Recommends learners take prior courses, which may indicate a steep learning curve
Projects are open-ended, which may help learners develop critical thinking skills
Includes peer review, which may offer learners constructive criticism and help strengthen their projects
Provides an honors designation for learners who complete the Grade Manager project, which may incentivize learners to go above and beyond
Save this course
Create your own learning path.
Save this course to your list so you can find it easily later.
Save
Save
Reviews summary
Project-focused excel vba application
According to learners, this course offers engaging and challenging projects that allow you to apply the VBA skills learned in previous parts. The course is structured around solving problems creatively using Excel and VBA. Students find the projects are practical and provide a good opportunity for hands-on practice. However, the peer review grading system receives mixed feedback, with some finding it inconsistent or unhelpful. The course assumes you have a solid background from Parts 1 and 2, and some learners found the projects, particularly the Honors project, significantly difficult.
Projects, especially Honors, can be difficult.
"The Honors Grade Manager project was significantly more difficult than the others, requiring substantial effort and problem-solving."
"Some of the projects were quite challenging and pushed my VBA skills to their limits."
"While the projects are good, be prepared for a challenge, particularly if you aim for the Honors certificate."
Assumes strong background from Parts 1 and 2.
"Definitely recommend completing Parts 1 and 2 first, as this course heavily relies on those foundations."
"If you haven't taken the first two courses, you will likely struggle with the project requirements."
"Building on skills from previous courses made the projects manageable, but you really need that base."
Projects provide practical application of skills.
"The projects, especially the Monte Carlo simulation, were challenging yet incredibly rewarding. Applying VBA to solve real problems was great."
"I really liked the project-based approach. It forces you to think and apply what you've learned in a practical way."
"Working on the projects helped solidify my understanding of how to use VBA for actual problem-solving. The open-ended nature is a plus."
"I appreciated having specific projects to work on to practice my VBA coding skills."
Effectiveness of peer grading varies.
"The peer grading was sometimes frustrating as feedback quality varied greatly between reviewers."
"While peer review is intended to provide multiple perspectives, I sometimes felt grading was inconsistent or unfair."
"I found the peer review helpful when reviewers provided specific, constructive feedback on my code and approach."
"Reliance solely on peer review for grading means the quality of evaluation can be hit or miss."
Activities
Be better prepared
before
your course. Deepen your understanding
during
and
after
it. Supplement your coursework and achieve mastery of the topics covered
in Excel/VBA for Creative Problem Solving, Part 3 (Projects) with these
activities:
Review VBA syntax
Show steps
Refresh your understanding of basic VBA syntax to strengthen your foundation for the course.
Browse courses on
VBA Syntax
Show steps
-
Review online tutorials or documentation on VBA syntax
-
Go through examples of VBA code and try to understand how they work
Read 'Excel VBA Programming For Dummies'
Show steps
Supplement the course material by reading a comprehensive guide on VBA programming to gain a deeper understanding.
View
Excel 2019 Power Programming with VBA
on Amazon
Show steps
-
Read a chapter or two each week
-
Try out the examples and exercises provided in the book
Create a simple VBA function
Show steps
Solidify your understanding of VBA syntax by creating your own simple function.
Browse courses on
Function
Show steps
-
Identify a task that can be automated using a VBA function
-
Write the VBA code for the function
Two other activities
Expand to see all activities and additional details
Show all five activities
Automate a repetitive task with VBA
Show steps
Enhance your VBA skills by applying them to automate a task in Excel, improving efficiency.
Browse courses on
Automation
Show steps
-
Identify a repetitive task in your workflow
-
Record a macro to automate the task
Follow a tutorial on VBA user forms
Show steps
Expand your VBA knowledge by exploring the creation of interactive user forms.
Browse courses on
User Forms
Show steps
-
Find a tutorial on VBA user forms
-
Follow the tutorial to create your own user form
Review VBA syntax
Show steps
Refresh your understanding of basic VBA syntax to strengthen your foundation for the course.
Browse courses on
VBA Syntax
Show steps
Show steps
Show steps
- Review online tutorials or documentation on VBA syntax
- Go through examples of VBA code and try to understand how they work
Read 'Excel VBA Programming For Dummies'
Show steps
Supplement the course material by reading a comprehensive guide on VBA programming to gain a deeper understanding.
View
Excel 2019 Power Programming with VBA
on Amazon
Show steps
Show steps
Show steps
- Read a chapter or two each week
- Try out the examples and exercises provided in the book
Create a simple VBA function
Show steps
Solidify your understanding of VBA syntax by creating your own simple function.
Browse courses on
Function
Show steps
Show steps
Show steps
- Identify a task that can be automated using a VBA function
- Write the VBA code for the function
Two other activities
Expand to see all activities and additional details
Show all five activities
Automate a repetitive task with VBA
Show steps
Enhance your VBA skills by applying them to automate a task in Excel, improving efficiency.
Browse courses on
Automation
Show steps
Show steps
Show steps
- Identify a repetitive task in your workflow
- Record a macro to automate the task
Follow a tutorial on VBA user forms
Show steps
Expand your VBA knowledge by exploring the creation of interactive user forms.
Browse courses on
User Forms
Show steps
Show steps
Show steps
- Find a tutorial on VBA user forms
- Follow the tutorial to create your own user form
Career center
Learners who complete Excel/VBA for Creative Problem Solving, Part 3 (Projects) will develop knowledge and skills
that may be useful to these careers:
Data Analyst
Data Analyst
Data analysts use their knowledge of data analysis and programming to extract insights from data. This course can help you build a foundation in data analysis and programming, both of which are essential for data analysts. Additionally, the projects in this course will give you experience in solving complex problems, which is an important skill for data analysts.
Statistician
Statistician
Statisticians use their knowledge of mathematics and statistics to collect, analyze, and interpret data. This course can help you build a foundation in data analysis and programming, both of which are essential for statisticians. Additionally, the Monte Carlo simulation project will give you some experience in a technique that is often used in statistics.
Financial Modeler
Financial Modeler
Financial modelers use their knowledge of finance and Excel to build financial models. This course can help you build a foundation in financial modeling and VBA programming, both of which are essential for financial modelers. Additionally, the projects in this course will give you experience in solving complex problems, which is an important skill for financial modelers.
Quantitative Analyst
Quantitative Analyst
Quantitative analysts use mathematical and statistical models to make investment decisions. A background in finance and a strong understanding of Excel and VBA are both required for this role. This course can help you acquire the skills necessary for a career as a quantitative analyst, especially through the Monte Carlo simulation project.
Risk Analyst
Risk Analyst
Risk analysts use their knowledge of mathematics, statistics, and finance to assess and manage risk. This course can help you build a foundation in data analysis and programming, both of which are important for risk analysts. Additionally, the Monte Carlo simulation project will give you some experience in a technique that is often used in risk analysis.
Actuary
Actuary
Actuaries use their knowledge of mathematics, statistics, and finance to assess and manage risk. This course can help you build a foundation in data analysis and programming, both of which are important for actuaries. Additionally, the Monte Carlo simulation project will give you some experience in a technique that is often used in actuarial work.
Data Scientist specializing in Natural Language Processing
Data Scientist specializing in Natural Language Processing
Data scientists specializing in Natural Language Processing (NLP) use their knowledge of NLP and programming to analyze and interpret text data. This course can help you build a foundation in data analysis and programming, both of which are essential for data scientists specializing in NLP. Additionally, the projects in this course will give you experience in solving complex problems, which is an important skill for data scientists specializing in NLP.
Operations Research Analyst
Operations Research Analyst
Operations research analysts use mathematical and analytical techniques to solve problems in a variety of industries. This course can help you build a foundation in data analysis and programming, both of which are important for operations research analysts. Additionally, the Monte Carlo simulation project will give you some experience in a technique that is often used in operations research.
Market Researcher
Market Researcher
Market researchers use their knowledge of research methods and data analysis to understand consumer behavior and make recommendations for businesses. This course can help you build a foundation in data analysis and programming, both of which are essential for market researchers. Additionally, the projects in this course will give you experience in solving complex problems, which is an important skill for market researchers.
Data Scientist
Data Scientist
Data scientists use their knowledge of math, statistics, and computer science to analyze data and extract insights. This course can help you build a foundation in data analysis and programming, both of which are important for a career as a data scientist. Additionally, the Monte Carlo simulation project will give you some experience in a technique that is often used in data science.
Business Analyst
Business Analyst
Business analysts use their knowledge of business and technology to help organizations solve problems and improve efficiency. This course can help you build a foundation in data analysis and programming, both of which are important for business analysts. Additionally, the projects in this course will give you experience in solving complex problems, which is an important skill for business analysts.
Economist
Economist
Economists use their knowledge of economics and data analysis to analyze economic trends and make predictions. This course can help you build a foundation in data analysis and programming, both of which are becoming increasingly important for economists. Additionally, the Monte Carlo simulation project will give you some experience in a technique that is often used in economics.
Management Consultant
Management Consultant
Management consultants use their knowledge of business and technology to help organizations solve problems and improve efficiency. This course can help you build a foundation in data analysis and programming, both of which are important for management consultants. Additionally, the projects in this course will give you experience in solving complex problems, which is an important skill for management consultants.
Software Engineer
Software Engineer
Software engineers typically have a bachelor's degree in computer science or a related field. This course can help you build a foundation in VBA programming, which can be useful for software engineers who work on Excel-based projects. Additionally, the projects in this course will give you experience in solving complex problems, which is an important skill for software engineers.
Financial Analyst
Financial Analyst
Financial analysts typically need a bachelor's degree in Finance, but some roles may only demand an undergraduate degree in a quantitative field like Applied Mathematics or Statistics. Regardless, this course may be useful for building skills in financial modeling and data analysis, which are important for financial analysts. You will learn how to write VBA code to automate time-consuming tasks, which is a very valuable skill to have in finance.
For more career information including salaries, visit:
OpenCourser.com/course/jem3yp/excel
Reading list
We've selected seven books
that we think will supplement your
learning. Use these to
develop background knowledge, enrich your coursework, and gain a
deeper understanding of the topics covered in
Excel/VBA for Creative Problem Solving, Part 3 (Projects).
Provides a practical guide to the basics of VBA, with step-by-step instructions and real-world examples.
Provides a comprehensive overview of VBA for Excel 2019, and it valuable resource for learners who want to develop their VBA skills. It covers a wide range of topics, from the basics of VBA to more advanced concepts such as object-oriented programming and data access.
A comprehensive reference guide to VBA programming, covering advanced techniques and best practices.
An accessible introduction to VBA for beginners, with a focus on automating tasks.
A textbook that provides a structured approach to learning VBA for Excel.
A practical guide to creating and using macros in Excel.
A comprehensive reference guide to VBA programming, covering all aspects of the language.
For more information about how these books relate to this course, visit:
OpenCourser.com/course/jem3yp/excel
Share
Similar courses
Similar courses are unavailable at this time. Please try again later.
Effort
3-4 weeks of study, 3-5 hours/week
Level
Advanced
Via
Coursera
Institution
University of Colorado Boulder
Instructor
Charlie Nuttelman
Language
English
Transcripts
Español
Français
Português
Deutsch
Italiano
中文
العربية
한국어
日本語
हिंदी
Nederlands
Svenska
Pусский
Türkçe
Polski
Ελληνικά
українська мова
magyar nyelv
Bahasa Indonesia
ไทย
қазақша
اُردُو,
فارسی
বাংলা
tiếng Việt
پښتو
آذربایجان دیلی
This course belongs to a
collection
called
Excel/VBA for Creative Problem Solving. It's comprised of three courses:
- Excel/VBA for Creative Problem Solving, Part 3 (Projects) (viewing)
- Excel/VBA for Creative Problem Solving, Part 2
- Excel/VBA for Creative Problem Solving, Part 1
Our mission
OpenCourser helps millions of learners each year. People visit us to learn workspace skills, ace their exams, and nurture their curiosity.
Our extensive catalog contains over 50,000 courses and twice as many books. Browse by search, by topic, or even by career interests. We'll match you to the right resources quickly.
Find this site helpful? Tell a friend about us.
Affiliate disclosure
We're supported by our community of learners. When you purchase or subscribe to courses and programs or purchase books, we may earn a commission from our partners.
Your purchases help us maintain our catalog and keep our servers humming without ads.
Thank you for supporting OpenCourser.
© 2016 - 2025 OpenCourser