Interested in this College?
Get updates on Eligibility, Admission, Placements Fees Structure

Quick Facts

Medium Of Instructions	Mode Of Learning	Mode Of Delivery
English	Self Study	Video and Text Based

Course Overview

The Excel/VBA for Creative Problem Solving, Part 1 course is a comprehensive 5-week study designed for learners looking to improve, expand, and optimise their Excel skills. This programme delves deep into the world of Visual Basic for Applications (VBA) and its robust automation, programming, and customisation functionalities.

The Excel/VBA for Creative Problem Solving, Part 1 training programme, is the first course in a three-part specialisation that aims at instilling problem-solving skills by leveraging various computational techniques employed by Excel/VBA. The curriculum includes crucial practice exercises at the end of each week’s module to help you consolidate the knowledge gathered throughout the week.

Moreover, the Online Excel/VBA Creative Problem Solving, Part 1 course by Coursera includes real-life problems that will help you realise the industry problems you might face in your career. Further, to pass each module, you will need to achieve the minimum required marks in the given week’s problem-solving assignment along with the mastery quiz. Upon successful course completion, you also receive a certificate of completion from Coursera and the University of Colorado Boulder. You can share the certificate directly on your LinkedIn profile.

The Highlights

Shareable certificate
Online training
Tangible career benefits
Flexible deadlines
Seven-day free trial
Beginner level
The medium of delivery: English
The University of Colorado Boulder offers
Self-paced training
Approx. 20 hours to complete

Programme Offerings

pre recorded video lectures
seven days free trails
Flexible Deadlines
Free Enrolment
video transcript
online learning
Practice Exercises
Shareable Certificate

Courses and Certificate Fees

Certificate Availability	Certificate Providing Authority
yes	CU BoulderCoursera

Excel/VBA for Creative Problem Solving, Part 1 course fee details:

Particulars	Amount
Course Fee, 1 Month	Rs. 4,085
Course Fee, 3 Month	Rs. 8,171
Course Fee, 6 Month	Rs. 12,256

Eligibility Criteria

Certificate Qualifying Details

To earn a Coursera certificate for the Excel/VBA for creative problem solving, Part 1 online course, you must complete all the modules. You need to receive the minimum required marks in all the assignments and practice quizzes. Upon satisfactory completion of all the elements mentioned above, you will receive a certificate from Coursera, which you can attach to your resume and LinkedIn page. Besides, if you cannot conclude the course within 180 days from the purchase, you need to repay to become eligible for the certification again.

What you will learn

Problem Solving AbilityProgramming skillsKnowledge of Excel

After satisfactory completion of the Online Excel/VBA Creative Problem Solving, Part 1 course, you will have gained skills such as:

Creating macros to automate various Excel procedures
Realising your user-defined functions (UDFs)
Creating macros for automating procedures in Excel
Building rudimentary sub-routines for the user interface (UI)
Having a firm grasp of various VBA programming structures
Automating Excel’s solver and goal seek tools to create the ‘Live solutions’ technique, aimed at solving optimisation problems

Who it is for

AccountantData AnalystComputer ProgrammerFinancial AnalystProject Manager

Admission Details

To enrol for the Excel/VBA for Creative Problem Solving, Part 1 training programme, follow these steps:

Visit the Coursera homepage.
Use the Coursera credentials to log in or your Google or Facebook account
After logging in, search the Coursera course catalogue for the “Excel/VBA for Creative Problem Solving, Part 1” course
Once you land on the course page, look for the “Enroll for free” button and click on it.
You will be redirected to the fee detail section with two different choices. Select an option according to your preference.
Pay the fee using a suitable payment mode.

Application Details

There is no separate application form for Excel/VBA for Creative Problem Solving, Part 1 online course. A simple login using appropriate Coursera/Google/Facebook credentials will suffice. You can avail of a free seven-day trial when you enrol for the certification experience.

The Syllabus

Videos

Welcome!
What can you do with Excel/VBA?
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

Readings

Additional Excel/VBA examples
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
(OPTIONAL) Will Office Scripts replace VBA?
For business and finance folks
Course improvement and my philosophy on learning
If an assignment is not showing up for you
VBA Tutorial
If your computer won't open a macro-enabled workbook
Need to improve your Excel skills?
"Debugging.xlsm" file
Cheat Sheet for Week 1
Assignment 1

Quiz

Unlock quiz for Week 1 files
Week 1 Quiz
Assignment 1 Submission

Videos

Week 2 Preview
VBA syntax and expression entry: Part
VBA syntax and expression entry: Part 2
A warning about exponentiation and ampersands
Introduction to objects, properties, methods, and events
Common objects, properties, and methods
How to borrow functions from Excel
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
Assignment 2 preview and instructions

Readings

Assignment 2
Week 3 files

Quiz

Week 2 Quiz
Assignment 2 submission

Videos

Week 3 Preview
How to make your own user-defined function
How to convert a user-defined function to an Excel Add-In
How to troubleshoot your user defined functions
Why you don't use input and message boxes in functions
How to handle basic user error in your subroutines
An introduction to modular programming
Running a subroutine that resides in another file
Assignment 3 preview and instructions

Readings

Remember to use your DEBUGGING skills!
Assignment 3
Week 4 files

Quiz

Week 3 Quiz
Assignment 3 submission

Videos

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

Readings

"Boulder High and Low Temperatures 2016 - STARTER.xlsm" file
Assignment 4

Quiz

Week 4 Quiz
Assignment 4 submission

Videos

Week 5 Preview
Filtering basics
Filtering for multiple criteria: Part 1
Filtering for multiple criteria: Part 2
Highlighting or deleting rows that satisfy a certain criterion
Sorting basics9mRemoving duplicates
Example: Removing duplicates
Putting it all together: Cleaning data
Assignment 5 preview and instructions

Readings

Week 6 files
Assignment 5

Quiz

Week 5 Quiz
Assignment 5 submission

Videos

Week 6 preview
When macro recording fails
What is R1C1 style?
The Cells property
The Resize property
Example 1: R1C1 style
Example 2: R1C1 style
Assignment 6 preview and instructions

Reading

Assignment 6

Quiz

Week 6 Quiz
Assignment 6 submission

Instructors

CU Boulder Frequently Asked Questions (FAQ's)

1: Any specific system requirements to pursue Excel/VBA Creative Problem Solving, Part 1 online course?

An internet connection and MS-Excel for the practice exercises are required to pursue the course. No other specific system requirements are there for this course. You can access the course materials and lectures from your laptop, PC, or mobile.

2: Are practice tests available for this course?

Yes, the Excel/VBA Creative Problem Solving, Part 1 training course consists of numerous practice tests and exercises at the end of each module. You will be required to score the minimum required marks to pass.

3: What type of information does the certificate have?

The course completion certificate consists of your certified identity, the logo of the partner institution, course name, verification URL, and signature of the course instructor.

4: What if I am not able to meet the deadlines?

The Excel/VBA for Creative Problem Solving, Part 1 training course features flexible deadlines. It implies that you can reset the deadlines depending upon your convenience and schedule.

5: Will I benefit from purchasing the Excel/VBA for Creative Problem Solving, Part 1 certificate programme?

Anyone interested in learning creative and new strategies to solve spreadsheet problems will find this course helpful and exciting.