How can we help you?
How to use MyOffice Spreadsheet
Formulas and functions
- Formulas and functions basics
- Order of operations in a formula
- Reference cells and cell ranges
- Recalculation of formulas
- Automatic calculation
- Enter functions
- Function wizard
- Replace a formula with its result
- Copy and insert formulas
- Names in formulas and functions
- Reference to data in another document
- Structured references
Pivot tables
- Create a pivot table
- Open the pivot table settings pane
- Define the structure of the pivot table
- Customize the pivot table parameters
- Manage external sources
- Filter data in a pivot table
- Sort data in a pivot table
- Collapse or expand the elements of pivot table
- View cell details
- Refresh a pivot table
- Copy a pivot table
- Delete a pivot table
Charts
- Insert a chart
- Open the chart settings pane
- Chart settings
- Open chart elements settings
- Customize the appearance of an element
- Customize element text formatting
- Adjust the parameters of axes and gridlines
- Hide or display an element
- Move a chart
- Copy, cut or insert a chart
- Change chart type
- Resize a chart
- Change data in chart
- Change the data range for the chart
- Delete a chart or a chart element
