Train together, save more! 10% off individual registration, 20% off for pairs.
×
Log in
Or create your account
You have just added to your selection
Your cart is empty, See our trainings

Description

The spreadsheet's functionalities do not allow you to solve overly complex processes or automate all repetitive tasks. It is then necessary to use macro commands, i.e. programming in Visual Basic for Application (VBA). This training provides the basics for building reliable and efficient macros in Excel.

Who is this training for ?

For whom ?

Any Excel user (versions 2010, 2013 and 2016).

Prerequisites

Have completed the training or have an equivalent level of knowledge.
It is not necessary to have previous experience with a programming language.

Training objectives

  • Automate tables, calculations or data processing in Excel.
  • Master the basics of programming in VBA.
  • Record, modify and write VBA macros.
  • Training program

      • Use the macro recorder.
      • Edit a recorded macro.
      • Assign a macro to a button or object.
      • Create a macro accessible from all workbooks
      • Write a macro directly in the Visual Basic editor.
      • Integrate the notion of objects, methods and properties.
      • Declare and use variables to optimize the code.
      • Manage the cursor: position, movement, dynamic selection.
      • Manipulate sheets, workbooks by macro.
      • Transfer data from a sheet. in another.
      • Create interactive macros: Inputbox, Msgbox.
      • Perform tests: If... Then... Else, Select Case.
      • Handle errors: On Error. Freeze the screen, deactivate Excel alert messages.
      • Automatically trigger macros when opening a workbook, when closing it.
      • Define simple event macros.
      • Master the database to program it.
      • Extraction macros: use advanced filters to query and extract on multiple criteria.
      • Consolidation macros: consolidate data from multiple workbooks.
      • Create a custom form (UserForm) with input boxes, drop-down lists, radio buttons, check boxes
      • Control data by. macro and transfer them to the spreadsheet
      • Execute step by step, set breakpoints.
      • Check the variables, add spies.
      • Evaluation of the transfer of acquired knowledge to validate the setting implemented in a work situation
    • 2331
    • 21 h

    Submit your review

    Translated By Google Translate