Video Tutorials

Table of Contents - Calc

    Editing cell data

  1. Entering cell data
  2. Automatic formatting, and forcing formatting as text
  3. Data exceeds cell boundaries
  4. Manual text breaks in a cell

    Selecting cells, rows and columns

  1. Selecting cells, rows and columns

    Cell addressing

  1. Cell addressing
  2. Naming cells

    Data series

  1. Filling cells using a data series
  2. Filling cells using a data series with a specific interval
  3. Data series-increasing or decreasing values
  4. Filling cells with the same value
  5. Defining data series parameters

    Inserting, deleting and transposing cells, rows and columns

  1. Inserting new rows and columns into a sheet
  2. Inserting cells into a sheet
  3. Transposing rows into columns and vice versa
  4. Deleting data by type
  5. Hiding and restoring rows and columns

    Working with sheets

  1. Renaming a sheet
  2. Increasing the sheet tab display area
  3. Adding new sheets to the document
  4. Inserting document sheets from other files
  5. Copying and moving sheets
  6. Changing sheet order in the document
  7. Selecting multiple sheets
  8. Deleting sheets from the document

    Formatting data

  1. Formatting numeric data
  2. Dates
  3. Entering numbers with leading zeros
  4. Number formatting depending on the cell language
  5. Setting cell currency format
  6. Font type and size

    Cell formatting

  1. Cell content alignment and rotation
  2. Changing the cell border
  3. Adding a colored background to selected cells
  4. Formatting tables using AutoFormat
  5. Merging cells
  6. Protecting cells from changes

    Data calculations

  1. Entering data calculation formulas
  2. Using the SUM function
  3. Summing up values from several cell ranges
  4. Rapid calculations on selected cells
  5. Inserting functions using the function wizard
  6. Adjusting the value of a formula element to attain a specified goal
  7. Calculating data group values using the Subtotals tool
  8. Joining several strings in one cell

    Cell references-addressing methods

  1. Relative addressing
  2. Absolute addressing
  3. Mixed addressing

    Browsing and sorting data

  1. Browsing data using the AutoFilter
  2. Sorting table data

    Sheet display options

  1. Splitting the sheet window into 2 or 4 panes
  2. Locking a sheet section (Freeze)

    Charts

  1. Creating charts
  2. Editing charts