Microsoft Excel - Data management

Staff IRBLleida
Date of registration period
Start date
Wednesday, May 08, 2024
End date
Wednesday, May 29, 2024
  • Registration
  • Public: pre-doctoral research staff (30 places).
  • Institution of origin: all seconded staff.
  • Duration: 20 hours.
  • Timetable: 15.30-17.30.
  • Calendar: 8, 9, 13, 15, 16, 20, 22, 23, 27 and 29 May.
  • Lecturer: Núria Sans, computer engineer at the Arnau de Vilanova University Hospital in Lleida.
  • Location: pending.
  • Requirements: to have one's own laptop computer.
  • Programme: the aim of the course is to teach students the capabilities of the Microsoft Excel application in terms of data analysis and processing and the use of functions, as a support for problem solving. The course will be of a purely practical nature. A series of problems will be posed and the most appropriate tools and strategies for their resolution will be sought. The contents of the course will focus on five topics:
    • 1. Quick review of basic knowledge.
    • 2. Simple and compound functions: mathematics, statistics, research…
    • 3. Tools for data processing: sorting, filtering…
    • 4. Pivot tables.
    • 5. Introduction to macros.