Training agenda
  1. Introduction
    • Quick revision of configuring working environment of Microsoft Excel developer
    • Good practice of programming – structure of the application
  2. Quick revision of issues related to declaring variables (forcing declaration)
    • Advantages and disadvantages of modular and global declarations
    • The range of procedures and functions
    • Benefits of parameter transfer
    • Advantages of constants
    • Most important conditional constructions
    • Most important types of loops
  3. Tracking the execution (deleting errors)
    • Direct instruction window
    • Detector window
    • Interruption points
    • Tabs and other ways of navigation in bigger applications’ code
    • Troubleshooting
  4. Tables
    • one-dimensional
    • multi-dimensional
    • dynamic.
  5. Manipulating Microsoft Excel objects from VBA level
    • Microsoft Excel object library
    • different ways to learn the objects
    • examples of using Microsoft Excel most important object:
  6. Event procedures
    • of folder and worksheet
    • of a form
    • of application.
  7. Forms
  8. Creating your own applications
    • automatic data import, completion
    • creating the application automating mail sending
    • managing data, worksheets, folders from VBA level