Molecular Medicine Post Graduate School

Nb. This course will be given online via Microsoft Teams.

Workshop Microsoft Excel 2016: 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.

Carlo v.d. Zon, Access It Trainingen

Date, Time & Location

T.b.a.
09.30 - 17.00
Online Teams

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.

(other Erasmus MC schools)

(non-Erasmus MC schools)


			Workshop Microsoft Excel 2016: Advanced, Online Course Location: Online Teams Click here for details of programme Nb. This course will be given online via Microsoft Teams. 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 T.b.a. 09.30 - 17.00 Online Teams 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