About This Course

Excel is the most commonly used and in demand tool for making sense of data. When you can harness that power, you will become a more valuable employee. If you run a business, being proficient in Excel can help you see your business in a completely different light. If you want to fully harness the power of Excel, then learning how to program in VBA – Visual Basic for Applications, is essential.

This course is if you want to join the Excel Elite, and program your own solutions, if you want to automate most of your work, do more in less time with less effort, if you want to earn more money and you may even fancy a career change.

In this course you will learn everything you need to know about coding in Visual Basic for Applications (VBA), why Visual Basic for Applications (VBA) is the powerhouse which is the engine that lives under the hood where all the magic can happen, the step-by-step process, methods that build powerful solutions easily and quickly, how to streamline your code for efficiency that will give you confidence to program your own solution.

Our Promise to You

By the end of this course, you will have learned Visual Basic for Applications in Excel.

30 Day Money Back Guarantee. If you are unsatisfied for any reason, simply contact us and we’ll give you a full refund. No questions asked.

Get started today and learn more about coding in Visual Basics for applications in Excel.

Course Curriculum

Section 1 - What Is It All About
Why Should I Learn How To Code? 00:00:00
The Fifteen Golden Rules Of Coding 00:00:00
Downloadable Materials 00:00:00
Section 2 – Introducing Your Personal Built In Translator - The Macro Recorder
Introducing The Visual Basic Editor And Recording Our First Macro 00:00:00
Saving Macro-Enabled Workbooks And Security Settings 00:00:00
Moving Code Around 00:00:00
Stepping Out. Well, In Actually – Debugging Made Easy 00:00:00
With And End With 00:00:00
Streamlining You Code Or Get Rid Of What You Don’t Need 00:00:00
Combining Your Code 00:00:00
A Little Privacy Please 00:00:00
Keyboard Shortcuts And Why I Don’t Use Them 00:00:00
Why You Can’t Get By With Just Recording Macros 00:00:00
Section 3 - The Building Blocks Of Coding: Your Dictionary And Phrase Book Of Success
Introduction To The Coding Section 00:00:00
Getting All The Code For This Section 00:00:00
Changing Your VBE Settings 00:00:00
Protecting Your Code 00:00:00
Objects, Methods And Properties 00:00:00
Understanding The Hierarchy 00:00:00
The Range Object 00:00:00
The Cells Object 00:00:00
The Active Cell Property 00:00:00
The Offset Property 00:00:00
The End Property 00:00:00
Dynamic Range Selection 00:00:00
The Current Region Property 00:00:00
Activate Vs. Select 00:00:00
Between The Sheets 00:00:00
Calling A Sheet By Its VB Name 00:00:00
Sheets Vs. Worksheets 00:00:00
Getting Around The Workbooks 00:00:00
The Value Property – Writing Data 00:00:00
The Value Property – Reading And Writing Data 00:00:00
Copy And Paste 00:00:00
Commonly Used Properties 00:00:00
Coding Exercise: The Rainbow 00:00:00
The Address Property 00:00:00
The Row And Column Properties 00:00:00
Capturing The Column Letter 00:00:00
More Useful Properties 00:00:00
Even More Useful Properties 00:00:00
Opening Another Workbook Programmatically 00:00:00
Closing Workbooks Programmatically 00:00:00
Coding Exercise: Open/Write/Close 00:00:00
Section 4 - The Programmers Toolbox: The Techie Stuff, Made Easy
Introduction To The Programmers Toolbox 00:00:00
Variables – Local Variables 00:00:00
Variables – Local Variables With A Twist 00:00:00
Variables – Module Level Variables 00:00:00
Variables – Project Level Variables 00:00:00
Bonus – Calling A Sub Stored In A Different Workbook 00:00:00
A Neat Trick To Force Variable Declaration 00:00:00
Variables – All The Techie Bits 00:00:00
An Introduction To Looping 00:00:00
Looping With Do Loop 00:00:00
Looping With For Next 00:00:00
Looping With A Stepped For Next 00:00:00
Looping With While Wend 00:00:00
An Introduction To Logical Testing 00:00:00
Logical Testing – A Simple If Test 00:00:00
Logical Testing – A Simple If Test Using Cells 00:00:00
Logical Testing – If Then Else 00:00:00
Logical Testing – If Then Else Using Cells 00:00:00
Logical Testing – Testing Multiple Criteria 00:00:00
Logical Testing – Testing If One Is True And One Is False 00:00:00
Logical Testing – Testing If Either Value Is True 00:00:00
Logical Testing – Select Case 00:00:00
Maths – Doing Simple Maths In Code 00:00:00
Maths – Writing Formulas To Single Cells 00:00:00
Maths – Writing Formulas To Ranges Of Cells 00:00:00
Maths – Using Excel’s Built-In Functions 00:00:00
Maths – Built-In Functions With Defined Ranges 00:00:00
InputBox – Getting User Input Using The InputBox Function 00:00:00
Manipulating The User Input With Casing 00:00:00
InputBox – Getting User Input Using The InputBox Method 00:00:00
Message Boxes – Simple Message Boxes 00:00:00
Message Boxes – Testing Which Button Was Pressed 00:00:00
Arrays – An Introduction 00:00:00
Arrays – A Simple One Dimensional Static Array 00:00:00
Arrays – A Simple One Dimensional Dynamic Array 00:00:00
Arrays – A Simple Two Dimensional Static Array 00:00:00
Arrays – The Most Efficient Way To Capture An Array 00:00:00
Arrays – Extracting Useful Data Based On User Input 00:00:00
Arrays – Using An Array As A Data Source For A VLookup 00:00:00
Section 5 - Automating All Your Reports
Introduction To Report Automation Section 00:00:00
A Special Note For Office 2010 Users 00:00:00
Recording The Bones Of The Code 00:00:00
Streamlining The “Add New Sheet Code” 00:00:00
Deconstructing The “Profit By Day” Code 00:00:00
Building Source Data Strings Dynamically At Runtime 00:00:00
Creating The Run Order and Data Capture Subs 00:00:00
Solving That Naming Problem 00:00:00
Power User – Sizing Your Charts Precisely 00:00:00
Changing The Chart Title (And Why We Do It Separately) 00:00:00
Deconstructing The Pivot Tables (It’s Slightly Different) 00:00:00
Titles, Money And Sorting 00:00:00
Butchering One Table, To Create Another 00:00:00
Adding The Commentary – Building Strings Dynamically At Runtime 00:00:00
Adding The Commentary Using Data From The Sheet We’re On 00:00:00
Power User – How Do You Make Specific Words Bold 00:00:00
Power User – Instr: A Very Useful Function 00:00:00
Instr And Paying Attention To Detail 00:00:00
Tidy Up The Title 00:00:00
Easy As Pie (Chart) 00:00:00
Prettying Up Our Pie Chart 00:00:00
Putting It All Together 00:00:00
Section 6 - The Data Is Out There On The Internet, That Is
Introduction To Web Query Section 00:00:00
Pulling Data From The Internet – Capturing The Data For Rome 00:00:00
Getting To Cancun And London From Rome 00:00:00
Data Clean Up 00:00:00
A Simple Find And Replace 00:00:00
Getting Our Formulas Right 00:00:00
Streamlining The Formulas Code 00:00:00
Power User – Displaying Messages In The Status Bar (Cool) 00:00:00
Putting It All Together 00:00:00
Section 7 - Workbook Events: You Don't Have To Run Code To Have Code Run
Introduction To The Events Section 00:00:00
Work Book Sheet Activate 00:00:00
Work Book Before Print 00:00:00
Work Book Sheet Change 00:00:00
Work Book Open – Creating An Auto-Back Up 00:00:00
Work Book Open – Creating A Splash Screen 00:00:00
Work Book Open – Calling Other Code 00:00:00
Work Book Before Close 00:00:00
Work Sheet Activate – You Can’t Pick This 00:00:00
Work Sheet Activate – You Might Pick This 00:00:00
Work Sheet Change 00:00:00
Work Sheet Change – A More Useful Use 00:00:00
Work Sheet Activate – Top Secret Classified Information 00:00:00
Work Sheet Events: Bonus – Four New Things To Try 00:00:00
Section 8 - User Defined Functions: What To Do If The Function You Need Isn't In Excel
User Defined Functions: What They Are And How You Make Them 00:00:00
Using A User Defined Functions To Return Information 00:00:00
Creating A Countdown Timer With A User Defined Functions 00:00:00
A Custom User Defined Functions For Calculating Volume Discount 00:00:00
A User Defined Functions For Getting All Your Sheet Names 00:00:00
Calling A User Defined Functions From A Different Workbook 00:00:00
The Super CountIf And SuperSumIf User Defined Functions 00:00:00
Section 9 - Bonus Section: Controlling Windows - Folder Creation Gizmo
Introduction To Folder Creation Gizmo 00:00:00
Creating A New Folder With A Single Line Of Code 00:00:00
A Single Level Folder Structure 00:00:00
Folders Within Folders 00:00:00
Section 10 - Bonus Section: E-Mail Automation: Why Write Emails
Introduction To The Emailing Section 00:00:00
Understanding The E-Mail Routine 00:00:00
Deconstructing How We Capture All The Data 00:00:00
The E-Mail Loop 00:00:00
Section 11 - Bonus Section: Word Automation - Controlling Word From Excel
Introduction To The Word Section 00:00:00
Understanding The Word Routine 00:00:00
Deconstructing How We Capture All The Data 00:00:00
Formula Modifications With Unique Values 00:00:00
Efficient Sorting 00:00:00
Building The Text And Wrap Up 00:00:00
Section 12 - Bonus Section: PowerPoint Automation - Create Your Presentation In Seconds
Introduction To PowerPoint Section 00:00:00
A Run Through The PowerPoint Base Code 00:00:00
Setting Up The Shell Of The Code 00:00:00
Who’s Presenting This 00:00:00
Adding A Slide With A Logo And Text 00:00:00
Prettying Up The Formatting (More Lego Coding) 00:00:00
Using Slide One To Create Slide Two 00:00:00
Adding A Chart As A Picture 00:00:00
Adding Pivot Tables (And Another Chart) 00:00:00
Final Slide, And Wrap Up 00:00:00
Section 13 - Importing Specific Data From Multiple Files
Introduction To Importing Data From A Folder Full Of Files 00:00:00
Looping Through All Excel Files In A Folder 00:00:00
The Folder Picker 00:00:00
A More Useful Loop Through Files 00:00:00
The Data Grabber 00:00:00
Section 14 - Student Questions Answered
Get Rid Of Rows In An Array 00:00:00
Emailing Routine: Adding A Specific Attachment Based On A Criteria 00:00:00
Adding A Date Stamp And Going To The Insertion Point Automatically 00:00:00
Saving An Individual Sheet To A Specific Folder 00:00:00
Saving Multiple Sheets To A Single Workbook In A Specific Folder 00:00:00
Animated Charts With A Little Something Extra 00:00:00
Extracting Specific Data From A Big File To A Bunch Of Little Ones 00:00:00
Finding A Search String In Another Workbook With Multiple Sheets 00:00:00
Extracting Unique Tables To Unique Sheets From A Big Data Set 00:00:00
Protecting Specific Cells And Data Validation 00:00:00
Dynamically Populating A Reusable Array While Looping Through A Table 00:00:00
Sequential PDF Creation With Pictures 00:00:00
File Picker And Report Generator With Intelligent Filing 00:00:00
Help: My File Has Got Huge 00:00:00
Finding Updated Values In One Workbook, And Adding Them To Another Workbook 00:00:00
Gantt Charts With A Little More Sophistication 00:00:00
VLookups (Or Any Application Worksheet Function) Over Ranges 00:00:00
Adding A Date Stamp If A Change Has Been Made 00:00:00
top
Template Design © VibeThemes. All rights reserved.

Setup Menus in Admin Panel