<Excel Macro Training in Hyderabad - Ecorptrainings

Mail : training@ecorptrainings.com
India : +91-8143-111-555
USA : +1-703-445-4802
Whats app : +91-8143-110-555
Facebook Twitter Google Plus Pinit Stumbleupon Youtube Blog

Workday HCM Demo New Batches Starting from Wednesday... 14-12-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 14th DEC & 15th DEC.

Hadoop Dev New Batch Start From 15th DEC & 16th DEC.

IBM COGNOS TM New Batch Start From 16th DEC & 17th DEC.

Informatica Dev New Batch Start From 17th DEC & 18th DEC.

Mean Stack New Batch Start 18th DEC & 19th DEC.

SAP BODS new Batch Starting From 19th DEC & 20th DEC.

SAP S/4 HANA New Batch Start From 20th DEC & 21st DEC

Tableau New Batch Start From 21st DEC & 22nd DEC


(1) Workday Technical Demo Training

Demo Schedule : 09:30A.M EST / 08:30A.M CST / 6:30A.M PST on 13th DEC & 07:00A.M IST on 14th DEC

Email :
Rediff Bol :
Google Talk :
MSN Messenger :
Yahoo Messenger :
Skype Talk :