Workshop Microsoft Excel 2016: Advanced

Course date: 05 October 2021 - 05 October 2021
Location: Erasmus MC, Ee-15.28

Click here for details of programme


Nb. This course will be given Live.

 
Course 
Workshop Microsoft Excel 2016: Advanced  
 
Description 
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
5 October 2021
09.30 - 17.00
Ee-15.28


ECTS
Full participation is  0,4 ECTS.

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

 
Course fees:
If not otherwise indicated, Erasmus MC PhD courses are free for Erasmus MC PhD candidates and Research Master students who use them as electives. Erasmus MC employees pay €100/day. External PhD candidates pay €100/day. Commercial and other external participants pay €200/day. There is one fee for the entire course, there is no reduction for partial participation.

Cancellation policy:
Erasmus MC Graduate School charges a cancellation fee of €75 for all cancellations made more than 22 days before the start of the course. Fifty percent of the course fee, with a minimum of €75, is due for cancellations made between 21 and 10 days before the start date. The full course fee is due for cancellations made less than 10 days before the start date, or in case of no-show without cancellation. For Erasmus MC PhD candidates the full course fee in case of the cancellation policy will be the equivalent of the number of course days times €100. 



All invoices will be sent to the head of department or for external participants to the e-mail address provided upon registration. 

Those who register for a PhD course agree with these financial conditions.



Click here for details of programme


Click here for the other items