Automation with recorded macros

Formation MS Office Excel - Automation with recorded macros in Geneva, Zurich, Huston, San-Antonio, Dallas, Los Angeles, San Diego, New York, Washington, Chicago, San Francisco and anywhere in Switzerland, USA, Great Britain and Germany.

425.-/d

ID : 254

Goal : Learn the procedures to automate simple repetitive taks in MS Excel with recorded macros. The main objective of this training is to get prepared to the VBA training (automate without the macro limitations)

Audience : Attendees wishing to automate basic tasks or learn VBA in MS Excel.

Prerequisites : Excellent knowledge and great experience in all basic tools of MS Excel or knowledge in all previous workshops

Goals :

- Introduction

- Macro security level definition

- Goals and limits of recorded macros (don't record everything, doesn't work in Office 365, doesn't work in shared workbooks, etc.)

- Compatibility issues

- Recording basic absolute and relative macros

- Copy/Delete a macro

- Read and modify self generated code by recording and deleting macros

- User interface creation to run macros with buttons, auto shapes and toolbars

- Creation of personal macros

- Auto_Open and Auto_Close macros (events macros) creation

- Developing MS Excel Add-In with recorded macros (*.xla)

- Creation of digital certificates for VBA projects

- Training Conclusion

Pedagogical method : Trianing course based on trainer's exemples

Suggested duration for presentiel training (days) : 1.5

Suggested duration for on-line training (days) : 1.8

Daily price in face-to-face : 425 CHF

Daily price in remote : 204 CHF

Daily price in remote for students : contact us (only if student card!)

Daily price in remote (with recording) : 2125 CHF

Prices are per day per trainee without course material, without certificate, without evaluation, without exam, without training room or computer (these are each optional and must be requested in addition in the contact form for the establishment of the quote).

Book

- Title : MS Excel 2007 - Worksheet Macros & Forms

- Author(s) :

- Pages : 8

- ISBN : B002JWG4G6

Tags : excel, macros, automation, tasks, security, excel training, excel course, ms excel training, ms excel course.

Contents