Excel/VBA for Creative Problem Solving, Part 1
Completed by Jayoda Chathurangi Dissanayake
December 3, 2020
19 hours (approximately)
Jayoda Chathurangi Dissanayake's account is verified. Coursera certifies their successful completion of Excel/VBA for Creative Problem Solving, Part 1
What you will 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 will gain
- Category: Object Oriented Programming (OOP)
- Category: Automation
- Category: Spreadsheet Software
- Category: Code Reusability
- Category: Problem Solving
- Category: Programming Principles
- Category: Program Development
- Category: Computer Programming
- Category: Data Management
- Category: Data Cleansing
- Category: Excel Macros
- Category: Visual Basic (Programming Language)
