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

VBA - Visual Basic and Macros Course (Beginner & Advanced)

Course Summary

Comprehensive Guide to VBA and Macros Training. Non-coding approach. Empower your workbook with VBA automations


  • +

    Course Syllabus

    • VBA & Macros: Part [1 & 2] Introduction
      • VBA & Macros: Course Introduction
    • Introduction to VBA
      • What are VBA & Macros?
      • Advantages of using VBA and Macros
    • My First Macro
      • My First Macro
      • Protocols in creating Macros
      • Creating My First Macro
    • VBA Environment
      • VBA Environment
      • VBA Environment - Project Explorer
      • VBA Environment - Properties
      • VBA Environment - Run Break Reset and Design
      • VBA Environment - Debug - Toggle
      • VBA Environment - Debug - Local Window
      • VBA Environment - Debug - Watch and Immediate Window
    • Macros with IF Condition
      • Macros with IF Condition
      • Macros with IF Condition
      • Macros with IF Condition (Continued)
    • Data Filter
      • Data Filter
      • Data Filter using VBA - Introduction
      • Data Filter using VBA - Macro Recording
      • Data Filter using VBA - Dynamic Update
      • Data Filter using VBA - Command Buttons
      • Data Filter using VBA - Command Buttons - Modifying
      • Data Filter using VBA - Command Buttons - Final touches
    • Charting using VBA
      • Charting using VBA
      • Charting using VBA - Introduction
      • Charting using VBA - Creating codes for charts
      • Charting using VBA - Recording Macro
      • Charting using VBA - Chart in another sheet
      • Charting using VBA - Dynamic Inputs
      • Charting using VBA - Creating Dynamic charts
      • Charting using VBA - Checking the codes
    • Userform
      • Userform
      • Userforms - Introduction
      • Userforms - Textbox
      • Userforms - Textbox Printing
    • VBA Introduction
      • VBA Introduction
    • Userform - EMI
      • EMI Userform - Introduction
      • EMI Userform - Creating the userform
      • EMI Userform - Creating basic Combo Box
      • EMI Userform - Activating the userform
      • EMI Userform - Recreating Combo Box
      • EMI Userform - Function of List Box
      • EMI Userform - Create and testing the List Box
      • EMI Userform - Inserting the List box
      • EMI Userform - Radio Button and its usage
      • EMI Userform - Enabling command button
      • EMI Userform - Creating option buttons
      • EMI Userform - Checkbox
      • Practice Exercise - Controls
    • Looping
      • Looping
      • Looping - Meaning of Looping and For Next Loop
      • Looping - For Next Loop
      • Looping - For Next - Exit For and Step
      • Looping - For Next - Nested Loops
      • Looping - Do Until Loops
      • Looping - Do While Loops
      • User Defined Function
    • Last Row and Column
      • Last Row and Column
      • Last Row and Column - Identification of last row and last column
      • Last Row and Column - Dynamic
    • Referencing Sheets
      • Referencing
      • Referencing from the Same Workbook
      • Referencing from the Another Open Workbook
      • Referencing from the Another Closed Workbook
      • Referencing from the Another Closed Workbook with Dynamic Ranges
    • Calculator - Update Now
      • Calculator - Update Now
    • Writing Formulas
      • Writing Formulas
      • Writing Formula - RowColumn Method
      • Writing Formula - Range Formula and Worksheet fn
    • Calculator - EMI Calculations
      • PMT formula
      • Recording Macros
      • Modifying Code and Linking to user inputs
      • Modifying Code and Linking to user inputs - Update dynamically
      • New Sheet with selected user inputs
      • New Sheet with selected user inputs and coding
      • Debugging the code - VLOOKUP function
      • Debugging the code - EMI and processing charges
      • Project - EMI Calculation
      • Calculate EMI
    • Arrays
      • Introduction to Sort EMI - Button
      • Arrays basics
      • Populating arrays in Worksheet
      • Sorting Numbers using Arrays
      • Sorting Numbers using Arrays (Continued)
      • Sorting Numbers using Arrays - Understanding the code
      • Sorting Strings using Arrays
    • Sort EMI Button
      • Assign Bank Details to Arrays
      • Assign Bank Details to Arrays (Continued)
      • Sort Bank Details Arrays
      • Sort Bank Details Arrays (Continued)
      • Sorted Array in New Worksheet
      • Milestone 4. Project -- Sort EMI
      • Sort EMI
    • EMI Calculator - Create Graph
      • Introduction
    • Create Graph
      • Create graphs using Macros
      • Copying Bank Details to Graph Sheet
      • Creating Static Graph
      • Creating Dynamic Graph
      • Positing Graph at customized location
      • Dynamic graph Conclusion
      • Milestone 5. Project -EMI Graph
    • Print using VBA
      • Print - user defined sheet number or name
      • Print - Dynamic Range
      • Print - Dynamic Range (Continued)
      • Debug - Print
      • Print
    • EMI - Calculator - Print Report
      • Print Report - Dynamic table and graph
      • Print Report (Continued)
      • Print Report - Tackling errors
      • Milestone 6. Project - Print Report
    • EMI - Calculator - Email Report
      • Creating PDF
      • Creating PDF and integrating the userform
      • Milestone 7a) Calculator - PDF
      • Email Report with PDF
      • Email Report with PDF - EMI calculator
      • Print and email report
      • Milestone 7b) Calculator - Email
      • Email Report
    • VBA & Macros: Part [1 & 2] Conclusion
      • VBA & Macros: Part [1 & 2] Conclusion


Course Fee:
USD 119

Course Type:

Self-Study

Course Status:

Active

Workload:

1 - 4 hours / week

Related Posts:

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