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 for Beginners

Course Summary

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


  • +

    Course Syllabus

    • Course Overview
      • VBA & Macros: An Overview
    • Introduction to VBA
      • What are VBA's and 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
      • Macro 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
    • 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 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