<Excel Macro Training in Hyderabad - Ecorptrainings

Workday HCM Demo New Batches Starting from Tuesday... 01-11-2016
Search Course Here

Live Chat
MS Excel Macros Online Training

MS Excel Macros


Macro is a collection of commands that you can apply with a single click.A macro is a recording of each command and action you perform to complete a task. Then, whenever you need to carry out that task in a spreadsheet, you just run the macro instead.A macro can be defined as the recording of a series of tasks. It's the simplest form of automation – show a software program the steps you follow to get something done, and the software will follow along. When used right, macros can save you hours by automating simple, repetitive tasks.


  • Experienced Microsoft Office Excel 2010 users who want detailed instruction on creating and using VBA macros.


  • It is a 8 days program and extends up to 2hrs each.
  • The format is 40% theory, 60% Hands-on.

  • It is a 2 days program and extends up to 8hrs each.
  • The format is 40% theory, 60% Hands-on.
    Private Classroom arranged on request and minimum attendies for batch is 4.

course content

  • Building Solutions
    • Solution Concepts
    • Data Entry Concepts
    • Macro Concepts
    • Programming Concepts
  • Macro Basics
    • Planning Macros
    • Recording Macros
    • Executing Macros
    • Maintaining Macros
  • VBA Programming Basics
    • Understanding Objects
    • Using the Visual Basic Editor
    • Understanding VBA Code
    • Executing VBA Code
    • VBA Help Reference
  • VBA User Form Basics
    • Planning User Forms
    • Designing User Forms
  • Deployment Basics
    • Preparing for Deployment
    • Code Security
    • Adding Macros to the Quick Access Toolbar
    • Modifying Quick Access Toolbar Buttons
  • Customizing Macros
    • Prompting for User Input
    • Automating Data Entry
    • Recording Absolute vs. Relative References
    • Protecting VBA Source Code
  • Enhancing VBA Code
    • Writing Source Code
    • Variables and Constants
    • Writing Tips
    • Logical Operators
    • Flow Control
  • Handling Errors
    • Syntax Errors
    • Logical Errors
    • Run-Time Errors
  • Accessing External Data
    • External References
    • ActiveX Data Objects Concepts
    • Connecting to a Database
    • Retrieving Records from a Database
  • Excel Automation
    • Concepts
    • Working with Object Models
    • Excel's Object Model
    • Automating Excel with VBScript


MS Excel Macros Videos will be updated soon
To watch more Videos Click Here

Flash News

AngularJS New Batch Start From 28th OCT & 29th OCT.

Hadoop Dev New Batch Start From 29th OCT & 30th OCT.

IBM COGNOS TM New Batch Start From 30th OCT & 31th OCT.

Informatica Dev New Batch Start From 31th OCT & 01st Nov.

Mean Stack New Batch Start 01st Nov & 02nd Nov.

SAP BODS new Batch Starting From 02nd Nov & 03rd Nov.

SAP S/4 HANA New Batch Start From 03rd Nov & 04th Nov

Tableau New Batch Start From 04th Nov & 05th Nov


Workday HCM Demo Training

Demo Schedule : 09:30P.M EST / 08:30P.M CST / 06:30P.M PST on 31st OCT & 07:00A.M IST on 01st NOV
Email :
Rediff Bol :
Google Talk :
MSN Messenger :
Yahoo Messenger :
Skype Talk :