Online Course – Certified Professional Specialization in Excel/VBA for Creative Problem Solving from the University of Colorado Boulder

Enhance your Excel sheets with VBA. Learn how to automate your Excel sheets with Visual Basic for Applications.

Suggested by: Coursera (What is Coursera?)

Start your Coursera.com free trial today
קורס אונליין - התמחות מקצועית מוסמכת ב-Excel/VBA לפתרון בעיות באופן יצירתי של University of Colorado Boulder

Professional Certificate

Beginners

No prior knowledge required

Time to complete the course

7-day free trial

No unnecessary risks

Skills you will acquire in the course

  • Improving the use of Excel spreadsheets
  • Automation using Visual Basic for Applications (VBA)
  • Understanding the basics of VBA
  • Carrying out real projects
  • Working with explanatory videos and programming tasks
  • Carrying out light and medium projects
  • Performing a Monte Carlo simulation
  • Real-time currency conversion
  • Geographic tool development
  • Creating the ultimate organizer
  • Regression tool development
  • Grade management

What you will learn in the course

Courses for which the course is suitable

  • Software developer
  • Data Analyst
  • Project Manager
  • VBA programmer
  • Business Analyst
  • Automation expert
  • Excel Solutions Developer
  • Information Systems Manager
  • Technology Consultant
  • Data Manager

Internship – 3-part course series

This specialization is designed for learners who are interested in dramatically transforming their use of Excel spreadsheets by unleashing the power of automation and optimization using Visual Basic for Applications (VBA).

In the first two courses, students will learn the basics of VBA with the help of dozens of explanatory videos and a series of tests and programming tasks within the software. Finally, in part 3 of the course, students will carry out 3 “real” and fairly open-ended projects, which will be evaluated through peer reviews.

Applied Learning Project

Learners will perform:

  • One easy project (to be chosen from two potential projects)
  • One medium-sized project (to be selected from two potential projects)
  • Required Monte Carlo Simulation Project (Medium Difficulty)

The projects include:

  • Real-time currency conversion
  • Geographic tool
  • Ultimate organizer
  • Regression tool
  • Monte Carlo simulation
  • Grade Manager

Details of the courses that make up the specialization

Excel/VBA for creative problem solving

Part 1

Course 1
19 hours
4.8 (4,205 ratings)

What will you learn?

  • Utilize VBA to define and implement custom functions
  • Create scripts (macros) to automate processes in Excel
  • Identify the basic programming constructs in VBA
  • Automate the goal-finding and solution-finding tools in Excel and use numerical techniques to create “living solutions.”

Skills you will acquire:

  • Microsoft Excel Vba
  • Computer Programming
  • Troubleshooting
  • Debugging

Part 2

Course 2
20 hours
4.9 (1,302 ratings)

What will you learn?

  • Use VBA to import/export arrays from/to Excel
  • Describe how to extract text in Excel and how to write data to .txt files and import information from .txt files
  • Automate the import, modification, and consolidation of information from multiple sheets into a central sheet
  • Create professional forms to interact with the user, perform advanced calculations, and manipulate data on the spreadsheet.

Skills you will acquire:

  • Microsoft Excel Vba
  • Computer Programming
  • Troubleshooting
  • Debugging

Part 3 (Projects)

Course 3
16 hours
4.9 (452 ​​ratings)

What will you learn?

  • Create a VBA user form that will implement or solve a real-world scenario or problem.

Related products