University of Colorado Boulder - Excel/VBA for Creative Problem Solving, Part 1
5.0 /5- Offered byCoursera
Excel/VBA for Creative Problem Solving, Part 1 at Coursera Overview
Duration | 18 hours |
Start from | Start Now |
Total fee | Free |
Mode of learning | Online |
Difficulty level | Beginner |
Official Website | Explore Free Course  |
Credential | Certificate |
Excel/VBA for Creative Problem Solving, Part 1 at Coursera Highlights
- Shareable Certificate Earn a Certificate upon completion
- 100% online Start instantly and learn at your own schedule.
- Course 1 of 3 in the Excel/VBA for Creative Problem Solving Specialization
- Flexible deadlines Reset deadlines in accordance to your schedule.
- Beginner Level
- Approx. 18 hours to complete
- English Subtitles: Arabic, French, Portuguese (European), Italian, Vietnamese, German, Russian, English, Spanish
Excel/VBA for Creative Problem Solving, Part 1 at Coursera Course details
- "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).
- This course is the first part of a three-part series and Specialization that focuses on the application of computing techniques in Excel/VBA to solve problems. In this course (Part 1), you will: 1) create macros to automate procedures in Excel; 2) define your own user-defined functions; 3) create basic subroutines to interface with the user; 4) learn the basic programming structures in VBA; and 5) automate Excel?s Goal Seek and Solver tools and use numerical techniques to create ?live solutions? to solve targeting and optimization problems.
- New to computer programming? The extremely intuitive and visual nature of VBA lends itself nicely to teaching and learning - what a fun way to learn to code! No prior knowledge in programming nor advanced math skills are necessary yet seasoned programmers will pick up new and creative spreadsheet problem solving strategies.
- After you have learned the basics of VBA, each module will introduce foundational and broad problems inspired by situations that you might encounter in the real world. To pass each module, you'll need to pass a mastery quiz and complete a problem solving assignment. This course is unique in that the weekly assignments are completed in-application (i.e., on your own computer in Excel), providing you with valuable hands-on training.
Excel/VBA for Creative Problem Solving, Part 1 at Coursera Curriculum
Macro recording, VBA procedures, and debugging
Welcome!
What can you do with Excel/VBA?
Is this course for you?
How the course works
How to Switch Sessions of the Course
Week 1 preview
Getting your feet wet
Saving your files as macro-enabled workbooks
Recording basic macros
Absolute vs. relative referencing during macro recording
Overview of procedures in VBA
Why use Option Explicit?
Declaration of variables, data types, and scope of variables
How to troubleshoot when your code is not working properly
Assignment 1 preview and instructions
For Mac users
The power of Excel/VBA
The importance of a Course Certificate and the future of higher education
Auditing the course vs. purchasing a Course Certificate
For business and finance folks
Course improvement and my philosophy on learning
If an assignment is not showing up for you
VBA Tutorial
Need to improve your Excel skills?
"Debugging.xlsm" file
Quiz 1 solutions and explanations
Assignment 1
Week 1 Quiz
Assignment 1 Submission
User-Defined VBA Functions
Week 2 preview
How to write basic VBA expressions and use built-in functions
How to make your own user-defined function
Example of a user-defined function
How to convert a user-defined function to an Excel Add-In
Borrowing Excel functions
How to troubleshoot your user defined functions
Why you don't use input and message boxes in functions
An introduction to modular programming
Running a subroutine that resides in another file
Assignment 2 preview and instructions
Quiz 2 solutions and explanations
Assignment 2
Week 2 Quiz
Assignment 2 submission
Exchanging Information Between Excel and VBA
Week 3 preview
Introduction to objects, properties, methods, and events
Common objects, properties, and methods
Examples, Part 1: Basic input and output in subroutines
Examples, Part 2: Basic input and output in subroutines
Examples, Part 3: Basic input and output in subroutines
How to handle basic user error in your subroutines
Assignment 3 preview and instructions
Remember to use your DEBUGGING skills!
Quiz 3 solutions and explanations
Assignment 3
Week 3 Quiz
Assignment 3 submission
Programming structures in VBA
Week 4 preview
How to implement One-Way If...Then selection structures
How to implement Two-Way If...Then selection structures
All about the Multi-Alternative If...Then
Variable iteration loops (Do...Loops)
Validating user input using a Do...Loop
Creating a guessing game using a Do...Loop
All about fixed iteration (For...Next) loops
Putting it all together: Example 1
Putting it all together: Example 2
Using the For Each... Next statement
Worked mini-project: Searching through high and low temperatures in an Excel workbook
(OPTIONAL) Advanced input validation and error handling: Part 1
(OPTIONAL) Advanced input validation and error handling: Part 2
Assignment 4 preview and instructions
"Boulder High and Low Temperatures 2016 - STARTER.xlsm" file
Quiz 4 solutions and explanations
Assignment 4
Week 4 Quiz
Assignment 4 submission
(OPTIONAL) Numerical techniques and live solution strategies
Week 5 preview
How to use the Goal Seek and Solver tools to solve targeting problems
How to solve optimization problems using the Solver tool
Fuel tank example and limitations of the Goal Seek and Solver Tools
Automating the Goal Seek and Solver Tools
Circular Calculations in Excel
Implementing the bisection method in Excel
Implementing a live solution of the bisection method to solve a case study
Using the Golden Section search technique for optimization problems in Excel
Live solution of the Golden Search technique for solving an optimization problem
Solving a case study for friction factor using a circular calculation
Implementing targeting and optimization algorithms in VBA subroutines
Bisection method in a VBA function
Preview of Part 2 of the course
Assignment 5 preview and instructions
Week 5 is optional, but you can earn Honors designation
"Fuel Tank - STARTER.xlsx" file
Course wrap-up and I'd love to see what you are doing with VBA!
Consider rating the course
Quiz 5 solutions and explanations
Assignment 5
Week 5 Quiz
Assignment 5 submission
Excel/VBA for Creative Problem Solving, Part 1 at Coursera Admission Process
Important Dates
Other courses offered by Coursera
Excel/VBA for Creative Problem Solving, Part 1 at Coursera Students Ratings & Reviews
1 Rating- 4-51
Student Forum
Anything you would want to ask experts?