Excel/VBA for Creative Problem Solving, Part 1
- 4.8
-
![]()
![]()
![]()
![]()
![]()
Approx. 18 hours to complete
Course Summary
Learn how to use Excel VBA to solve creative problems in this course. Gain skills in programming, data analysis, and problem-solving.Key Learning Points
- Learn how to program in VBA and automate repetitive tasks in Excel
- Discover how to use VBA to manipulate and analyze data
- Solve real-world problems using VBA and Excel
Related Topics for further study
Learning Outcomes
- Ability to program in VBA and automate repetitive tasks
- Proficiency in data analysis and manipulation using VBA and Excel
- Solving real-world problems using VBA and Excel
Prerequisites or good to have knowledge before taking this course
- Intermediate knowledge of Excel
- Basic knowledge of programming concepts
Course Difficulty Level
IntermediateCourse Format
- Online Self-paced
- Video Lectures
- Hands-on Projects
Similar Courses
- Excel VBA for Financials
- Excel VBA for Business Analytics
Related Education Paths
Notable People in This Field
- Chandoo
- Excel Campus
Related Books
Description
"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).
Outline
- 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?
- 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
- 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
- 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
Summary of User Reviews
This Excel VBA course has received positive reviews from users for its comprehensive coverage of creative problem-solving techniques. Many users appreciated the practical approach of the course and how it helped them improve their Excel skills.Key Aspect Users Liked About This Course
Users found the practical approach of the course to be very helpful in improving their Excel skills.Pros from User Reviews
- Comprehensive coverage of Excel VBA programming and creative problem-solving techniques
- Practical approach with real-world examples and exercises
- Instructor provides clear explanations and helpful tips throughout the course
Cons from User Reviews
- Some users found the pace of the course to be too slow
- A few users felt that the course could have been more challenging
- Several users experienced technical issues with the course platform
- The course may not be suitable for advanced Excel users who are already familiar with VBA programming
Charlie NuttelmanTop Instructor
4.8 Raiting
Hypnosis: Advanced Hypnosis Seminar 3
- 4.1
-
![]()
![]()
![]()
![]()
![]()
It’s close to REAL mind control! Now you can have your clients think and feel anything you want them to …...
Excel/VBA for Creative Problem Solving, Part 1
- 4.8
-
![]()
![]()
![]()
![]()
![]()
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....
Excel/VBA for Creative Problem Solving, Part 2
- 4.9
-
![]()
![]()
![]()
![]()
![]()
txt files and import information from . Each module will introduce foundational and broad problems inspired by situations that you might encounter in the real world....
Everyday Excel, Part 3 (Projects)
- 5
-
![]()
![]()
![]()
![]()
![]()
"Everyday Excel, Part 3 (Projects)" is a continuation of "Everyday Excel, Parts 1 and 2". Introduction and General Course Information Course Overview and Introduction...
