Excel VBA Training Course

Excel VBA Training Course

  • 12-25+ Hours Of Videos
  • Case Studies
  • Downloads
  • Email Coaching
  • 30 Day Guarantee

LEARN MORE

100% RISK FREE
Money Back Guarantee

Excel VBA BootCamp Training Course is the easiest and quickest way to learn Excel VBA and Macros on your own schedule. Let me ask you a few questions:

  • Are you tired of searching Google and YouTube for Excel VBA code that might work?
  • Do you want to feel confident when creating a spreadsheet?
  • Do you feel that there must be a "right way" to use VBA but can't find it?
  • Do you want to learn something interesting and new?
  • Do you want a promotion or a better job?

If you want to learn more about Excel VBA you are in the right place. Excel VBA BootCamp Training Course was designed from the ground up to be the most effective, efficient and complete way to learn Excel VBA available.

Excel VBA Training Course
What Is Included

The Excel VBA Training Course: VBA BootCamp Basic Training Edition gives you a comprehensive foundation in Excel VBA Development. The VBA training course is delivered in modules, each one builds on the skills presented in the prior module. The benefit to you is that your skills increase with each module and you spend less time searching on the internet for just the right tutorial.

Excel VBA Basics

54 Minutes

  • Object Oriented Programming Overview
  • Excel Object Model
  • Workbooks, Worksheets and Range
  • Properties and Methods
  • Print Method of a Workbook
  • Native VBA functions: NOW()
  • Getting Data Into Cells
  • Range.Formula Property

VBA Looping & Logic

3 Hours 6 Minutes

  • VBA Variables
  • VBA Dim Statement
  • VBA Variables: OPTION EXPLICIT
  • VBA Logic Structures: IF… THEN
  • VBA SELECT… CASE Statement
  • VBA FOR NEXT Loops
  • VBA DO Loops
  • Looping Through Data

VBA Objects & Collections

1 Hour 52 Minutes

  • Object Variables In VBA
  • Creating Connections to Objects
  • Using the "Set" Statement
  • What are Collections?
  • FOR EACH LOOPS

VBA Text Strings

3 Hours 16 Minutes

  • What is a VBA String? ASCII Values
  • VBA Special Characters – Quote, Line Feed, Tab
  • How Long Is A String? LEN()
  • VBA Text Functions: LEFT(), RIGHT(), MID()
  • Parsing Flat Files
  • Finding characters In Strings – INSTR()
  • Parsing First & Last Names
  • Parsing Delimited Files

VBA Date Values

2 Hours 16 Minutes

  • VBA Date Data Type
  • Date Functions: YEAR(), MONTH(), DAY()
  • Date to Text – FORMAT()
  • VBA User Defined Functions (UDFs)
  • Using Modules, Subroutines & Functions
  • Public Vs. Private VBA Functions
  • Using Worksheet Functions In VBA Code
  • Using VBA UDFs in Worksheets

Excel Charts & Printing

1 Hour 25 Minutes

  • Chart Object Model
  • Changing Chart Data References
  • Resizing Excel Rows & Columns Using VBA
  • Changing Worksheet Headers & Footers With VBA
  • Formatting Text: Changing Text Fonts & Size
  • Excel Cells: Changing Colors & Borders

VBA File Input/Output

1 Hour 6 Minutes

  • Looping through Directories: DIR() Function
  • Opening a Workbook Using VBA
  • Closing & Saving a Workbook Using VBA
  • Writing A Flat Text File Directly
  • Writing A Delimited Text File Directly
  • Reading A Flat Text File Directly
  • Reading Delimited Text File Directly

VBA Arrays

1 Hour 55 Minutes

  • Excel Formulas: SUMIF, COUNTIF
  • VBA Array Overview
  • Static Versus Dynamic Arrays in VBA
  • Multidimensional Arrays in VBA
  • Looping Through Arrays in VBA
  • Sizes of Arrays: LBOUND(), UBOUND()
  • Option Base

VBA Forms & Controls

2 Hours 4 Minutes

  • User Forms Overview
  • Form Controls: Labels & Text Boxes
  • Form Controls: Option buttons & Check Boxes
  • Form Controls: Drop Downs
  • Form Tab Order
  • Form Events – Creating Interaction

Financial Modeling & VBA

2 Hours 59 Minutes

  • Financial Model Architecture
  • Managing Financial Projections
  • Aggregating Financial Projections
  • Creating Summary Reports
  • Using Multiple Modules
  • Calling Subroutines

Advanced VBA Topics

1 Hour 30 Minutes

  • Variable Scope: Global, Module Level and Routine Level
  • Global Constants
  • User Defined Data Types
  • FileDialog – Getting File Information
  • Using Buttons & Controls On Worksheets

Beyond Excel VBA

2 Hours 26 Minutes

  • Dynamic User Forms
  • Stochastic Monte Carlo Simulation
  • Connecting To Word
  • Connecting To PowerPoint
  • Automating Word Using Excel VBA

Ready To Enroll?
Try The Excel VBA Training Course RISK FREE

I Guarantee Your Success

The methods in this course are spelled out in such painstaking detail – and with such incredible clarity – that anyone can apply them within minutes of going through the course.

But I want to take all the risks away… so I won’t even consider this sale final until you’ve had the course for 30 days.

In fact, if you follow what I teach in the program and fail to accomplish everything I’ve described to you, I insist that you notify me for a complete refund.

Obviously that guarantee is beyond fair.

I’ll repeat the guarantee: All courses come with a 30 day money back guarantee. If you are unhappy with the course I will give you all your money back. No questions asked. All you have to do is send me an email and I’ll refund your money.

You can watch every video, download the ebook, ask me questions and if you are not happy I return all your money. There is no risk to you.