Cours Macros MS Excel 2010 and 2007 English

Imprimer Retour

Objectif

Macros MS Excel 2010 and 2007 is a course that teaches you how to automate tasks in Microsoft Excel 2010 using Macros. This training allows you to get an overview of the VBA code generated by Macros.

Pré-requis

  • Advanced use of and experience in Excel

Contenu

  • Defining the security level of macros
  • Creating simple recorded macros
  • Reading and modifying the generated code
  • Deleting macros
  • Associating a macro to a button, a shape, a task bar
  • Using the Personal macros folder
  • Using help related to macros
  • Introduction to VBA code
  • Definition of objects, properties and methods
  • Objects in Excel VBA (Workbook, Worksheet et Range)

Langue du cours

EN

Support de cours

  • Training material in supplement

 

15.- CHF

Durée

1 jour(s)

Prix

650.- CHF

Nos cours collectifs

Aucune session programmée

Conditions générales de vente