Workshop Microsoft Excel 2010: Advanced


Location: Erasmus MC, Ee 15.28

Click here to register for this course

Course 
Workshop Microsoft Excel 2010: Advanced  
 
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.
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 Macro’s.
 

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) 

Audience and participation
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.


Teacher
Carlo v.d. Zon, Access It Trainingen

 
Date, Time & Location
T.b.c.
09.30 - 17.00
Computerroom at the Bioinformatics dept., Ee-1528.


ECTS
Full participation is  0,4 ECTS.

 
Maps
www.molmed.nl/maps/maps.asp

 
Course fees 
For non-commercial participants the course fee  €200/day
 
Discounts: 
PhD students get a 50% discount and pay €100/day. 
Participants from the postgraduate school MolMed get a 100% discount and pay €0.
Master students, get a 50% discount and pay €100/day. 
Master students who have to pay the fee from their personal budget get a 75% discount and pay €50/ day. 
If these financial requirements should pose a problem, please contact Frank van Vliet, managing director of the Erasmus Postgraduate School Mol Med, at: f.vanvliet@erasmusmc.nl


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, €750/week
• Participants of the postgraduate school MolMed: discount of 100%
• However, the Personal Leadership 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. 
If there is no personal budget left, the MM-members get a discount of 100%.
• 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.
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