Explore

Excel/VBA for Creative Problem Solving, Part 3 (Projects)

Approx. 16 hours to complete

Save Course

Go to Course

Course Summary

This course is the third part of a series that teaches how to use Excel VBA for creative problem-solving. It focuses on project-based learning, allowing students to apply what they have learned to real-world problems.

Key Learning Points

Learn how to use VBA to automate complex tasks in Excel
Apply VBA to real-world problems through project-based learning
Improve problem-solving skills and efficiency in Excel

Job Positions & Salaries of people who have taken this course might have

- USA: $64,000
- India: ₹471,000
- Spain: €28,000
- USA: $64,000
- India: ₹471,000
- Spain: €28,000
- USA: $68,000
- India: ₹545,000
- Spain: €30,000
- USA: $64,000
- India: ₹471,000
- Spain: €28,000
- USA: $68,000
- India: ₹545,000
- Spain: €30,000
- USA: $72,000
- India: ₹729,000
- Spain: €36,000

Learning Outcomes

Ability to automate complex tasks in Excel using VBA
Proficiency in project-based learning to apply VBA to real-world problems
Improved problem-solving skills and efficiency in Excel

Prerequisites or good to have knowledge before taking this course

Basic knowledge of Excel
Familiarity with VBA programming

Course Difficulty Level

Intermediate

Course Format

Online
Self-paced

Similar Courses

Excel VBA for Creative Problem Solving, Part 1
Excel VBA for Creative Problem Solving, Part 2

Related Education Paths

Related Books

Description

In this course, learners will complete several VBA projects. It is highly recommended that learners first take "Excel/VBA for Creative Problem Solving, Part 1" and "Excel/VBA for Creative Problem Solving, Part 2". This course builds off of skills learned in those two courses. This is a project-based course. Therefore, the projects are quite open-ended and there are multiple ways to solve the problems. Through the use of Peer Review, other learners will grade learners' projects based on a grading rubric.

Outline

Getting Started
Welcome
How to Switch Sessions of the Course
Is this course for you?
For Mac users
The importance of a Course Certificate and the future of higher education
Course files
Unlock Quiz

Easy Projects: Lesson Choices
Introduction to the currency converter project
How to run a data query
Initializing the combo boxes and today's date
Importing data from the currency website using proper date format
Plotting the last 30 days
Introduction to the Geography Toolbox project
All about the "Geography Toolbox - STARTER.xlsm" file
How to populate the first set of combo boxes
How to populate the second set of combo boxes
How to utilize the combo box selections
How to calculate the distance between two points knowing latitude and longitude
Expectations for input validation and error handling
How to unhide and hide sheets
Currency Converter - Problem Statement
Geography Toolbox - Problem Statement

Intermediate Projects: Lesson Choices
Introduction to the Ultimate Organizer project
A demonstration of the Ultimate Organizer
How to add a category
How to add a new record, Part 1
How to add a new record, Part 2
How to reveal hidden labels and text boxes
How to add an icon to the Quick Access Toolbar to run your user form
Introduction to the Regression Toolbox project
Introduction to the "Regression Toolbox - STARTER.xlsm" file
All about simple linear regression
All about general linear regression
(OPTIONAL): All about multilinear regression
Matrix approach to regression, Part 1
Matrix approach to regression, Part 2
A more complex example of the matrix approach to regression
Using Excel’s matrix functions in VBA code
What is adjusted R-squared?
Calculating adjusted R-squared
Plotting experimental data and model predictions in VBA
Ultimate Organizer - Problem Statement
Regression Toolbox - Problem Statement

Monte Carlo Simulation
Introduction to Monte Carlo simulation
Monte Carlo cookie example
How to output a random variable that follows a certain distribution
The uniform distribution
The discrete distribution
The normal distribution
The triangular distribution
The Beta-PERT distribution
How to apply a VBA user form to a Monte Carlo simulation
An overview of the profitability analysis spreadsheet
Monte Carlo Simulation Problem Statement

Grade Manager Project (for Honors)
Introduction to the Grade Manager Project
Creating a new folder inside a preexisting directory
Importing the Roster.xlsx file to a new sheet
Creating section rosters from main roster file, Part 1
Creating section rosters from main roster file, Part 2
Initializing column headings on section roster files
Syncing files, Part 1
Syncing files, Part 2
How to create a dated backup file
Adding a new grade item to all section sheets, Part 1
Adding a new grade item to all section sheets, Part 2
Adding a new grade item to all section sheets, Part 3
Search and replace tool
Grade Manager - Problem Statement

Summary of User Reviews

Read reviews from students who have taken Excel VBA for Creative Problem Solving Part 3 Projects course on Coursera. This course has received positive reviews overall. Many users appreciated the practical approach of the course.

Key Aspect Users Liked About This Course

Practical approach of the course

Pros from User Reviews

Hands-on experience with real-world projects
Great explanation of complex concepts
Interactive and engaging course materials
Instructors are knowledgeable and helpful
Good pacing of the course

Cons from User Reviews

Some lectures are lengthy
Not suitable for complete beginners
Some exercises are challenging
Occasional technical issues with the platform
Limited opportunities for interaction with other students

Recommended for you

Excel/VBA for Creative Problem Solving, Part 1

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

Save Course

Excel/VBA for Creative Problem Solving, Part 2

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

Save Course