How to use MyOffice Table

• About
• Key terms

Interface overview

• Screen elements
• Toolbar
• Quick actions box
• Demonstrate new features
• Keyboard shortcuts
• Language

Files

• New
• Save as template
• New from template
• Open
• Recent files
• Open with
• Save
• Import file
• Export to
• Preview and print
• Close

Sheets

• Insert a sheet
• Rename a sheet
• Hide or unhide sheets
• Duplicate a sheet
• Change sheets order
• Zoom a sheet
• Hide or display zero values
• Delete a sheet

Cells, columns, and rows

• Expand the workspace
• Select cell ranges
• Resize cells
• Merge or split cells
• Reference to cells and cell ranges
• Insert columns or rows
• Select colums or rows
• Hide or unhide a column or row
• Resize a column or row
• Freeze columns, rows, or area
• Group columns or rows
• Sort and filter
• Delete columns or rows

Data

• Enter data
• Number formats
• Link
• Notes
• Special characters
• Check spelling
• Find and replace

Formulas and functions

• Formulas and functions basics
• Order of operations in a formula
• Automatic calculation
• Enter functions
• Replace a formula with its result
• Copy and insert formulas
• Names in formulas and functions
• Structured references

Calculation operators

• Arithmetic operators
• Comparison operators
• Text concatenation operator 
• Reference operators

Pivot tables

• Create a pivot table
• Customize a pivot table
• Refresh a pivot table
• Delete a pivot table

Charts

• Create a chart
• Chart settings
• Move a chart
• Copy, cut or insert a chart
• Change chart type
• Change chart size
• Change data in chart
• Change chart data source
• Delete a chart

Images

• Insert an image
• Resize an image
• Move an image
• Save an image
• Delete an image

Shapes

• Insert a shape
• Fill a shape
• Outline
• Resize a shape
• Fit shape size to text
• Move a shape
• Delete a shape

Formatting

• Font
• Font size
• Font formatting
• Font сolor
• Highlight color
• Alignment
• Rotate text
• Wrap text
• Character spacing
• Cell background color
• Cell borders
• Copy and apply formatting

Cloud actions

• Log in
• Open a file
• Create a local copy
• Create a file or folder
• Upload a file
• Download a file or folder
• Delete a file
• Restore a file or folder
• Shared access to files
• Collaboration
• Revoke own access
• Log out

Automation tools

• Macros
• Extensions

Document protection

• Protect document with a password
• Protect content from changes

Appendices

• Appendix A. List of functions
• Appendix B. List of supported currencies