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 | ||
Related Courses
