Description

Who is this training for ?

For whom ?

Prerequisites

Training objectives

Acquire the fundamentals of programming

Know how to develop and maintain personalized solutions independently

Training program

• Reminders in Excel
  • - Main functions of Excel
  • - Absolute and relative references
• Discovery of the programming environment
  • - Introducing and customizing the Visual Basic editor
  • - Record a macro
• VBA programming
  • - Excel Object Model
  • - Variables, Data Types, and Constants
  • - Conditional Statements
  • - Loops
  • - Dialog boxes
  • - Error handling
• Programming techniques
  • - External data import
  • - Data tables
  • - Statistical analysis/solver
  • - Graph generation
  • - Good programming practices