Excel: Learning VBA.
(Online Course)
Author
Contributors
Published
Carpenteria, CA linkedin.com, 2023.
Format
Online Course
Status
Description
Loading Description...
Also in this Series
Checking series information...
More Details
Language
English
Notes
General Note
10/25/202312:00:00AM
Participants/Performers
Presenter: Curt Frye
Description
Learn to automate routine tasks and customize the functionality of Excel's features with this crash course in VBA.
Description
VBA allows you to automate routine tasks in Excel, and it's easier to learn than you might think. In this course, Excel expert Curt Frye presents a thorough introduction to the Visual Basic for Applications programming language. Learn how to create subroutines and functions to hold code, and gain a solid grounding in the Excel object model. Explore programming techniques through real-world examples and the exercise files that accompany the course. Find out how to work with the Visual Basic Editor, add code to a macro, and create, export, and delete code modules. Go over declaring and using variables, managing variable scope, and defining arrays. Discover ways to use VBA to manage your workbooks and spreadsheets. Learn how to simplify repeating tasks with loops and debug VBA code. Practice cutting, copying, and pasting cell data, as well as running and triggering event procedures. Plus, use practical challenges to apply what you’ve learned.
System Details
Latest version of the following browsers: Chrome, Safari, Firefox, or Internet Explorer. Adobe Flash Player Plugin. JavaScript and cookies must be enabled. A broadband Internet connection.
Citations
APA Citation, 7th Edition (style guide)
Frye, C. (2023). Excel: Learning VBA . linkedin.com.
Chicago / Turabian - Author Date Citation, 17th Edition (style guide)Frye, Curt. 2023. Excel: Learning VBA. linkedin.com.
Chicago / Turabian - Humanities (Notes and Bibliography) Citation, 17th Edition (style guide)Frye, Curt. Excel: Learning VBA linkedin.com, 2023.
MLA Citation, 9th Edition (style guide)Frye, Curt. Excel: Learning VBA linkedin.com, 2023.
Note! Citations contain only title, author, edition, publisher, and year published. Citations should be used as a guideline and should be double checked for accuracy. Citation formats are based on standards as of August 2021.