Excel VBA Macros Hyderabad

Excel VBA Macros Hyderabad

 

  • VBA Excel

    VBA for Excel Macros

    Sale Date Ended

    INR 5000
    Sold Out

Invite friends

Contact Us

Page Views : 461

About The Event

This course is for you if you spend a lot of time on excel or if you are interested to move to a MIS position. The course will teach you the basics of programming and you will learn how to automate daily tasks in excel. No programming knowledge required but you should be good with excel.

Packed with practical examples and real time projects you will gain the confidence to write your own code to automate any excel activity. Please visit www.upskilltechnologies.com for more details or give us a call at 9985130004.

 

Contents:

Macros

  • Introduction to Programming.
  • Using macro recorder.

  • Getting Familiar with VBA Editor.

  • Creating modules.

  • Generating code from macro recorder.

  • Understanding the code.

  • Writing basic code.

  • Reference types in recording code.

  • Objects and Collections:

    • Object Hierarchy
    • VBA syntax to refer an object.

    • Object Properties & Methods.

    • Collections Analogy

    • Working with cell/range object

    • Working with cells, sheets and workbooks

    • VBA code to copy paste

  • Conditions and Loops

    • Using IF condition in VBA.
    • IF-Else and IIF conditions.

    • Multiple IF vs Select Case

    • Do While Loop

    • For-Each & For-Next

    • Using For Loop with conditions

    • Using With-End Construct.

    • Loop between sheets and workbooks.

  • Functions and Events

    • Creating formulas with VBA.
    • Calling functions and procedures.

    • Using XL Formulas in VBA code.

    • Passing arguments to functions.

    • Workbook events.

    • Sheet Events

    • Cell Change Events
  • Charts, Pivots and Userforms

    • Creating dynamic charts with Excel.
    • Code to create and update Charts.

    • Creating Pivots with VBA.

    • Creating Userform to gather information.

    • Design Userform.

    • Working with Userform controls.

    • Creating a responsive Userform.

    • Error Handling Techniques
  • Venue Map