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 (Macros) with Projects

Course Summary

Learn to use VBA to enhance Excel's functionality to increase efficiency and productivity


  • +

    Course Syllabus

    • The Macro Recorder
      • Course Overview
      • Defining Macros
      • Application of Macros
      • Recording a Macro
      • Edit the recorded Macro and Shortcut key
      • Saving a macro file
      • Macro Security settings
      • Running Macros
      • Storage Location
    • VBA fundamentals
      • What is Programming
      • VBA Fundamentals
      • Enable Developer Tab
      • VBE
      • Writing a small VBA code
    • Building Procedures
      • How to create a sub procedure
      • Adding Comments
      • Types of procedures
      • Calling Procedure
      • Passing Arguments to the procedure
    • Working With Excel VBA Functions
      • How to create functions
      • How to use conditions in functions
      • Using conditions If...Then....Else
      • User Defined Functions
    • Basics of VBA coding
      • Assigning a variable
      • Different ways of assigning variables
      • DataTypes
      • Constants
      • Operators
    • Working with the dialog boxes
      • MsgBox
      • Adding arguments to the msg box
      • Input Box usage
    • Working with the objects
      • Object Reference Model
      • Range
      • Cell objects
      • Range Properties and Methods
      • Range Count Property
      • Mergecell & range
      • Range Select
      • Selection of Rows and Columns
      • Difference between Dim and Set
      • Understanding Worksheet Object
      • Worksheet properties and methods
      • Understanding workbook object
      • How to Delete a workbook
      • Application Objects
      • Object Browser
    • Manipulating Excel Objects
      • Offset
      • Application of Offset
      • Offset property in VBA
    • Loops
      • Loops
      • For-next loop
      • Do while-loop
      • Do-loop while
      • Assignment
      • For Each…Next
    • Events - Triggering code with Events
      • Creating Events(Open Event)
      • Close Events
      • Workbook Activate Sheet Events
      • Workbook Activate Events
      • Worksheet ActivateDec Events
      • Application Events
    • Creating Excel Add-ins
      • How to create Excel Add-ins
    • Debugging And Error Handling
      • Error Handling
      • Debugging
      • Speeding Up The VBA Tips
    • Working with the Arrays in VBA
      • Array Function
      • Dynamic and Fixed Arrays
      • Size of Array
    • Working with the Userforms
      • Selecting a Range with The Input Box
      • An Introduction To UserForms
      • Step by step process of creating a userform
      • How to create a userform canvas
      • Adding controls to the userform
      • How to set the properties to userform controls
      • Adding codes to the form controls
      • Allowing The User To Highlight A Range using VBA
      • Allowing The User To Highlight a Range using Userform
      • How to create scrollbars and spinbutons in the userfom
      • Adding images to the Userform
      • How to add an Image in the Userform using a list box
      • Adding Option Buttons In a Frame
      • Multiple Tabs On A UserForm
      • Controlling Tab Order and Aligning Controls
    • Working on a Live project
      • Data mining with Advanced Filters
      • Split Data to Multiple Worksheets Method 1
      • Split Data to Multiple Worksheets Method 2
      • How to split the Filtered Data onto Multiple Workbooks
      • How to combine Multiple Worksheets to one single Worksheet in Excel?
      • Merging Data from Multiple Workbooks into a Summary Workbook
      • Using VBA to create Pivot tables
      • Assignment
      • Using VBA to create Charts
      • Concept of Binding
      • Automating Word Using Excel VBA
      • Export charts to Powerpoint using Excel VBA
      • Export the data to Powerpoint
      • Outlook Mails
      • Sending Outlook Mails with Attachment
    • Case Study
      • Password Protection
      • Creating Hyperlinks to all the Worksheets
      • Creating Hyperlinks to all the Workbooks
      • Protect-Unprotect all the Worksheets using Password
      • Protect using Password
      • Data Transpose Using Offset
      • Conclusion


Course Fee:
USD 99

Course Type:

Self-Study

Course Status:

Active

Workload:

1 - 4 hours / week

This course is listed under Development & Implementations and Data & Information Management Community

Attended this course?

Back to Top

Awards & Accolades for MyTechLogy
Winner of
REDHERRING
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