<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
Support
MS Excel Macros Online Training

MS Excel Macros



overview


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.

prerequisties

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

Duration

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

Corporate
  • It is a 2 days program and extends up to 8hrs each.
  • The format is 40% theory, 60% Hands-on.
Classroom
    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

Videos


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

Flash News


AngularJS New Batch Start From 09th DEC & 10th DEC.


Hadoop Dev New Batch Start From 10th DEC & 11th DEC.


IBM COGNOS TM New Batch Start From 11th DEC & 12th DEC.


Informatica Dev New Batch Start From 12th DEC & 13th DEC.


Mean Stack New Batch Start 13th DEC & 14th DEC.

SAP BODS new Batch Starting From 14th DEC & 15th DEC.

SAP S/4 HANA New Batch Start From 15th DEC & 16th DEC
.

Tableau New Batch Start From 16th DEC & 17th DEC

PUBLIC DEMO


(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

SOLVE YOUR QUERIES ONLINE
Email :
Rediff Bol :
ecorptrainings@rediffmail.com
Google Talk :
ecorptrainings@gmail.com
MSN Messenger :
ecorptrainings@hotmail.com
Yahoo Messenger :
ecorptrainings@yahoo.com
Skype Talk :
ecorptrainings