Open Education designed this free course to introduce students to Visual Basic for Applications (VBA). It is entirely self-paced, with most students finishing with somewhere between 5 and 15 hours of effort. The course covers Excel versions ranging from 2007 to 2019, and it was originally created by Cal Poly Pomona.
Created by: Paul Nissenson
Produced in 2015
What you will learn
- Basics of writing VBA programs from scratch.
- Deep understanding of the logic that runs Excel.
- Certificate-level mastery of VBA from Cal Poly Pomona.
- Course offers a less-frequently-covered approach to utilizing Excel. While many courses briefly touch on VBA, very few are designed exclusively to instruct in this application of Excel.
- Course focuses more on coding than most Excel tutorials and offers a much deeper understanding of how to manipulate Excel to perform tasks.
- Introductory approach to VBA does not require extensive background knowledge to succeed.
- Curriculum was originally designed with older versions of Excel. While updates have been applied, some changes to newer versions slipped through the cracks.
- VBA focus does not include typical Excel instruction. If you're looking for a basic overview of all Excel features, you won't find it here.
Paul Nissenson is an Assistant Professor in the Mechanical Engineering Department at California State Polytechnic University, Pomona. His research interests include computer modeling of atmospheric systems and engineering education.
Students also recommend
15 (15 Reviews)
- Provider: YouTube
- Time: 12h
0 (0 Reviews)
- Provider: Chandoo.org
- Time: 1h 30m
0 (0 Reviews)
- Provider: Amazon