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

Learning VBA in Excel

Course Summary

In Up and Running with VBA in Excel, Excel and VBA expert Curt Frye introduces object-oriented programming and shows how to automate routine tasks and provide custom functionality to enhance Excel performance and efficiency. This course introduces the Visual Basic for Applications programming language, covers creating subroutines and functions to hold code, and provides a solid grounding in the Excel 2007 object model. Programming techniques are demonstrated through real-world examples. Exercise files accompany the course.


  • +

    Course Syllabus

    1. Introducing Visual Basic for Applications (VBA)
    2. Defining Variables, Constants, and Calculations
    3. Adding Logic to Your VBA Code
    4. Debugging Your VBA Code
    5. Managing Workbook Elements and Data in VBA
    6. Adding Advanced Elements to Your Workbook
    7. Using Excel Events in Your VBA Code
    8. Putting It All Together
    Conclusion


Course Fee:
USD 19.99

Course Type:

Self-Study

Course Status:

Active

Workload:

1 - 4 hours / week

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