Workshop on Microsoft Excel 2010: Advanced

Course date: 25 September 2014 - 25 September 2014
Location: Erasmus MC, Ee-15.28

This course is fully booked! You can still register, but will be placed on a waiting list.



The Erasmus Postgraduate School Molecular Medicine has two main activities: the organization of education for postgraduate students; and the stimulation of cooperation between several departments with regards to translational research.

Trajectory of four workshops

Together with Access It Training we organize four workshops on: Access (basic and advanced) and on Excel (basic and advance).
These workshops follow each other in evolutionary fashion:

  • With Microsoft Access you will to set up and manage a database.
  • With Microsoft Excel you will learn to use this database for functions and formulas.

Workshop on Microsoft Excel 2012: Advanced

On 25 September 2014 we will organize the advanced workshop on Microsoft Excel 2010.

Time: 9.30 - 17.00
Location: Computerroom at the Bioinformatics dept., Ee-1528.
Maximum no. of participants: 9

Teacher: Carlo v.d. Zon, Access It Trainingen

Detailed program

Course Objective: You will use advanced formulas and work with various tools to analyze data in spreadsheets. You will also organize table data, and enhance the look and appeal of workbooks. Enhancing productivity and efficiency by streamlining the workflow with an introduction into Macro’s.

Target Student: This course is meant for those desiring to gain advanced skill sets necessary for calculating data using functions and formulas, using PivotTables for analyzing data, and customizing workbooks.

Course Objectives

Upon successful completion of this course, students will be able to:

  • Use advanced formulas. (Like Vlookup, sumif(s), text, financial, date and error functions,etc)
  • Organize worksheet and table data using various techniques. Tips and trics
  • Customize and enhance workbooks (validation, conditional formatting)
  • Analyze data using PivotTables, Slicers
  • Create and use simple Macro’s (without VBA)

Registration fee

The subscription fee of non-commercial participants for the Course is € 150. Discounts are handled as followed:

  • PhD students get a discount of 50% and pay €75.
  • Only participants from the postgraduate school MolMed get a discount of 100% and pay €0.
  • Other Erasmus MC participants, like Nihes and MGC members and master students from elsewhere get a discount of 50% and pay €75.
  • Master students from elsewhere who pay the fee from their personal budget get a discount of 75% and pay €50.

General information
Financial regulation of the Postgraduate School Molmed

From August 1st, 2012 the following financial rules apply:

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

• Participants of the postgraduate school MolMed: discount of 100%.
• Other Erasmus MC participants, e.g. of MGC, COEUR, NIHES: discount of 50%.
• PhD students and Master’s students, regardless of institution: discount of 50%.
• Master’s students who are paying the fee from their personal budget: discount of 75%.

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

The SPSS Course and the R Course have shorter course days. The SPSS Course counts as a 2-days course and the R Course as a 3-days course.

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

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


This course is fully booked! You can still register, but will be placed on a waiting list.




Click here for the other items