Menú Datos

From the menu bar:

Choose Data - Text to Columns.

From the tabbed interface:

Choose Data - Text to Columns.

On the Data menu of the Data tab, choose Text to Columns.

From toolbars:

Text to Columns

From the menu bar:

Escolla Datos - Definir intervalo.

From the tabbed interface:

Choose Data - Define Range.

On the Data menu of the Data tab, choose Define Range.

From toolbars:

Define Range

From the menu bar:

Escolla Datos - Seleccionar intervalo.

From the tabbed interface:

Choose Data - Select Range.

On the Data menu of the Data tab, choose Select Range.

From toolbars:

Select Range

From the menu bar:

Escolla Datos - Ordenar....

From the tabbed interface:

Choose Data - Sort.

On the Data menu of the Data tab, choose Sort.

From toolbars:

Sort

From the menu bar:

Choose Data - Duplicates....

From the tabbed interface:

Escolla Datos - Duplicados.

From the menu bar:

Escolla Datos - Orde ascendente

From the tabbed interface:

Escolla Datos - Orde ascendente.

No menú Datos da lapela datos escolla Orde ascendente.

From toolbars:

Orde ascendente

From the menu bar:

Escolla Datos - Orde descendente

From the tabbed interface:

Escolla Datos - Orde descendente.

No menú Datos da lapela Datos escolla Orde descendente.

From toolbars:

Orde descendente

Escolla a lapela Datos - Ordenar - Criterios de ordenación.

Na barra Estándar prema en

Orde ascendente

Orde descendente

Escolla a lapela Datos - Ordenar - Opcións.

From the menu bar:

Escolla Datos - Máis filtros.

From the menu bar:

Escolla Datos - Filtro automático.

From the tabbed interface:

Escolla Datos - Filtro automático.

No menú datos da lapela Datos escolla Filtro automático.

From toolbars:

Filtro automático

From the keyboard:

+ Shift + L

From the menu bar:

Escolla Datos - Máis filtros - Filtro avanzado....

From the tabbed interface:

Escolla Datos - Filtro avanzado.

No menú Datos da lapela Datos escolla Filtro avanzado.

From toolbars:

Filtro avanzado

Escolla Datos - Máis filtros - Filtro estándar... - Opcións.

Escolla Datos - Máis filtros - Filtro avanzado... - Opcións.

From the menu bar:

Escolla Datos - Máis filtros - Restaurar filtro.

From the tabbed interface:

On the Data menu of the Data tab, choose Reset Filter.

From the menu bar:

Choose Data - More Filters - Hide AutoFilter.

From the tabbed interface:

Choose Data - Hide AutoFilter.

On the Data menu of the Data tab, choose Hide AutoFilter.

From toolbars:

Hide AutoFilter

From the menu bar:

Escolla Datos - Subtotais.

From the tabbed interface:

Choose Data - Subtotals.

On the Data menu of the Data tab, choose Subtotals.

From toolbars:

Subtotals

From the menu bar:

Escolla as lapelas Datos - Subtotais - 1º, 2º, 3º Grupo.

From the tabbed interface:

On the Data menu of the Data tab, choose Subtotals - 1st, 2nd or 3rd Group tabs.

From the menu bar:

Escolla a lapela Datos - Subtotais - Opcións.

From the tabbed interface:

On the Data menu of the Data tab, choose Subtotals - Options tab.

From the menu bar:

Escolla Datos - Validación.

From the tabbed interface:

Choose Data - Validity.

On the Data menu of the Data tab, choose Validity.

From toolbars:

Data Validity

From the menu bar:

Menú Datos - Validación - Criterios.

From the tabbed interface:

On the Data menu of the Data tab, choose Validity - Criteria tab.

From the menu bar:

Escolla a lapela Datos - Validación - Axuda coa introdución de datos.

From the tabbed interface:

No menú Datos da lapela datos escolla a lapela Validación - Axuda coa introdución de datos.

From the menu bar:

Escolla a lapela Datos - Validación - Alerta de erro.

From the tabbed interface:

