Enquiry : 9920294574

Excel VBA Macros – Online

Salient Features

  • Learn Excel VBA Coding from the comfort of your Home

  • High Quality Videos that you can download

  • Entire Training in Marathi

  • Minimal Internet bandwidth and uninterrupted playback (as Videos are pre-loaded)

  • Unrestricted access for 15 Days

  • Videos for Advanced Excel also available

 

Demo : Simple macro to Add and Rename a new Sheet

 

Course Curriculum

Module 1 : Defining Excel VBA Macros

  • Overview of Macros

  • General Procedure for defining Excel VBA Macros

Module 2 : Manipulating Cells

  • Display Cell Value

  • Display Multiple Cells

  • Define Cell Value

  • Change Background Color

  • Specify Font Color, Size

  • Change Case

  • Set and Clear Cell

Module 3 : Dealing with Range of Cells

  • Copy Range of Cells

  • Copy Range with Formula on different Sheet

Module 4 : Editing Sheets

  • Rename Active Sheet

  • Rename any Sheet

  • Add, Rename Sheet

  • Delete Sheet

  • Change Sheet tab Color

Module 5 : Using Columns and Rows

  • Hide / Unhide Columns

  • Hide / Unhide Rows

  • Insert / Delete Columns

  • Insert / Delete Rows

  • Change Default Column Width

  • Change Row Height

Module 6 : Advanced Macros

  • Search for required Name

  • Copy records for selected Name

  • Lookup

Duration : 15 Days

Fees : Rs. 500/-

Call 9920294574 to get Download Link