<Excel Macro Training in Hyderabad - Ecorptrainings

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

Workday HCM Demo New Batches Starting from Monday... 13-11-2017
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 Starting From 14th NOV & 15th NOV.

Hadoop Dev New Batch Starting From 15th NOV & 16th NOV.

IBM COGNOS TM New Batch Starting From 16th NOV & 17th NOV.

Informatica Dev New Batch Starting From 17th NOV & 18th NOV.

Mean Stack New Batch Starting From 18th NOV & 19th NOV.

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

SAP S/4 HANA New Batch Starting From 20th NOV & 21st NOV

Tableau New Batch Starting From 21st NOV & 22nd NOV


(1) Workday Technical Demo Training

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

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