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 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 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,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
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?
- Cheat Sheet for Week 1
- Assignment 1
- Week 1 files
- Week 2 files
Assignments
- Unlock quiz for Week 1 files
- Week 1 Quiz
- Assignment 1 Submission
Discussion Prompts
- What about you?!
- (OPTIONAL) Week 1 reflection
- Assignment 1 Discussion
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
Assignments
- Week 2 Quiz
- Assignment 2 submission
Discussion Prompts
- Week 2 reflection
- Assignment 2 Discussion
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
Assignments
- Week 3 Quiz
- Assignment 3 submission
Discussion Prompts
- Week 3 reflection
- Assignment 3 Discussion
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
Assignments
- Week 4 Quiz
- Assignment 4 submission
Discussion Prompts
- Week 4 reflection
- Assignment 4 Discussion
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
Assignments
- Week 5 Quiz
- Assignment 5 submission
Discussion Prompts
- Week 5 reflection
- Assignment 5 Discussion
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
Assignments
- Week 6 Quiz
- Assignment 6 submission
Discussion Prompt
- Week 6 reflection
Instructors
CU Boulder Frequently Asked Questions (FAQ's)
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.
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.
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.
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.
Anyone interested in learning creative and new strategies to solve spreadsheet problems will find this course helpful and exciting.