View source for LibreOffice Suite Calc

=== 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.

__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 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 &nbsp; &nbsp; 
#* Speed up using Fill tools and Selection lists.
#* Sharing content between sheets
#* Remove data,Replace data,Change part of a data.
# Viewing and printing a document &nbsp; &nbsp; 
#* Views options – Zoom option,Freezing and Splitting of screen, Page break view
#* Printing options and settings, header, footer
#* Print Margin

=== Intermediate Level ===
# Using Charts and graphs in Calc &nbsp; &nbsp; 
#* Creating,Editing and Formatting Charts
#* Types of charts
#* Resizing and moving of charts
# Images and graphics in Calc &nbsp; &nbsp; 
#* Inserting images in Calc
#* Modifying images
# Advanced Formatting and Protection &nbsp; &nbsp; 
#* Cell Protection
#* Ranges
#* Validity
# 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