MyPage is a personalized page based on your interests.The page is customized to help you to find content that matters you the most.

I'm not curious

Excel VBA Course - Automate Repetitive or Complex Tasks

Course Summary

Learn Excel VBA and achieve the impossible.

  • +

    Course Syllabus

    • Introduction
      • Introduction
    • Recording Macros
      • Recording a Macro
      • Saving a Macro Enabled File
      • Assigning a Macro to a Toolbar Button
      • Customising the Ribbon
      • Add your Macro Button to the Worksheet
      • Editing Macro Code
      • Using Relative References when Recording Macros
    • Getting Started with VBA
      • Introducing the Visual Basic Editor
      • Writing your First Macro
      • Cleaning Recorded Code
      • Working with Method Arguments
      • Referring to Cells, sheets and Workbooks
      • Errors in VBA
      • Introduction to VBA Quiz
    • Working with Variables
      • Using Variables
      • The Role of Option Explicit
      • Variable Scope
      • Using Object Variables
      • Using Variables Quiz
    • Making Decisions
      • If..Then..Else Statements
      • Select Case Statements
    • Looping
      • Conditional Loops
      • Using the Cells Object with a Loop
      • Conditional Loops - Updating an Inventory List
      • Counter Loops - Delete Blank Rows on a Worksheet
      • Counter Loops - Protect All the Worksheets in a Workbook
      • Collection Loops - Convert Selected Text to Uppercase
      • Nesting Loops - Updating an Inventory List 2
      • Make your Procedures Faster and Stop Interference
    • Error Handling and Debugging
      • Debugging Code
      • On Error Resume Next
      • Creating Error Handlers
      • Using Multiple Error Handlers
      • The Err Object
      • Other Ways of Handling Anticipated Errors
    • User Interaction
      • Message Boxes - Updating an Inventory List 3
      • Input Boxes
      • Dialog Boxes - Using the Save As Dialog Box
    • Working with Files and Folders
      • Loop Through all Files in a Folder
      • Loop Through Specific Files of Type - List File Names on a Worksheet
      • Create Directories and Export as PDF
    • Working with Arrays
      • Introduction to Arrays – One-Dimensional Fixed Arrays
      • Two-Dimensional Arrays
      • Dynamic Arrays
    • UserForms
      • Creating a Userform
      • Opening and Closing a Userform
      • Adding Functionality to the Userform
      • Validating Data on a Userform
    • Running Procedures from Events
      • The Workbook Open Event
      • The Workbook Before Save Event
      • The New Sheet Event
      • The Selection Change Event
      • The Worksheet Change Event
    • Creating Function Procedures
      • Creating a Function Procedure
      • Optional Arguments and Data Types
      • Documenting your Function Procedures
      • Creating an Add-In
    • Conclusion
      • What Next

Course Fee:
USD 129

Course Type:


Course Status:



1 - 4 hours / week

This course is listed under Development & Implementations Community

Related Posts:

Attended this course?

Back to Top

Awards & Accolades for MyTechLogy
Winner of
Top 100 Asia
Finalist at SiTF Awards 2014 under the category Best Social & Community Product
Finalist at HR Vendor of the Year 2015 Awards under the category Best Learning Management System
Finalist at HR Vendor of the Year 2015 Awards under the category Best Talent Management Software
Hidden Image Url

Back to Top