Pratik kamble at 11:35, 22 November 2019

2019-11-22T11:35:22Z

Pratik kamble at 10:02, 8 May 2015

2015-05-08T10:02:40Z

Nancyvarkey: Nancyvarkey moved page /Calc to LibreOffice Suite Calc without leaving a redirect

2014-11-10T11:59:55Z

Nancyvarkey moved page /Calc to LibreOffice Suite Calc without leaving a redirect

Minal: 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 uniq…'

2012-12-10T11:26:10Z

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 uniq…'

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.

__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 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

@@ Line 6: / Line 6: @@
 === Basic Level ===
 # Introduction to LibreOffice Calc &nbsp; &nbsp;
 #* What is Calc,Who should use Calc,What can be done using Calc.

@@ Line 14: / Line 14: @@
 # 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.

← Older revision	Revision as of 11:59, 10 November 2014
(No difference)

LibreOffice Suite Calc - Revision history

Pratik kamble at 11:35, 22 November 2019

Pratik kamble at 10:02, 8 May 2015

Nancyvarkey: Nancyvarkey moved page /Calc to LibreOffice Suite Calc without leaving a redirect

Minal: 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 uniq…'