Difference between revisions of "LibreOffice Calc on BOSS Linux"

From Script | Spoken-Tutorial
Jump to: navigation, search
(Basic Level)
(Advanced Level)
 
(2 intermediate revisions by the same user not shown)
Line 38: Line 38:
 
#* Sorting by Columns
 
#* Sorting by Columns
 
#* Filtering Data - Basics
 
#* 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 ===
 
=== Intermediate Level ===
Line 44: Line 48:
 
#* Types of charts
 
#* Types of charts
 
#* Resizing and moving 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      
 
# Formulas and Functions      
 
#* Creating formulas,operator types and referencing
 
#* Creating formulas,operator types and referencing
Line 60: 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
 

Latest revision as of 16:33, 9 October 2020

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