No menú datos da lapela datos escolla a lapela Validación - Alerta de erro.

From the menu bar:

Escolla Datos - Operacións múltiplas.

From the tabbed interface:

No menú Datos da lapela Datos escolla Opercións múltiplas.

From the menu bar:

Escolla Datos - Consolidar.

From the tabbed interface:

Escolla Datos - Consolidar.

No menú Datos da lapela Datos escolla Consolidar.

From toolbars:

Consolidar

From the menu bar:

Escolla Datos - Grupo e esquema.

From the menu bar:

EscollaDatos - Agrupar e esquematizar - Mostrar detalles.

From the tabbed interface:

Escolla Datos - Mostrar detalles.

No menú Datos da lapela Datos escolla Mostrar detalles.

From toolbars:

Mostrar detalles

From the menu bar:

Escolla Datos - Grupo e esquema - Agochar detalles.

From the tabbed interface:

Escolla Datos - Agochar detalles.

No menú Datos da lapela Datos escolla Agochar detalles.

From toolbars:

Agochar detalles

From the menu bar:

Escolla Datos - Grupo e esquema - Agrupar.

From the tabbed interface:

Escolla Datos - Agrupar.

No menú Datos da lapela Datos escolla Agrupar.

From toolbars:

Agrupar

From the keyboard:

F12

From the menu bar:

Escolla Datos - Grupo e esquema - Desagrupar.

From the tabbed interface:

Escolla Datos - Desagrupar.

No menú Datos da lapela Datos escolla Desagrupar.

From toolbars:

Desagrupar

From the keyboard:

+ F12

From the menu bar:

Escolla Datos - Grupo e esquema - Esquema automático.

From the tabbed interface:

No menú Datos da lapela Datos escolla Esquema automático.

From toolbars:

Esquema automático

From the menu bar:

Escolla Datos - Agrupar e esquematizar - Retirar esquema.

From the tabbed interface:

On the Data menu of the Data tab, choose Remove Outline.

Escolla Datos - Agrupar e esquematizar - Mostrar detalles (nalgunhas táboas dinámicas).

From the menu bar:

Escolla Datos - Táboa dinámica.

From the menu bar:

Escolla Inserir - Táboa dinámica.

Choose Data - Pivot Table - Insert or Edit.

From the tabbed interface:

Choose Insert - Pivot Table.

Choose Data - Pivot Table.

On the Data menu of the Data tab, choose Insert or Edit Pivot Table.

From toolbars:

Pivot Table

Escolla Inserir - Táboa dinámica e na caixa de diálogo Seleccionar fonte escolla a opción Fonte de datos rexistrada en LibreOffice.

From the menu bar:

Choose Insert - Pivot Table, in the Select Source dialog choose the option Current selection or Named Range in the drop-down list.

Escolla Inserir - Táboa dinámica e na caixa de diálogo Seleccionar fonte escolla a opción Fonte de datos rexistrada en LibreOffice, e prema en Aceptar para ver a caixa de diálogo Seleccionar fonte de datos.

From the tabbed interface:

Place the cursor inside the pivot table and select Data - Pivot Table.

From the context menu:

Place the cursor inside the pivot table and select Properties.

From toolbars:

Pivot Table

From the menu bar:

Escolla Datos - Táboa dinámica - Actualizar.

From the tabbed interface:

Choose Data - Refresh Pivot Table.

On the Data menu of the Data tab, choose Refresh.

From the context menu:

Choose Refresh.

From toolbars:

Refresh Pivot Table

From the menu bar:

Escolla Datos - Táboa dinámica - Eliminar.

From the tabbed interface:

Choose Data - Delete Pivot Table.

On the Data menu of the Data tab, choose Delete.

From the context menu:

Choose Delete.

From toolbars:

Delete Pivot Table

From the menu bar:

Escolla Datos - Actualizar intervalo.

From the tabbed interface:

Choose Data - Refresh Range.

On the Data menu of the Data tab, choose Refresh Range.

From toolbars:

Refresh Range

With cursor placed in a pivot table:

From the menu bar:

Choose Data - Group and Outline - Group.

