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
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
Easy Projects: Lesson Choices
Intermediate Projects: Lesson Choices
Monte Carlo Simulation
All learners are required to complete the Monte Carlo simulation, which is intermediate in difficulty.
Grade Manager Project (for Honors)
If you are really up for a challenge, complete the Grade Manager project, which is very challenging. Learners who successfully create this project will earn an Honors designation on their Course Certificate.
Good to know
Good to know
Know what's good ,
what to watch for , 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
Save Excel/VBA for Creative Problem Solving, Part 3 (Projects) to your list so you can find it easily later:
Save
Save
Reviews summary
Advanced excel/vba capstone
Learners say this engaging course is an excellent way to apply knowledge learned from earlier courses in the specialization to complete challenging and useful projects. Instructor Charlie Nuttelman is highly praised for his great and patient teaching style and the quality and difficulty of the projects in this course. Students report improving their VBA and Excel skills, as well as gaining confidence in their ability to use these tools to solve real-world problems.
Great Projects
"Great course for those who really want to master VBA and get confidence in programming!"
"projects are really useful."
Excellent Instructor
"I'm not able to express my gratitude to this course and especially to Professor Nuttelman."
"Charlie is a great teacher!"
Practical
"Projects can easily be escalated to real work-life situations."
"I have learnt how to code with VBA from knowing nothing at all at the beginning without programming background."
Unreliable
"It is really hard to be reviewed by other learners looks like is abandoned this part."
Untimely
"The grading takes long sometimes because the peers are less or the exercise done is noticed late."
Challenging
"This course puts you up to the test because, not only do you have to apply what was learned in the previous ones but it is necessary to investigate some things for yourself."
"Part 3 was somewhat a disappointing finish for the terrific P1 and P2 courses."
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
Here are nine courses similar to
Excel/VBA for Creative Problem Solving, Part 3 (Projects).
Excel/VBA for Creative Problem Solving, Part 2
OpenCourser.com/course/9u5bia/excel
Excel/VBA for Creative Problem Solving, Part 2
Most relevant
Excel/VBA for Creative Problem Solving, Part 1
OpenCourser.com/course/dsj8hv/excel
Excel/VBA for Creative Problem Solving, Part 1
Most relevant
Master Microsoft Excel Macros and Excel VBA
OpenCourser.com/course/xbx5em/master
Master Microsoft Excel Macros and Excel VBA
Most relevant
Computational Reasoning with Microsoft Excel
OpenCourser.com/course/2daou4/computational
Computational Reasoning with Microsoft Excel
Most relevant
Everyday Excel, Part 2
OpenCourser.com/course/q6vwzh/everyday
Everyday Excel, Part 2
Most relevant
Unlock Excel VBA and Excel Macros
OpenCourser.com/course/zavzrv/unlock
Unlock Excel VBA and Excel Macros
Most relevant
Microsoft Excel VBA and Macros
OpenCourser.com/course/uxfjmc/microsoft
Microsoft Excel VBA and Macros
Most relevant
Excel with Microsoft Excel VBA User Forms
OpenCourser.com/course/r4o68n/excel
Excel with Microsoft Excel VBA User Forms
Most relevant
Everyday Excel, Part 1
OpenCourser.com/course/kdzy4l/everyday
Everyday Excel, Part 1
Most relevant
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
Good to know
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
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 - 2024 OpenCourser