0

ecommerce/course.login

ecommerce/course.or, ecommerce/course.create_accountCreate an account in checkout page
Excel

VBA Intermediate

Learn Microsoft VBA to automate your time-consuming procedures in Excel.

3.9
(198 ratings) 476 students



Enroll now


What you will learn

How to automate tasks and operations that you perform frequently.
General syntax rules, what keywords are, and how to add comments.
What variables are, and how they relate to functions versus methods and subroutines.
How to specify different variables, including arrays, and how to manage them in code.
How to use intellitext with variables, particularly those that are defined constants.
What functions are, how they are used, and how to stage a scenario to complete.
How functions return values.
How to define inputs for functions.
How to use input boxes and message boxes to interact with the user.
The intricacies surrounding creating an array formula.
How to use the application object to control the user experience.
How to use errors to improve your code.
How to use the name and names object to manage named ranges.
General information about the PivotTable object and basic approaches to utilizing it.
Discover some of the more advanced details about VBA, such as memory management and additional key words.
How to write and implement Excel events, to modify how Excel reacts to different user actions.
Discover how to modify a variety of standard behaviors, such as double clicking, opening files and saving files through VBA.
Learn custom classes, including introducing you to blank custom classes, and finally moves onto how do you use user form classes.
Learn how to design and implement specialized classes of objects.
Discover how to customize the right click menu within cell ranges.
Learn external libraries, and how you can extend VBA's capabilities beyond standard Excel options.
Learn about where VBA falls within the Excel file structure, and how different Excel file types use VBA differently.
How to modify the Excel user interface, including the "Ribbon" and context menus to interact with your VBA code.

Who should take this training

Prerequisites

  • Microsoft Excel for Windows.
  • The course was created using Excel 2013 for Windows. All of the code used in this course except for one property is compatible for Excel 2007, Excel 2010, and Excel 2013.
  • Intermediate knowledge of Microsoft Excel.

Target audience

  • Those wanting to automate Excel task or procedures. Those seeking productivity gains. Users of Excel who want increase their ability.

About this training

In Essential VBA Training for Excel - get up to speed on using VBA to help automate time-consuming procedures in Excel.

Contents and Overview

Through 4 hours of video lectures, exercise files, and an optional quiz, you'll learn the essentials you need to know to create powerful macros using VBA for Excel.

Discover how to define and manage variables, set up subroutines, and create functions.

Learn practical methods for using macro errors to improve your VBA code.

This course includes:

    All of our videos are high definition; therefore, they are best viewed with the HD setting on and the videos enlarged.

Course Language : EN
On-demand video
Full lifetime access to videos
Downloadable resources
Assignments
Certificate of Completion
Enroll now

Training options

Only Videos

$ 30

  • Full lifetime access to videos
  • Downloadable resources
  • Certificate of Completion
  • Hours of Individual Coaching

Blended

$ 290

  • Full lifetime access to videos
  • Downloadable resources
  • Certificate of Completion
  • 10 Hours of Individual Coaching
Save 10%

Blended

$ 520 $ 495

  • Full lifetime access to videos
  • Downloadable resources
  • Certificate of Completion
  • 20 Hours of Individual Coaching
Save 20%

Blended

$ 810 $ 648

  • Full lifetime access to videos
  • Downloadable resources
  • Certificate of Completion
  • 30 Hours of Individual Coaching

Course Content

1. Introduction
1. Course Overview 02:17 mins
2. VBA Language Details
1. Chapter 2 Preview 01:51 mins
2. Excel File Types 07:01 mins
3. Code Modules 06:54 mins
4. Detailed Memory Management 08:15 mins
5. Code Module Interactions 07:43 mins
6. The VBA Project Model 12:02 mins
7. Advanced Parameter Definitions 11:02 mins
3. Excel Events
1. What Are Events? 01:38 mins
2. Pre-Defined Events 06:51 mins
3. Event Parameters 06:44 mins
4. A Series Of Example Events 09:08 mins
5. Application Events 06:42 mins
4. Custom Objects
1. Chapter Overview + New Keyword 06:51 mins
2. Creating A Custom Type 05:41 mins
3. Create a New Class 08:56 mins
4. Defining a Class 08:56 mins
5. Practical Example of a Class 09:51 mins
6. Practice Test of a Class 07:48 mins
7. Special Class Variables and Components 09:07 mins
8. Initialization and Termination 09:02 mins
9. VBA Attributes and Usage 08:27 mins
10. Inheritance – Defining the Bookmarks Support Class 08:07 mins
11. Creating a Userform 10:25 mins
12. Designing a Userform 11:14 mins
13. Coding a Userform 09:50 mins
5. The Excel Interface
1. Modifying the Excel Interface 11:40 mins
2. UI Interface Scope and Range 04:14 mins
3. UI Interface Control Options and Access 09:31 mins
4. UI Callbacks 08:37 mins
5. UI Application 07:12 mins
6. External References and Office Interop
1. What are References? How do they work? 05:43 mins
2. Reference Object 06:25 mins
3. Office Libraries 03:46 mins
4. ADODB Library 06:31 mins
5. The Scripting Library 05:55 mins
7. Conclusion
Course Conclusion 01:46 mins

Request more information

Similar courses

Join our mail list for news