From the tabbed interface:

Choose Data - Group

On the Data menu of the Data tab, choose Group

From toolbars:

Group

From the keyboard:

F12

From the menu bar:

Choose Data - Calculate - Recalculate hard.

From the keyboard:

+ Shift + F9

From the menu bar:

Choose Data - Calculate - Recalculate.

From the tabbed interface:

Choose Data - Recalculate.

On the Data menu of the Data tab, choose Recalculate.

From toolbars:

Recalculate

From the keyboard:

From the menu bar:

Choose Data - Calculate - Formula to Value.

From the menu bar:

Choose Data - Calculate - AutoCalculate.

From the menu bar:

Choose Data - Calculate

From the menu bar:

Choose Data – Form...

From the tabbed interface:

On the Data menu of the Data tab, choose Form.

From the menu bar:

Choose Data – Streams

From the tabbed interface:

Choose Data - Streams.

On the Data menu of the Data tab, choose Streams.

From toolbars:

Streams

From the menu bar:

Choose Data - XML Source.

From the tabbed interface:

Choose Data - XML Source.

From toolbars:

XML Source

From the menu bar:

Choose Data - Statistics.

From the tabbed interface:

Choose Data - Statistics.

On the Data menu of the Data tab, choose Statistics.

From toolbars:

Statistics

From the menu bar:

Choose Data - Statistics - Sampling

From the tabbed interface:

Choose Data - Statistics - Sampling.

On the Data menu of the Data tab, choose Statistics - Sampling.

From the menu bar:

Choose Data - Statistics - Descriptive Statistics

From the tabbed interface:

Choose Data - Statistics - Descriptive Statistics.

On the Data menu of the Data tab, choose Statistics - Descriptive Statistics.

From the menu bar:

Choose Data - Statistics - Analysis of Variance (ANOVA)

From the tabbed interface:

Choose Data - Statistics - Analysis of Variance (ANOVA).

On the Data menu of the Data tab, choose Statistics - Analysis of Variance (ANOVA).

From the menu bar:

Choose Data - Statistics - Correlation

From the tabbed interface:

Choose Data - Statistics - Correlation.

On the Data menu of the Data tab, choose Statistics - Correlation.

From the menu bar:

Choose Data - Statistics - Covariance

From the tabbed interface:

Choose Data - Statistics - Covariance.

On the Data menu of the Data tab, choose Statistics - Covariance.

From the menu bar:

Choose Data - Statistics - Exponential Smoothing

From the tabbed interface:

Choose Data - Statistics - Exponential Smoothing.

On the Data menu of the Data tab, choose Statistics - Exponential Smoothing.

From the menu bar:

Choose Data - Statistics - Moving Average

From the tabbed interface:

Choose Data - Statistics - Moving Average.

On the Data menu of the Data tab, choose Statistics - Moving Average.

From the menu bar:

Choose Data - Statistics - Regression

From the tabbed interface:

Choose Data - Statistics - Regression.

On the Data menu of the Data tab, choose Statistics - Regression.

From the menu bar:

Choose Data - Statistics - Paired t-test

From the tabbed interface:

Choose Data - Statistics - Paired t-test.

On the Data menu of the Data tab, choose Statistics - Paired t-test.

From the menu bar:

Choose Data - Statistics - F-test

From the tabbed interface:

Choose Data - Statistics - F-test.

On the Data menu of the Data tab, choose Statistics - F-test.

From the menu bar:

Choose Data - Statistics - Z-test

From the tabbed interface:

Choose Data - Statistics - Z-test.

On the Data menu of the Data tab, choose Statistics - Z-test.

From the menu bar:

Choose Data - Statistics - Chi-square Test

From the tabbed interface:

Choose Data - Statistics - Chi-square Test.

On the Data menu of the Data tab, choose Statistics - Chi-square Test.

From the menu bar:

Choose Data - Statistics - Fourier Analysis

From the tabbed interface:

Choose Data - Statistics - Fourier Analysis.

On the Data menu of the Data tab, choose Statistics - Fourier Analysis.