Course Macros MS Excel 2010 and 2007 English

Imprimer Retour

Goal

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.

Prerequisites

  • Advanced use of and experience in Excel

Content

  • 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)

Course Language

EN

Course material

  • Training material in supplement

 

Duration

1 day(s)

Our group lessons

Availability on request

General conditions of sales

If you have any difficulties with physical access or require any assistance please contact our teams.