Courses

Microsoft Excel - Data management

Types
Staff IRBLleida
Date of registration period
Start date
Wednesday, April 12, 2023
End date
Thursday, May 04, 2023
  • Registration: pending.
  • Public: pre-doctoral research staff (30 places).
  • Institution of origin: all seconded staff.
  • Duration: 20 hours.
  • Timetable: 15.30-17.30.
  • Calendar: 12, 13, 17, 19, 20, 24, 26 and 27 April and 2 and 4 May.
  • Lecturer: Núria Sans, computer engineer at the Arnau de Vilanova University Hospital in Lleida.
  • Location: classrooms 2.24 (teaching building), 1.02 HUAV building and 3.05 HUAV building.
    • 2.24: 12, 13, 17, 19, 20 and 27 April and 2 May.
      1.02: 24, 26 April and 4 May.
  • 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.