"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 1
Excel/VBA for Creative Problem Solving, Part 1
This course is part of Excel/VBA for Creative Problem Solving Specialization
Instructor: Charlie Nuttelman
158,725 already enrolled
Included with 
Gain insight into a topic and learn the fundamentals.
4.8
(4,218 reviews)
Beginner level
No prior experience required
Flexible schedule
Approx. 19 hours
Learn at your own pace
93%
Most learners liked this course
What you'll learn
Utilize VBA to define and implement custom user-defined functions
Create macros to automate procedures in Excel
Identify the basic programming structures in VBA
Automate Excel’s Goal Seek and Solver tools and use numerical techniques to create “live solutions” to solve targeting and optimization problems
Skills you'll gain
Details to know
Shareable certificate
Add to your LinkedIn profile
Assessments
13 assignments
Taught in English
See how employees at top companies are mastering in-demand skills
Build your subject-matter expertise
This course is part of the Excel/VBA for Creative Problem Solving Specialization
When you enroll in this course, you'll also be enrolled in this Specialization.
- Learn new concepts from industry experts
- Gain a foundational understanding of a subject or tool
- Develop job-relevant skills with hands-on projects
- Earn a shareable career certificate
Earn a career certificate
Add this credential to your LinkedIn profile, resume, or CV
Share it on social media and in your performance review
There are 6 modules in this course
Week 1 will introduce you to visual basic for applications (VBA) and teach you the foundational tools required to create basic procedures in VBA. You'll learn about different data types and the scope of variables, how to troubleshoot your code when it's not working, and how to record basic macros using both absolute and relative referencing modes.
What's included
14 videos14 readings3 assignments3 discussion prompts
In Week 2, you will learn how to write proper VBA syntax and basic mathematical expressions; you will learn about objects, properties, methods, and events; and you will learn how to borrow common Excel functions using VBA code. In addition, you will learn how to move information to and from Excel and the Visual Basic Editor (VBE).
What's included
11 videos2 readings2 assignments2 discussion prompts
In Week 3, you will learn how to create your own user-defined functions. You will also learn how to call other subroutines and functions that reside in other files and you will learn how to design subroutines based on a modular approach. Finally, ,you will learn basic error handling in VBA.
What's included
9 videos3 readings2 assignments2 discussion prompts
Week 4 begins the "meat" of programming in VBA, and we are finally moving into some exciting problem solving. You will learn about the common programming structures in VBA (sequence, selection, and repetition) that form the foundation for advanced programming procedures. Several examples will highlight the utility of these programming structures.
What's included
15 videos2 readings2 assignments2 discussion prompts
One of the most valuable uses of VBA is to manage large data sets in Excel. In this module, you'll learn how to automate the processes of filtering, sorting, and removing duplicates. You'll learn additional strategies for cleaning up data. The strategies learned in this week will make you a valued VBA user.
What's included
10 videos2 readings2 assignments2 discussion prompts
The final module of this course focuses on using the R1C1 style of cell formatting. This style, in contrast to the default A1 style of referencing in Excel, makes it much easier and straightforward to perform advanced manipulations to Excel worksheets. Several examples demonstrate the utility of the R1C1 style.
What's included
8 videos1 reading2 assignments1 discussion prompt
Instructor
Instructor ratings
4.8 (1,270 ratings)Offered by
Recommended if you're interested in Algorithms
University of Colorado Boulder
Microsoft
Why people choose Coursera for their career
Felipe M.
Learner since 2018
"To be able to take courses at my own pace and rhythm has been an amazing experience. I can learn whenever it fits my schedule and mood."
Jennifer J.
Learner since 2020
"I directly applied the concepts and skills I learned from my courses to an exciting new project at work."
Larry W.
Learner since 2021
"When I need courses on topics that my university doesn't offer, Coursera is one of the best places to go."
Chaitanya A.
"Learning isn't just about being better at your job: it's so much more than that. Coursera allows me to learn without limits."
Learner reviews
Showing 3 of 4218
4.8
4,218 reviews
- 5 stars
87.12%
- 4 stars
10.08%
- 3 stars
1.34%
- 2 stars
0.33%
- 1 star
1.11%
New to Algorithms? Start here.
Open new doors with Coursera Plus
Unlimited access to 7,000+ world-class courses, hands-on projects, and job-ready certificate programs - all included in your subscription
Advance your career with an online degree
Earn a degree from world-class universities - 100% online
Join over 3,400 global companies that choose Coursera for Business
Upskill your employees to excel in the digital economy
Frequently asked questions
Access to lectures and assignments depends on your type of enrollment. If you take a course in audit mode, you will be able to see most course materials for free. To access graded assignments and to earn a Certificate, you will need to purchase the Certificate experience, during or after your audit. If you don't see the audit option:
The course may not offer an audit option. You can try a Free Trial instead, or apply for Financial Aid.
The course may offer 'Full Course, No Certificate' instead. This option lets you see all course materials, submit required assessments, and get a final grade. This also means that you will not be able to purchase a Certificate experience.
When you enroll in the course, you get access to all of the courses in the Specialization, and you earn a certificate when you complete the work. Your electronic Certificate will be added to your Accomplishments page - from there, you can print your Certificate or add it to your LinkedIn profile. If you only want to read and view the course content, you can audit the course for free.
If you subscribed, you get a 7-day free trial during which you can cancel at no penalty. After that, we don’t give refunds, but you can cancel your subscription at any time. See our full refund policy.