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 - Excel VBA and Macros Advanced Training

Course Summary

This Excel Visual Basic course gives you a non coding approach to VBA and Macros training (advanced)


  • +

    Course Syllabus

    • Course Overview
      • Excel file required for the Case Study
      • Course Overview
    • Introduction to VBA
      • Introduction to VBA
    • 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 - Excel Download
    • Looping
      • Looping - Excel Download
      • Looping - Meaning of Looping and For Next Loop
      • Looping - For Next part Loop
      • Looping - For Next - Exit For and Step
      • Looping - For Next - Nested Loops
      • Looping - Do Until Loops
      • Looping - Do While Loops
      • User Defined Function - Excel Download
    • Last Row and Column
      • Last Row and Column - Excel Download
      • Last Row and Column - Identification of last row and last column
      • Last Row and Column - Dynamic
    • Referencing Sheets
      • Referencing - Excel Download
      • 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
    • User defined function
      • User defined function - Excel Download
      • User defined function
    • Calculator - Update Now
      • Calculator - Update Now
    • Writing Formulas
      • Writing Formulas - Excel Download
      • 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
      • Milestone 3. Project - EMI Calculation - Excel Download
      • 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 - Excel Download
      • 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 - Excel Download
    • Print using VBA
      • Print - user defined sheet number or name
      • Print - Dynamic Range
      • Print - Dynamic Range (Continued)
    • EMI - Calculator - Print Report
      • Print Report - Dynamic table and graph
      • Print Report (Continued)
      • Print Report - Tackling errors
      • Print
      • Debug - Print
      • Milestone 6. Project - Print Report - Excel Download
    • EMI - Calculator - Email Report
      • Creating PDF
      • Creating PDF and integrating in the Userform
      • Milestone 7a) Calculator - Excel Download
      • Email Report with PDF - Part 1
      • Email Report with PDF - EMI calculator
      • Print and email report
      • Milestone 7b) Calculator - Email - Excel Download
      • Email Report
    • Conclusion
      • 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 Quality Assurance & Testing Community

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