Microsoft Excel for biomedical data analysis

Objectives

This course aims to provide trainees with a tool for universal use, thus diversifying the training offer and qualifying them according to the demands of the current job market, both at a business and academic level.

At the end of the Microsoft Excel course applied to the treatment of biomedical data, trainees should be able to:
  • Organize data in spreadsheets.
  • Perform descriptive data analysis.
  • Systematize the results in appropriate tables and graphs.

Teaching staff

Andreia Teixeira
Luísa Guedes

Who is this programme for?

Excel users interested in exploring the advanced features of this tool.

Delivery Mode

Presential classes.
Working language: English

Application

Fees

105€ + 2€ (student insurance)

Collaborators and researchers from MEDCIDS – Department of Community Medicine, Information and Decision in Health or from CINTESIS – Center for Research in Health Technologies and Services, with connection to MEDCIDS – Free.
Exemption from fees requires the authorization of MEDCIDS Director / CINTESIS Principal Investigator, up to a limit of 7 trainees.

Vacancies

30

Application deadline

19 January 2024
Instructions here.

Curricular Structure

Credits

1,5 ECTS

 Duration

9h

Schedule

Wednesday 7 February 2024, 14h00 – 18h30(WET)

Friday 9 February 2024, 14h00 – 18h30(WET)

Syllabus

  1. Fundamental concepts
    General overview of the Microsoft Excel
  2. Formulas
    References
    Functions
  3. Management and data analysis
    Filters
    Data sorting
    Pivot tables and pivot graphics
  4. Pratical exercises