Spoken Tutorial

Formulas and Functions - English

LibreOffice Suite Calc Tutorials - English 11
  • 1
    Introduction to LibreOffice Calc
  • 2
    Working with Cells
  • 3
    Working with Sheets
  • 4
    Formatting Data
  • 5
    Basic Data Manipulation
  • 6
    Working with data
  • 7
    Using Charts and Graphs
  • 8
    Images and Graphics
  • 9
    Advanced Formatting and Protection
  • Formulas and Functions
  • 11
    Linking Calc Data
  1. Instruction Sheet
  2. Installation Sheet
Outline:
Formulas and Functions Creating formulas,operator types and referencing Basic arithmetic and statistic functions - relative and fixed ($) referencing in a function Rounding off numbers If..else Important string functions (left, right, middle, concatenate)

Code files

  • Personal-Finance-Tracker.ods

Status:

Slides

  • Formulas and Functions/
  • Formulas and Functions/1-TTT-Logo.png
  • Formulas and Functions/2-DC-Logo.jpg
  • Formulas and Functions/Formulas and Functions.pdf
  • Formulas and Functions/LO.Calc.i.4.0.Formulas and Functions.tex

Status:

  • FOSSEE Project
  • Scilab Project
  • Oscad
  • Python
  • CFD
  • OR-Project
  • Aakash Labs
  • Co-learn
  • Education Mission
  • Software Training
  • Creation
  • News
  • About
  • Training
Developed at IIT Bombay
This work is licensed under Creative Commons