Section 1 : Introduction & Scope
Lecture 1 Course Structure & Content 00:04:06 Duration
Lecture 2 Important Compatibility & Setup Information 00:03:40 Duration
Lecture 3 Course Resources Download Course Project Files 00:01:33 Duration
Lecture 4 Course Expectations 00:02:32 Duration
Lecture 5 Course Outline for Quick Reference

Section 2 : Your First Macro
Lecture 1 Overview Macros & Visual Basic Editor (VBE) 00:01:26 Duration
Lecture 2 Steps to Your First Macro Recording 00:05:45 Duration
Lecture 3 Visual Basic Editor What You Need to Know 00:11:41 Duration
Lecture 4 Project Dynamic Cell Selection (Special Cells) - Perfect for Flexible Macros 00:11:13 Duration
Lecture 5 Project Copy (Consolidate) Data - Absolute versus Relative Macro Recording 00:09:18 Duration
Lecture 6 7 Ways to Run Macros VBA code (incl 00:12:11 Duration
Lecture 7 OFFICE 365 Update Change from Excel Comments to Notes
Lecture 8 Activity Record a Macro that Deletes all Comments
Lecture 9 What's the Difference Between Macros and VBA

Section 3 : The Object Model
Lecture 1 Overview VBA Object Model (What you need to become an expert in VBA) 00:01:22 Duration
Lecture 2 VBA's Code Reference Object Library 00:03:57 Duration
Lecture 3 VB Color Guidelines & Keyboard Shortcuts 00:11:44 Duration
Lecture 4 Excel VBA Object Model 00:06:01 Duration
Lecture 5 Object Properties 00:04:21 Duration
Lecture 6 Object Methods 00:05:39 Duration
Lecture 7 How to Find the Object, Property & Method 00:08:01 Duration
Lecture 8 Conclusion Key Takeaways & Message from Me 00:02:24 Duration

Section 4 : Referencing Ranges, Worksheets & Workbooks with VBA
Lecture 1 Overview Referencing Ranges, Worksheets & Workbooks 00:00:55 Duration
Lecture 2 Referring to Ranges & Writing to Cells in VBA 00:15:22 Duration
Lecture 3 Most Useful Range Properties & Methods 00:13:13 Duration
Lecture 4 4 Methods to Find the Last Row of your Range 00:15:16 Duration
Lecture 5 Copying & resizing a variably sized range 00:09:13 Duration
Lecture 6 Properly Referencing Worksheets 00:14:31 Duration
Lecture 7 Properly Referencing Workbooks 00:10:06 Duration
Lecture 8 Activity Save a Hard-coded Copy of Workbook
Lecture 9 Project Save Hard-coded Copy & Macro-free version of workbook 00:12:08 Duration
Lecture 10 Key Takeaways for Referencing Ranges 00:02:44 Duration

Section 5 : Working with Variables
Lecture 1 Overview Role of Assignment & Variables 00:02:40 Duration
Lecture 2 Data Types for Better Performance 00:03:18 Duration
Lecture 3 Declaring Variables, Arrays & Constants (Role of Option Explicit) 00:12:35 Duration
Lecture 4 Using Object Variables (Set statement) 00:06:35 Duration
Lecture 5 Scoping Variables 00:06:43 Duration
Lecture 6 Activity Revisit Hard-coded Workbook Project & Use Variable Assignment
Lecture 7 Key Takeaways for Working with Variables 00:02:00 Duration

Section 6 : Looping through Collections & Making Decisions
Lecture 1 Overview Why Collections are a VBA Essential 00:01:12 Duration
Lecture 2 With & End With for Easier Code Writing 00:06:06 Duration
Lecture 3 For Each to Loop Through Collections (sheets, ranges etc 00:09:59 Duration
Lecture 4 IF Then (Else, ElseIF) for Conditional Outcomes 00:10:02 Duration
Lecture 5 Select Case as Alternative for Many IF Statements 00:05:06 Duration
Lecture 6 Goto Statement to Change Program Flow 00:07:21 Duration
Lecture 7 Activity Get the Number of Formulas on the worksheet
Lecture 8 Project Get the Number of Formulas on the Worksheet 00:06:45 Duration
Lecture 9 Bonus Unhide All Sheets in One Go 00:09:40 Duration
Lecture 10 Key Takeaways for Collections & Decision Making in VBA

Section 7 : Useful Built-in Functions
Lecture 1 Overview VBA versus Worksheet Functions 00:13:18 Duration
Lecture 2 Most Useful VBA Functions 00:09:47 Duration
Lecture 3 Message Box (also with Yes, No buttons) 00:08:28 Duration
Lecture 4 Input Box (VBA InputBox Function) 00:07:13 Duration
Lecture 5 Input Box that can Select Ranges (Excel InputBox Method) 00:12:12 Duration
Lecture 6 Activity Show Top 3 Values in a Message Box Based on Range Selected
Lecture 7 Project Show Top 3 Values in a Message box based on Range Selected 00:11:02 Duration
Lecture 8 Key Takeaways Built-in Functions

Section 8 : Debugging, Error Handling & Procedure Scope
Lecture 1 Overview Debugging, Handling Errors & Procedure Scope 00:01:42 Duration
Lecture 2 Debugging Options Watch, Locals, Immediate Windows & More 00:12:56 Duration
Lecture 3 Error Handling Different Methods 00:10:30 Duration
Lecture 4 Faster Code by Suppressing Pop-ups & Flickering Screen 00:10:23 Duration
Lecture 5 Procedure Scope & Running one Sub from Another 00:06:08 Duration
Lecture 6 Passing Arguments to Sub Procedures (By Ref, By Val) 00:09:34 Duration
Lecture 7 Activity Get the Total Number of Formulas (or Comments) Used in a Workbook
Lecture 8 Project Get the Total Number of Formulas (or Comments) Used in a Workbook 00:11:27 Duration
Lecture 9 Key Takeaways Debugging, Error Handling & Course Map Status 00:01:40 Duration

Section 9 : Main Project #1 Create a Tool to Automate Table of Contents
Lecture 1 Project overview Table of Contents (TOC) with one click
Lecture 2 TOC Project The Basics 00:10:17 Duration
Lecture 3 TOC Project Adding Hyperlinks 00:05:53 Duration
Lecture 4 TOC Project Testing the VBA Code 00:04:15 Duration
Lecture 5 TOC Project Adding Error Handling & More Checks 00:13:12 Duration
Lecture 6 TOC Project Adding to Personal Macro Workbook (Make it Available to all Files) 00:06:54 Duration
Lecture 7 First Milestone Completed!

Section 10 : Looping in VBA (Controlling the Flow of Code)
Lecture 1 Section Overview Looping in VBA 00:02:16 Duration
Lecture 2 For Next Counter Loops (Simple Example) 00:08:33 Duration
Lecture 3 For Next Nested Loop (Loop through Text & Cells) 00:15:20 Duration
Lecture 4 For Next Reverse Loop (Delete FilteredHidden Rows) 00:08:21 Duration
Lecture 5 Do Until & Do While Loop 00:09:40 Duration
Lecture 6 Practical Example of Do Loop (with Inputbox) 00:03:07 Duration
Lecture 7 Find Method for Quicker Lookup Results 00:08:47 Duration
Lecture 8 Find Method with Do Loop - Multiple Matches 00:06:09 Duration
Lecture 9 Add a Timer to Test & Speech to Inform 00:07:37 Duration
Lecture 10 Activity Document all Comments in Workbook in a Sheet
Lecture 11 Project Document all Comments in Workbook in a Sheet 00:12:14 Duration
Lecture 12 Useful VBA Statements & Key takeaways for Looping in VBA 00:03:14 Duration

Section 11 : Working with Arrays
Lecture 1 Overview Working with Arrays in VBA 00:01:22 Duration
Lecture 2 One Dimensional Arrays (and transferring back to sheet) 00:13:26 Duration
Lecture 3 Dynamic Arrays (size adjusts depending on a condition) 00:06:25 Duration
Lecture 4 Preserving Dynamic Arrays (adding more elements to the existing array)
Lecture 5 Two Dimensional Arrays 00:07:21 Duration
Lecture 6 Variant Arrays Quick Method to Write to Cells 00:08:23 Duration
Lecture 7 Activity Create a New Worksheet per Company with Specific Information
Lecture 8 Project Create a New Worksheet per Company with Specific Information 00:09:20 Duration
Lecture 9 Key Takeaways Arrays

Section 12 : Working with Files, Folders & Text Files
Lecture 1 Overview Working with Folders & Files 00:02:30 Duration
Lecture 2 INTRODUCTION TO BRAINMEASURES PROCTOR SYSTEM
Lecture 3 GetOpenFileName Method User Selects a File 00:09:10 Duration
Lecture 4 FileDialog Property Loop Inside a Folder 00:16:31 Duration
Lecture 5 Create CSV File from Data in Excel 00:07:21 Duration
Lecture 6 Printing & Writing to Text Files for More Control 00:06:32 Duration
Lecture 7 Activity Export Data to Text file (fix Delimiter to Semicolon)
Lecture 8 Project Export Data to Text file (fix Delimiter to Semicolon) 00:12:55 Duration
Lecture 9 Key Takeaways Files & Folders

Section 13 : Excel Tables, Formulas & Pivot Tables
Lecture 1 Overview (Pivot) Tables & Formulas 00:01:53 Duration
Lecture 2 Using Excel Formulas in VBA 00:13:34 Duration
Lecture 3 Excel Tables Use the Right Syntax 00:14:04 Duration
Lecture 4 Pivot Tables & VBA What you Need to Know 00:18:15 Duration
Lecture 5 Activity Update Existing Formulas with VBA by Adding IFERROR
Lecture 6 Project Update Existing Formulas with VBA by Adding IFERROR 00:08:00 Duration
Lecture 7 Key Takeaways (Pivot) Tables & Formula

Section 14 : Main Project #2 Sales Regional Reporting Tool
Lecture 1 What You'll Learn (& Should be Aware of 00:03:42 Duration
Lecture 2 Project Overview Regional Sales Reporting Tool 00:13:55 Duration
Lecture 3 Importing Data from Multiple Files using MultiSelect 00:16:39 Duration
Lecture 4 Setting up a Template as the Basis for Different Reports 00:25:05 Duration
Lecture 5 Exporting Reports as Excel files (Pivot Table & Hard Coded Reports) 00:16:47 Duration
Lecture 6 Fine-tuning Report Export Procedure (Double-check if user wants to overwrite) 00:10:51 Duration
Lecture 7 Setting up Automatic Export of Text File (Fix delimiter in CSV to Semicolon) 00:08:15 Duration
Lecture 8 Track the List of Tasks Completed with VBA 00:11:02 Duration
Lecture 9 Final Touches & Creating Interface to Hide Specific Tabs with a Password 00:10:52 Duration
Lecture 10 Key Takeaways & Tips for VBA based Excel Tools 00:02:24 Duration
Lecture 11 Second Milestone Completed!

Section 15 : Interacting with Other Applications (Word, PowerPoint etc
Lecture 1 Overview & Important Concepts when Interacting with Other Applications 00:04:46 Duration
Lecture 2 Project PDF Save Specific Sheets as a PDF File 00:13:58 Duration
Lecture 3 Project Email Automatically Create Personalized Emails with Attachments 00:08:52 Duration
Lecture 4 Project Microsoft Word Create Personalized Letters in Word from Excel 00:15:55 Duration
Lecture 5 Project Microsoft PowerPoint Export Excel Sheets to PowerPoint Presentation 00:18:53 Duration
Lecture 6 Key Takeaways when Working with other Applications

Section 16 : Workbook and Worksheet Events
Lecture 1 Overview & What are Event Procedures 00:02:51 Duration
Lecture 2 Workbook Events, Toggle Full Screen (Activate, Deactivate, Open, Close) 00:12:40 Duration
Lecture 3 Worksheet Selection Change Dynamic Font Color of Selected Range 00:05:37 Duration
Lecture 4 Refresh PivotTables Automatically & Concept of Range Intersection 00:12:27 Duration
Lecture 5 Resetting a Dependent Drop-down when the first Drop-down is Changed 00:10:41 Duration
Lecture 6 Activity Link Page Header to Cell Value (BeforePrint Event)
Lecture 7 INTRODUCTION TO BRAINMEASURES PROCTOR SYSTEM
Lecture 8 About Certification

Section 17 : Working with Userforms & ActiveX Controls
Lecture 1 Overview UserForms & ActiveX Controls 00:01:38 Duration
Lecture 2 ActiveX Controls What you Need to Know 00:07:18 Duration
Lecture 3 ActiveX Check Box to Fix Scroll Area & Toggle Screen Settings 00:07:40 Duration
Lecture 4 ActiveX to Show and Hide Help
Lecture 5 ActiveX Combo Box for Easy Sheet Navigation (Great for Larger Workbooks) 00:10:16 Duration
Lecture 6 ActiveX to Show or Hide Other ActiveX controls (eg 00:13:33 Duration
Lecture 7 UserForm Basics What You Need to Get Started 00:20:01 Duration
Lecture 8 UserForm for Data Entry (Input & Check Boxes) 00:13:56 Duration
Lecture 9 UserForm to Document External Links & Comments (Combo Box & Option button) 00:20:21 Duration
Lecture 10 Bonus ListBox to Print Multiple Pages in ONE GO 00:10:41 Duration
Lecture 11 UserForm Checklist & Course Map Status

Section 18 : Main Project #3 Invoice Generation Tool
Lecture 1 Tool Overview What You Will Learn 00:13:52 Duration
Lecture 2 Setting up an Input UserForm to Collect Master Data 00:13:52 Duration
Lecture 3 Working with Multi-Column ListBoxes
Lecture 4 Edit Master Data with UserForm 00:07:31 Duration
Lecture 5 Searchable ListBox (with Selection Change event) 00:17:06 Duration
Lecture 6 Enhanced Searchable ListBox Write Selection back to Excel Table 00:16:21 Duration
Lecture 7 MultiPage UserForm to Create Invoices & Email (Setup) 00:18:17 Duration
Lecture 8 Export PDF & Excel Workbook for Each Invoice based on ListBox Selection 00:23:32 Duration
Lecture 9 Create Email in Outlook & Attach PDF Invoice 00:14:15 Duration
Lecture 10 Final Updates & Debugging 00:19:04 Duration
Lecture 11 Last Milestone Completed!

Section 19 : Create your own Custom Functions
Lecture 1 Section Overview Function Procedures 00:01:51 Duration
Lecture 2 Setting up a Simple Function (including Optional Arguments) 00:05:34 Duration
Lecture 3 Function to Calculate Age (Result in Years & Months) 00:05:48 Duration
Lecture 4 Functions that Split Text and Numbers from Cell Value 00:08:15 Duration
Lecture 5 Using Functions in Sub Procedures 00:06:05 Duration
Lecture 6 Activity Function That Sums based on Cell Color
Lecture 7 Project Function That Sums based on Cell Color 00:10:46 Duration
Lecture 8 Key Takeaways Function Procedures in VBA & Course Map Status

Section 20 : Working with Charts
Lecture 1 The Chart Object Library & Section Overview 00:03:05 Duration
Lecture 2 Create and Modify a Chart with VBA 00:12:46 Duration
Lecture 3 Animated Charts Different Methods
Lecture 4 Show Charts inside UserForms 00:13:06 Duration
Lecture 5 Key Takeaways Charts

Section 21 : Summary & Final Words
Lecture 1 Your Next Steps & more Learning 00:01:45 Duration