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