LibreOffice Calc on BOSS Linux - Revision history

PoojaMoolya: /* Advanced Level */

2020-10-09T11:03:34Z

‎Advanced Level

PoojaMoolya: /* Intermediate Level */

2020-10-09T11:03:17Z

‎Intermediate Level

PoojaMoolya: /* Basic Level */

2020-10-09T11:02:40Z

‎Basic Level

PoojaMoolya: /* Basic Level */

2020-10-09T11:01:33Z

‎Basic Level

Nancyvarkey: Created page with "=== 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 u..."

2015-08-04T08:09:29Z

Created page with "=== 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 u..."

New page

=== 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    
#* 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    
#* 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    
#* Inserting and Deleting rows and columns Calc.
#* Inserting and Deleting Sheets in Calc.
#* Renaming Sheets.
# 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
# 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
# Working with data    
#* 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    
#* 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    
#* Creating,Editing and Formatting Charts
#* Types of charts
#* Resizing and moving of charts
# Images and graphics in Calc    
#* Inserting images in Calc
#* Modifying images
# Advanced Formatting and Protection    
#* Cell Protection
#* Ranges
#* Validity
# 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)
# Linking Calc Data    
#* Referencing other sheets and documents
#* Working with Hyperlinks

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

← Older revision		Revision as of 11:03, 9 October 2020
Line 57:		Line 57:
	#* Referencing other sheets and documents		#* Referencing other sheets and documents
	#* Working with Hyperlinks		#* Working with Hyperlinks
−
−	~~=== Advanced Level ===~~
−	~~# Auto-formatting cells and sheets    ~~
−	~~#* How auto-formatting is done~~
−	~~#* Defining a new auto-format~~
−	~~#* Using themes and Conditional formatting~~
−	~~#* Hiding and showing data~~
−	~~# Sharing and Reviewing    ~~
−	~~#* Recording Changes~~
−	~~#* Adding comments to changes~~
−	~~#* Accepting/Rejecting changes~~
−	~~#* Header and footer~~
−	~~# Macro in Calc    ~~
−	~~#* Using macro recorder~~
−	~~#* Writing own functions in macro~~
−	~~#* Editing a macro,playing a macro, deleting a macro~~
−	~~# Working with Styles    ~~
−	~~#* Types of Styles~~
−	~~#* Modifying Styles~~
−	~~#* Creating new styles~~
−	~~# Data manipulation    ~~
−	~~#* Convert text to columns~~
−	~~#* Convert columns to txt~~
−	~~# Data Analysis    ~~
−	~~#* Creating scenarios~~
−	~~#* Changing scenarios~~
−	~~#* Working with scenarios using navigator~~
−	~~#* Multiple operations in rows and columns~~
−	~~# Data Pilot    ~~
−	~~#* Data source~~
−	~~#* Data pilot dialog~~
−	~~#* Working with the results of data pilot.~~
−	~~#* Filters~~

@@ Line 48: / Line 48: @@
 #* Types of charts
 #* Resizing and moving of charts
 # Formulas and Functions &nbsp; &nbsp;
 #* Creating formulas,operator types and referencing

@@ Line 38: / Line 38: @@
 #* Sorting by Columns
 #* Filtering Data - Basics
 === Intermediate Level ===