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