Excel training (Microsoft Office)

Excel training program (VBA)

Woospeak, language and office training center since 2006 , offers you its expertise for your Microsoft Excel office training . Our experienced trainers will help you improve and master the Microsoft Office suite Excel software. .

Goal: Perfect your skills on Excel software (Microsoft Office suite).
Discovery or recall of the VBA environment.
Deepen and consolidate my mastery of VBA (Visual Basic Application) in order to develop more personalized projects.
Method: Face to face, telephone, videoconference, e-learning
Prerequisites: I often use Excel and I know the advanced features.
Public: Anyone with good knowledge of Excel software
Duration: 2, 4, 6, 8, 10 hours ... adjustable duration as needed
Possible certifications: TOSA, B2i, PCIE, ENI

The objectives of your Microsoft Excel training

Our Excel training is one of our training courses in our office catalog. It will help you to master all the features of Excel software . This training will allow you among other things: to improve your skills on Excel software, to discover or give a reminder of the VBA environment, to deepen and consolidate my mastery of VBA (Visual Basic Application) in order to develop more projects customized.
Whatever your basic level, our tailor-made training programs are fully adapted to help you progress.

The program of your Excel training (VBA)

The content of the Excel training program is organized into 3 major areas, and will be adapted according to your objectives and your needs:


Module 1: Discovery of the VBA environment:

  • Intervene in the code.
  • The project explorer (management of modules and procedures).
  • Write a macro in the Visual Basic editor.
  • Understand the concept of object, object collections.
  • Identify the main methods and properties.
  • Set up interactive macros: Inputbox, Msgbox.
  • Use variables to optimize the code.
  • Manage the cell pointer: position, movement, selection of a field.

Module 2: VBA Programming

  • Define dynamic selection areas.
  • Handle sheets, binders.
  • Transfer data from one sheet to another for macro.
  • Write formulas by macro.
  • Apply tests: If ... Then ... Else, Select Case.
  • Create loops: Do While, For Each.
  • Handle errors: On Error.
  • Freeze the screen, deactivate alert messages.
  • Use the With ... EndWith statement.
  • Manage a database.
  • Extraction macros: use the filters developed to query and extract on multiple criteria.
  • Consolidation macros: consolidate data from several databases.
  • Automatically trigger procedures: when a workbook is opened, when it is closed (Workbook Beforeclose).

Module 3: Data entry, research and calculation forms

  • Create a custom form (UserForm) containing edit boxes, drop-down lists, option buttons, check boxes, etc.
  • Check the data by macro and transfer it to the spreadsheet.
  • Do While (Until) Loop type loops.
  • Offset () method.
  • Function () type procedures.

Practical work & learning control

If you wish, we can also offer you an office certification such as TOSA. This Excel training is eligible for the CPF (Personal Training Account) .


Excel VBA training program

Microsoft Excel in video training, by phone or face to face

As a specialized training organization, Woospeak offers you different training methods:

This Excel training can take place at home or within your company.

DISCOVER ALL OURTRAINING METHODS

We organize training sessions wherever you are and everywhere in France

Want to know more ? Please do not hesitate to contact us with any questions.
You can also ask us for a quote on your Excel training. .