Consorcio Interuniversitario de Galicia

Consorcio para o desenvolvemento de aplicacións de xestión universitaria de Galicia

220038, OSL, Advanced Calc, Rafa
1ra Edición
LibreOffice Advanced Calc
Amtega, Nuevo


24 horas


Convenio Amtega


Persoal PAS, Persoal PDI














Datas, Horarios e Sesións

Data Inicio


Data Peche


Tipos Formación

Formación Online
Aula virtual (Webinars)

Datas e horarios

Martes, 09:00 a 10:00
Luns, 09:00 a 10:00

Número Webinars


Necesidades, prerrequisitos e inf. xeral

Necesidades a cubrir

Professional mastery of the spreadsheet requires a deeper understanding of the topics covered in an introductory Calc course, as well as acquiring new skills in data analysis tools and mastering the graphical tools offered by LibreOffice in all the programmes that make up the office suite.


Basic computer skills. Essential spreadsheet operation, knowledge of the working environment, basic functions, references, editing and cell formatting.


Online training through the CIXUG Virtual Classroom:

Medios necesarios

A computer with Internet access. Installation of LibreOffice Calc.

Datos persoal Formador e Titor

Persoal formador

Rafael Rodríguez Gayoso

Empresa contratada




To improve the mastery of the spreadsheet, this course focuses on the management of styles and their application or better development of the most frequently used functions. That will help us improve our daily results when using a LibreOffice Calc spreadsheet.

Competencias a desenvolver

  • Defining and modifying cell styles to apply to format elegantly and productively.
  • Comprehensive mastery of the approach and use of cell range names.
  • How to find the Calc function thanks to the Function Assistant, and a walkthrough of different functions for adding and counting, manipulating text or dates, finding values within data tables and applying logic to display alternative results in cells.
  • The intense practice of nesting functions allows the combined use of different functions within the same formula.
  • Master conditional formatting to highlight sets of cells that meet specific criteria and improve the presentation of certain values with the automated use of icons, data bar, and colour scale.
  • The planning of data projections using the solver and the search for the target value.
  • Thorough knowledge of pivot tables to analyse and summarise large amounts of data.
  • Mastering the different levels of document protection.


Online training - Monitored access to theoretical content and practical labs. The labs can be viewed through recorded sessions and replicated by participants on their computers.
To access the contents, participants must have a web browser and an Internet connection. To deliver the exercises, it is necessary to have access to an installation of LibreOffice Calc, version 6.3 or higher. In addition, it is advisable to have the interface configured in the Galician language.

There will be four voluntary videoconferences of approximately 1 hour's duration, through the Zoom platform, in which doubts will be raised and solved and other aspects and dynamics.


1. Working with styles

2. Advanced formulation

  • Using wizards
  • COUNT and ADD functions
  • Calculation functions with dates
  • Text functions
  • SE function
  • PROCV function
  • Mixed references

3. Conditional formatting

  • Cell styles
  • Icons, data bars and colour scale
  • Based on formulas

4. Pivot tables

  • Creating pivot tables
  • Modifying pivot tables
  • Grouping data in pivot tables

5. Protecting documents

6. Working with hypotheses

Scroll to Top