LibreOffice Calc is the spreadsheet component of the LibreOffice Suite.
It is the equivalent of Microsoft Excel in Microsoft Suite and has a number of unique features that make it a versatile tool for creating spreadsheets. Read more
Foss : LibreOffice Calc on BOSS Linux - English
Outline: Working with Cells
How to enter numbers,text,numbers as text,date and time in Calc.
How to Navigate between cells and in between sheets.
How to select items in row..
Outline: Working with Sheets
Inserting and Deleting rows and columns Calc.
Inserting and Deleting Sheets in Calc.
Outline: Formatting Data
Borders, Color, Formatting Text, Increasing Cell Size
Formatting multiple lines of text,numbers,fonts,cell borders,cell background
Outline: Basic Data Manipulation
Paste and paste special (values, transpose), pasting a spreadsheet into writer as a table
Introduction to Formulas – Sum, Average, basic formula..
Outline: Working with data
Speed up using Fill tools and Selection lists.
Sharing content between sheets
Remove data,Replace data,Change part of a data.
Outline: Using Charts and graphs in Calc
Creating,Editing and Formatting Charts
Types of charts
Resizing and moving of charts
Outline: Formulas and Functions
Creating formulas,operator types and referencing
Basic arithmetic and statistic functions - relative and fixed ($) referencing in a function
Outline: Linking Calc Data
Referencing other sheets and documents
Working with Hyperlinks
Outline: Introduction to LibreOffice Calc
What is Calc,Who should use Calc,What can be done using Calc.
About spreadsheets,sheets and cells.
Basic features – parts of main Ca..
Click here to view stats
Spoken Tutorial by IIT Bombay is licensed under a Creative Commons Attribution-ShareAlike 4.0 International License, except where stated otherwise Based on a work at https://spoken-tutorial.org. Permissions beyond the scope of this license may be available at https://spoken-tutorial.org.