MS Forecaster Essentials  Training

MS Forecaster Essentials Course Content

Building the Solutions
  • Solution Concepts
  • Data Entry Concepts
  • Macro Concepts
  • Concepts  of the Programming
Macro Basics
  • Planning Macros
  • Recording Macros
  • Executing Macros
  • Maintaining Macros
Basics of the VBA Programming
  • Understanding Objects
  • Using the Visual Basic Editor
  • Understanding VBA Code
  • Executing VBA Code
  • VBA Help Reference
Basics of the VBA Userform
  • Planning User Forms
  • Designing 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 the Object Models
  • Excel’s Object Model
  • Automating Excel with the VBScript