Change font size

Increase size Decrease size Revert styles to default

AJP IT Services

Training Menu

Subscribe to Newsletter



Mail Format:


Microsoft Office Excel Macros PDF Print E-mail

Course Objectives

 

This half day course will give delegates an introduction to Excel macros and continue on to the more advanced features of macros. By the end of the course, delegates should be able to write and edit their own macros with confidence.

 

Who Should Attend?

 

Those who have used Excel's advanced facilities and require a more in-depth knowledge of macros. Previous experience of using Excel at an advanced level will be assumed.

 

Course Content

 

Recording, running and editing a macro.

Using Input Boxes.

Using Message Boxes.

Using the If Then Control Structure.

Using For Next loops.

Using Do While and Do Until loops.

Using Dialog Boxes.

  • userforms
  • textboxes, labels and command buttons
  • comboboxes
  • optionbuttons