Excel VBA BootCamp 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 BootCamp Training Course
Basic Training

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

Excel VBA BootCamp Training Course
Professional Edition

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 Excel VBA BootCamp Training Course RISK FREE

The Best Excel Macro Course

  • 4+ Hours of Video
  • Basic To Advanced
  • VBE Editor Explained
  • Email Coaching
  • Certificate of Completion

$49

CLICK TO ENROLL

100% RISK FREE
Money Back Guarantee

Excel VBA
Basic Training

  • 16+ Hours of Video
  • PDFs For Key Concepts
  • Practice Files
  • Email Coaching
  • Certificate of Completion

$299

CLICK TO ENROLL

100% RISK FREE
Money Back Guarantee

Excel VBA
Professional

  • 29+ Hours of Video
  • PDFs For Key Concepts
  • Practice Files
  • Email Coaching
  • Certificate of Completion

$599

CLICK TO ENROLL

100% RISK FREE
Money Back Guarantee

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.

Excel VBA BootCamp Training Course
Frequently Asked Questions

Which Versions of Excel Does The Course Cover?

The techniques and skills are applicable to all versions of Microsoft Excel from Excel 95 to Excel 2003 to Excel 2010. I teach fundamental skills and techniques that will last you for the rest of your life with all versions of Excel, or any spreadsheet program.

Excel VBA BootCamp Training Course is recorded in Microsoft Excel 2007.

How Long Do I Have To Watch the Videos?

The course is delivered through a subscription to the SpreadSheet SuperStar membership site. During your subscription you may watch the videos as many times as you want until you get all the concepts down cold.

Will The Videos Play On My iPad or iPhone?

Yes. My video hosting company has crazy technology that will make the videos play on an iPad or an iPhone. Noting cooler than watching Database SuperStar videos on your iPad and working on an example at the same time.

Can I Download The Videos?

The videos can only be watched as streaming online videos. The videos can only be watched while connected to the internet and cannot be downloaded to a device for remote viewing.

What Happens When My Subscription Ends?

I am committed to your success and if you need more time to watch the videos after the subscription ends there will be options for you to renew your subscription. Most of my students go on to take other courses and if you do this course will renew automatically.