ms excel macros training

MS Excel macros Training course introduction:

MS Excel macros Training on creating will help the trainee to learn how to record a macro, make slight changes on it and also save it to your personal macro workbook so that you can use it later in any workbook on your personal computer or any suitable devices, and even assign a button so you can run it by single click. By enrolling with Global Online Training you will get to learn the features of the course that are given in detailed by step-by-step practice session with examples which will help you to use  Excel 2010  by your own under supervision of subject matter experts.

Ms excel macros training Course prerequisites:

The trainee need not be a Excel expert just an average excel knowledge will be enough to go though the course.

Ms Excel Macros Course Content

Build the Solutions
  • Solution Concepts
  • Data Entry Concepts
  • Macro Concepts
  • Programming Concepts
Macro Basics
  • Planning Macros
  • Recording Macros
  • Executing Macros
  • Maintaining Macros
Basics of the VBA Programming
  • Understanding the Objects
  • Using the Visual Basic Editor
  • Understanding VBA Code
  • Executing VBA Code
  • VBA Help Reference
VBA Userform Basics
  • Planning User Forms
  • Designing the User Forms
Deployment Basics
  • Preparing for the Deployment
  • Code Security
  • Adding Macros to the Quick Access Toolbar
  • Modifying Quick Access Toolbar Buttons
Customizing Macros
  • Prompting for the User Input
  • Automating Data Entry
  • Recording Absolute vs. Relative References
  • Protecting VBA Source Code
Enhancing VBA Code
  • Writing Source Code
  • Variables & 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 the VBScript