dvanalytics whatsapp contact
dvanalytics whatsapp

Excel VBA Programming


    Visual Basic for Applications. It’s a programming language that enables you to control just about everything in Excel. You’ll learn how to create Macros that can be run from things like a button on a spreadsheet.

    Course Curriculum

    Session - 1
    Excel navigation through developer tab 00:00:00
    Record the first macro using manual process 00:00:00
    Get through excel vba .notation 00:00:00
    Session - 2
    VBA conditional logic using If then Else if 00:00:00
    Conditional and logical operators 00:00:00
    Programming Loops and Arrays 00:00:00
    String Functions VBA 00:00:00
    Session - 3
    Subs and Functions 00:00:00
    VBA code for data importing and connection to db 00:00:00
    Advanced VBA queries for sheet navigation and filters 00:00:00
    Session - 4
    Excel VBA user forms 00:00:00
    Excel VBA Charts, Embedded Charts, Charts and User Forms etc 00:00:00