We use cookies to give you the best experience when you browse our site. For more information about the cookies we use or to view our privacy policy, click here.
With thousands of short segment IT video lessons at your disposal, Intellezy is the most engaging IT online learning library available. Get started today! With thousands of short segment IT video lessons at your disposal. Get started today!

Excel 365 VBA

Expert
Request a Free Trial

Course Overview

Instructor: Andy Altaner
Subject: Excel 365 VBA
Duration: 05 Hour 12 Minutes
Level: Expert
Pre-requisites: Intermediate Microsoft Excel training or equivalent experience is recommended.
CC Languages: Arabic, Chinese (Simplified) , English, French, German, Hindi, Japanese, Portuguese (Brazil), Russian, Spanish

Description

This course will teach students proper Visual Basic programming techniques along with an understanding of Excel's object structure. Students will learn how to work with variables, how to use various conditional logic statements such as If and Else, and how to work with string functions. Students will also learn how to work with various loops such as next loops and each loops, as well as how to create user forms. Finally, students will get an in-depth understanding of the debugging tools available and how to effectively debug their code.

Introduction
Introduction2min 39sec
Getting Started with VBA Working with Variables Working with Conditional Logic Working with Strings and String Functions Working with Loops Working with Sub Procedures Options and Functions Working with User Forms Debugging your Code Conclusion
Course Recap2min 24sec

Andy Altaner

Andy has been providing technical consulting and training for the past twenty years with extensive experience in application development and database design. In addition to his classroom teaching experience, he has also consulted extensively on spreadsheet and database application development.

Learn More About Andy Altaner