LibreOffice Calc on BOSS Linux

Introduction

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, including a system which automatically defines series of graphs, based on information available to the user .It is a free and open source software so it can be copied, re-used and distributed free of cost.

Exclusively created for CDAC by the Spoken Tutorial Project, IIT Bombay

Basic Level

1. 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 Calc window - Title & Menu Bar, Standard Toolbar, Formatting Toolbar, Formula Bar, Status Bar
   • What is a cell, row, column, Create new document, enter data in one cell, save in Calc( CSV and other formats),opening/closing document.
   • Save as ods, csv, xls, xlsx and export to PDF
2. Working with Cells    
   • How to enter numbers,text,numbers as text,date and time in Calc.
   • How to use the Format Cells dialog box.
   • How to Navigate between cells and in between sheets.
   • How to select items in rows,columns and sheets.
3. Working with Sheets    
   • Inserting and Deleting rows and columns Calc.
   • Inserting and Deleting Sheets in Calc.
   • Renaming Sheets.
4. Formatting Data    
   • Borders, Color, Formatting Text, Increasing Cell Size
   • Formatting multiple lines of text,numbers,fonts,cell borders,cell background
   • Automatic Wrapping and Using manual breaks
   • Merging cells, rows and columns, issues with using merge cells.
   • Shrinking text to fit the cell
5. Basic Data Manipulation    
   • Paste and paste special (values, transpose), pasting a spreadsheet into writer as a table
   • Introduction to Formulas – Sum, Average, basic formula (=a*b+c)
   • Subtotal
   • Different kinds of functions available in spreadsheet
   • Sorting by Columns
   • Filtering Data - Basics
6. Working with data
   • Speed up using Fill tools and Selection lists.
   • Sharing content between sheets
   • Remove data,Replace data,Change part of a data

Intermediate Level

1. Using Charts and graphs in Calc    
   • Creating,Editing and Formatting Charts
   • Types of charts
   • Resizing and moving of charts
2. 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)
3. Linking Calc Data    
   • Referencing other sheets and documents
   • Working with Hyperlinks

Contributors and Content Editors

Nancyvarkey, PoojaMoolya