0

ecommerce/course.login

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

VBA for Beginners

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

4.1
(205 ratings) 553 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.

Who should take this training

Prerequisites

  • Microsoft Excel. The course was created using Excel 2013.
  • 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. Introduction to the VBA Course 05:03 mins
2. The Environment
1. Getting Started 06:22 mins
2. The VBA Editor 09:00 mins
3. First Coding Manipulations 07:40 mins
3. VBA as a Language
1. VBA Syntax, Keywords, and Comments 08:07 mins
2. Objects and VBA’s Intellitext 06:05 mins
3. Variables and Method Calling Rules 08:30 mins
4. How to Define and Manage Variables 09:22 mins
5. Constant Variable Types and Variables through Intellitext 03:37 mins
4. Introducing Macros
1. Subroutines 04:50 mins
2. Logical Constructs: The Boolean Type 05:56 mins
3. Logical Constructs: If and Switch Statements 04:59 mins
4. Methods for Communicating to the User 08:43 mins
5. Looping: The For and Do While Loops 06:41 mins
6. Looping: Collections and the For Each Loop 04:32 mins
5. Introducing Functions
1. Functions 04:25 mins
2. Returning Values from Functions 04:43 mins
3. Completing Exercise 5 07:04 mins
4. Determining Limitations 05:04 mins
5. The Worksheet Function Object 09:23 mins
6. Completing Exercise 5 07:51 mins
8. Writing an Array Formula 05:21 mins
7. The Range Object 08:33 mins
6. Key Objects and Error Handling
1. The Application Object 10:01 mins
2. The Workbook and Worksheet Objects 12:01 mins
3. Using Errors to Guide You 12:04 mins
4. The Name and Names Objects 06:25 mins
5. The PivotTable Object 06:59 mins
6. The Chart and ChartObject Objects 09:10 mins
7. The PageSetup Object and Print Ranges 12:05 mins
8. One Approach To Completing Exercise 8 11:54 mins
7. Conclusion
Concluding Remarks 05:07 mins

Request more information

Similar courses

Join our mail list for news