Data Menu

Choose Data - Text to Columns

Choose Data - Define Range

Choose Data - Select Range

Choose Data - Sort...

Choose Data - Sort - Sort Criteria tab

рдорд╛рдирдХ рдкрдЯреНрдЯреА рдкрд░ рдХреНрд▓рд┐рдХ рдХрд░реЗрдВ

Icon

рдЖрд░реЛрд╣рдг рдХреНрд░рдо рдореЗрдВ рдЫрд╛рдБрдЯреЗрдВ

Icon

рдЕрд╡рд░реЛрд╣рдг рдХреНрд░рдо рдореЗрдВ рдЫрд╛рдБрдЯреЗрдВ

Choose Data - Sort - Options tab

Choose Data - Filter

Choose Data - AutoFilter

рдФрдЬрд╛рд░ рдкрдЯреНрдЯреА рдкрд░ рдпрд╛ рддрд╛рд▓рд┐рдХрд╛ рдбрд╛рдЯрд╛ рдкрдЯреНрдЯреА рдкрд░ рдХреНрд▓рд┐рдХ рдХрд░реЗрдВ

Icon

рд╕реНрд╡рдЪрд╛рд▓рд┐рдд рдлрд┐рд▓реНрдЯрд░

Choose Data - More Filters - Advanced Filter...

Choose Data - More Filters - Standard Filter... - Options label

Choose Data - More Filters - Advanced Filter... - Options label

Choose Data - More Filters - Reset Filter

On Table Data bar, click Reset Filter/Sort

Icon

Reset Filter/Sort

Choose Data - More Filter - Hide AutoFilter

Choose Data - Subtotals

Choose Data - Subtotals - 1st, 2nd, 3rd Group tabs

Choose Data - Subtotals - Options tab

Choose Data - Validity

Menu Data - Validity - Criteria tab

Choose Data - Validity - Input Help tab

Choose Data - Validity - Error Alert tab

Choose Data - Multiple Operations

Choose Data - Consolidate

Choose Data - Group and Outline

Choose Data - Group and Outline - Hide Details

Choose Data - Group and Outline - Show Details

Choose Data - Group and Outline - Group

F12

On Tools bar, click

Icon

рд╕рдореВрд╣

Choose Data - Group and Outline - Ungroup

+F12

On Tools bar, click

Icon

рд╕рдореВрд╣ рд╕реЗ рд╣рдЯрд╛рдПрдБ

Choose Data - Group and Outline - AutoOutline

Choose Data - Group and Outline - Remove

Choose Data - Group and Outline - Show Details (for some pivot tables)

Choose Data - Pivot Table

Choose Insert - Pivot Table

Choose Insert - Pivot Table, in the Select Source dialog choose the option Data source registered in LibreOfficeDev.

Choose Insert - Pivot Table, in the Select Source dialog choose the option Current selection.

Choose Insert - Pivot Table, in the Select Source dialog choose the option Data source registered in LibreOfficeDev, click OK to see Select Data Source dialog.

Choose Data - Pivot Table - Refresh

Choose Data - Pivot Table - Delete

Choose Data - Refresh Range

Choose Data - Group and Outline - Group