University of Colorado Boulder
Excel/VBA for Creative Problem Solving, Part 1
University of Colorado Boulder

Excel/VBA for Creative Problem Solving, Part 1

This course is part of Excel/VBA for Creative Problem Solving Specialization

Taught in English

Some content may not be translated

Charlie Nuttelman

Instructor: Charlie Nuttelman

150,104 already enrolled

Included with Coursera Plus

Course

Gain insight into a topic and learn the fundamentals

4.8

(4,125 reviews)

|

94%

Beginner level
No prior experience required
19 hours (approximately)
Flexible schedule
Learn at your own pace

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

Details to know

Shareable certificate

Add to your LinkedIn profile

Assessments

13 quizzes

Course

Gain insight into a topic and learn the fundamentals

4.8

(4,125 reviews)

|

94%

Beginner level
No prior experience required
19 hours (approximately)
Flexible schedule
Learn at your own pace

See how employees at top companies are mastering in-demand skills

Placeholder

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
Placeholder
Placeholder

Earn a career certificate

Add this credential to your LinkedIn profile, resume, or CV

Share it on social media and in your performance review

Placeholder

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 quizzes3 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 quizzes2 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 quizzes2 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 quizzes2 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 quizzes2 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 quizzes1 discussion prompt

Instructor

Instructor ratings
4.8 (1,238 ratings)
Charlie Nuttelman
University of Colorado Boulder
8 Courses397,210 learners

Offered by

Recommended if you're interested in Algorithms

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 4125

4.8

4,125 reviews

  • 5 stars

    87.14%

  • 4 stars

    10.11%

  • 3 stars

    1.30%

  • 2 stars

    0.33%

  • 1 star

    1.08%

CK
4

Reviewed on Aug 1, 2018

IF
4

Reviewed on Sep 20, 2018

AM
5

Reviewed on May 9, 2020

New to Algorithms? Start here.

Placeholder

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