View source for 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'''


__TOC__

=== Basic Level ===
# Introduction to LibreOffice Calc &nbsp; &nbsp; 
#* 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
# Working with Cells &nbsp; &nbsp; 
#* 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.
# Working with Sheets &nbsp; &nbsp; 
#* Inserting and Deleting rows and columns Calc.
#* Inserting and Deleting Sheets in Calc.
#* Renaming Sheets.
# Formatting Data &nbsp; &nbsp; 
#* 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
# Basic Data Manipulation &nbsp; &nbsp; 
#* 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
#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 ===
# Using Charts and graphs in Calc &nbsp; &nbsp; 
#* Creating,Editing and Formatting Charts
#* Types of charts
#* Resizing and moving of charts
# Formulas and Functions &nbsp; &nbsp; 
#* 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)
# Linking Calc Data &nbsp; &nbsp; 
#* Referencing other sheets and documents
#* Working with Hyperlinks

=== Advanced Level ===
# Auto-formatting cells and sheets &nbsp; &nbsp; 
#* How auto-formatting is done
#* Defining a new auto-format
#* Using themes and Conditional formatting
#* Hiding and showing data
# Sharing and Reviewing &nbsp; &nbsp; 
#* Recording Changes
#* Adding comments to changes
#* Accepting/Rejecting changes
#* Header and footer
# Macro in Calc &nbsp; &nbsp;
#* Using macro recorder
#* Writing own functions in macro
#* Editing a macro,playing a macro, deleting a macro
# Working with Styles &nbsp; &nbsp; 
#* Types of Styles
#* Modifying Styles
#* Creating new styles
# Data manipulation &nbsp; &nbsp; 
#* Convert text to columns
#* Convert columns to txt
# Data Analysis &nbsp; &nbsp; 
#* Creating scenarios
#* Changing scenarios
#* Working with scenarios using navigator
#* Multiple operations in rows and columns
# Data Pilot &nbsp; &nbsp; 
#* Data source
#* Data pilot dialog
#* Working with the results of data pilot.
#* Filters