Difference between revisions of "LibreOffice Calc on BOSS Linux"

From Script | Spoken-Tutorial
Jump to: navigation, search
(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...")
 
(→‎Advanced Level)
 
(3 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    
+
#Working with data
−
#* Speed up using Fill tools and Selection lists.
+
#*Speed up using Fill tools and Selection lists.
−
#* Sharing content between sheets
+
#*Sharing content between sheets
−
#* Remove data,Replace data,Change part of a data.
+
#*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 ===
 
=== Intermediate Level ===
Line 52: 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 68: 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

Retrieved from "https://script.spoken-tutorial.org/index.php?title=LibreOffice_Calc_on_BOSS_Linux&oldid=54001"