Excel VBA (Visual Basic for Applications)

Course date: 10 May 2019 - 10 May 2019
Location: Erasmus MC, Ee 15.28

Click here to register for this course

Microsoft Office Excel  and VBA

This course, over the duration of five chapters, gives students the skills they need to harness Visual Basic for Applications, or VBA, to automate many tasks they encounter while using Excel.

Developing Macros

This lesson gets students right into the thick of developing macros for Excel. It shows how to create a macro using the Macro Recorder, how to edit a macro, and how to debug a macro. It also covers how to customize the Quick Access toolbar and hotkeys and looks at how to set macro security.

Formatting Worksheets Using Macros

Lesson two digs into the skills of worksheet formatting. Covered in this lesson is how to: insert text with a macro, format text with a macro, sort data with a macro, duplicate data with a macro, and generate a report with a macro.

Creating an Interactive Worksheet

The third of five lessons in this course covers interactive worksheets. Up for consideration here are the topics of how to determine the appropriate dialog box types to use and how to capture user input using a variety of techniques.

Working with Multiple Worksheets

The topics of this lesson are how to: insert, copy, and delete worksheets using macros, rename worksheets using macros, modify the order of worksheets using macros, and print worksheets using macros.

Performing Calculations

The final lesson of this course covers how to create user-defined functions in macros and how to automate SUM functions with a macro.

General information
Financial regulation of the Postgraduate School MolMed

From January 1st, 2019 the following financial rules apply, but they may differ per course still. Look at the course fee of each course to be sure which discounts are really applied:

Non-commercial course, symposium or workshop fee: €200/day, €350/2days, €750/week.

• Participants of the postgraduate school MolMed: discount of 100%

• However, the Research Management course and the workshops Photoshop/Illustrator/Indesign have to be paid from the ‘personal budget’ of employees, MolMed members and PhD students included. So they will receive an invoice from us which you have to pay and which will be reimbursed by your Department. When you will pay from your personal budget you need to provide us your home address details for the invoice

• PhD students and Master’s students, regardless of institution: discount of 50%.

  • The course fees of research master’s students will be paid by their master program at rate of €100/ECTS. For not I&I master students: please inform your master program in advance whether they agree to pay.
  • Master’s students who are paying the fee from their private budget: discount of 75%. When you will pay from your personal budget you need to provide us your home address details for the invoice.
  • However, 2 courses in statistics are paid centrally by the Dept. of Research policy for all PhD students from Erasmus MC! These are R and the SPSS course. So for Erasmus MC PhD students, these courses are always free, provided you are officially registered as a PhD student.

There is one fee for the entire course. There is no reduction for partial participation.

Some courses have less course days: SPSS 3 days, Survival Analysis 2 days, Management 2 days, Presenting 1,5 days and also other may be shorter as indicated on the website.

Commercial participants, companies & sponsors are invited to inquire about commercial tuition fees and about sponsoring.

All invoices will be sent by email to the mail address that you filled in upon registration. If this address is not correct we use your Erasmus MC address.

Those who register for a course, symposium or workshop agree with these financial conditions.

Click here to register for this course

Click here for the other items