Excel: Learning VBA
With Curt Frye
Liked by 294 users
Duration: 4h 20m
Skill level: Advanced
Released: 10/25/2023
Course details
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.
Skills you’ll gain
Earn a sharable certificate
Share what you’ve learned, and be a standout professional in your desired industry with a certificate showcasing your knowledge gained from the course.
-
Showcase on your LinkedIn profile under “Licenses and Certificate” section
-
Download or print out as PDF to share with others
-
Share as image online to demonstrate your skill
Meet the instructor
Learner reviews
-
-
Akash Atkar
Akash Atkar
Sr. Quality Analyst | Process Transformation accompanied by high professionalism and strong problem solving capabilities.
-
Contents
What’s included
- Practice while you learn 2 exercise files
- Test your knowledge 7 quizzes
- Learn on the go Access on tablet and phone
- Stay up to date Continuing Education Units
Similar courses
Download courses
Use your iOS or Android LinkedIn Learning app, and watch courses on your mobile device without an internet connection.