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

Microsoft Excel - VBA

Course Summary

Extend your knowledge of recorded macros using Excel VBA. Learn about Forms, Loops, Defined Functions and Automation

  • +

    Course Syllabus

    • Introducing VBA
      • Introduction
      • Excel Overview
      • Recording a Macro
      • Reviewing Macro Code
      • Overview Of VBA And Office
      • Objects, Methods And Properties
      • Differences Between Office 2003, 2007, 2010 And 2013
      • Creating A Macro Enabled Workbook
    • Macro Recorder Part 1
      • Introduction
      • Recording A Macro To Format Cells
      • Recording A Macro To Format Cells As Currency
      • Recording A Macro To Swap Two Columns
      • Recording A Macro Using Relative References Rather Than Absolute
      • Recording A Macro To Turn Gridlines On And Off
      • Tweaking Macros To Change Their Functionality
    • Macro Recorder Part 2 - a larger example
      • Introduction
      • Some Useful Functionality In Excel For Cell Selection
      • Importing A Text File
      • Filling Blank Cells With Data
      • Adding A Column With The Date
      • Creating A Pivot
      • Creating A Chart
      • Deleting Sheets And Charts
      • Putting Them All Together
    • Forms
      • Introduction
      • Creating A Simple Switchboard Form To Call Our Previous Macros
      • Adding A Button To The Ribbon To Display The Form
      • Using The Auto Open Events To Display The Form
      • The Name List Form, Dealing With Events
      • Using String Functions To Manipulate Text
      • Creating A Form To Interact With Data On A Sheet
    • Loops
      • Introduction
      • Looping Through Data In A Column With The For Loop
      • The While Loop
      • Using ‘Cells’ To Access A Cell
      • Looping Through Variable Length Lists
      • Looping Through Data In A Column With Spaces
      • Calling Formula To Determine When To Stop A Loop
      • Creating Reusable VBA Code
      • Finding And Formatting Data Using Loops
    • User Defined Functions
      • Introductions
      • Creating A User Defined Function (UDF)
      • Creating A Variable Discount Calculation UDF
      • Error Handling In VBA
      • Debugging In VBA
    • Automation
      • Introduction
      • Automating Word From Excel
      • Automating Powerpoint From Excel
      • Automating Outlook From Excel
      • Getting Data From Access Into Excel Using VBA
    • Security
      • Introduction
      • Personal Macro Workbook
      • Macro Security Levels
      • Using A Digital Signature
    • VBA Language review
      • VBA Language review

Course Fee:
USD 25

Course Type:


Course Status:



1 - 4 hours / week

This course is listed under Development & Implementations and Data & Information Management 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