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

Quick Facts

Medium Of InstructionsMode Of LearningMode Of Delivery
EnglishSelf StudyVideo and Text Based

Course Overview

The Excel/VBA for Creative Problem Solving, Part 1 course is a comprehensive 6-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. 19 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 AvailabilityCertificate Providing Authority
yesCU BoulderCoursera

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

Particulars

Amount

Course Fee, 1 Month

Rs. 4,115

Course Fee, 3 Month

Rs. 8,230

Course Fee, 6 Month

Rs. 12,345



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


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.

Articles

Back to top