Difference between revisions of "LibreOffice Suite Calc 6.3"

Latest revision as of 11:17, 5 November 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 generates 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.

Additionally, Calc now supports 1 million rows in a spreadsheet with macro references to each cell. Supports many functions, including those for imaginary numbers, as well as financial and statistical functions. Calc is capable of opening and saving most spreadsheets in Microsoft Excel file format. Calc is also capable of saving spreadsheets as PDF files. As with the entire LibreOffice suite, Calc is available for a variety of platforms, including Linux, macOS, Microsoft Windows and FreeBSD.

Basic Level

1. Introduction to LibreOffice Calc
   • Various toolbars in Calc window - Title & Menu Bar, Standard Toolbar, Formatting Toolbar, Formula Bar, Status Bar and Side Bar
   • Opening new spreadsheet in Calc
   • Opening an existing spreadsheet in Calc
   • Save and close a spreadsheet
   • Workbook in Calc
   • Grid of columns and rows in Calc
   • Cells in Calc
   • Change font size, font style and font name
   • Saving files in different formats dot XLSX and dot HTML
   • Export as PDF
2. Working with Cells in Calc
   • Enter numbers in cells
   • Enter text in cells
   • Enter date and time in cells
   • Use the Format Cells dialog-box
   • Navigate between cells
   • Select items in rows
   • Select items in sheet
   • Select columns in sheet
   • Learn how to enter data in cells
   • Select multiple columns
   • Select multiple rows
3. Working with Sheets in Calc
   • Insert a single row or a single column
   • Inserting multiple rows
   • Inserting multiple columns
   • Inserting sheets
   • Deleting sheets
   • Renaming Sheets
   • Moving Sheets
   • Deleting single and multiple rows
   • Deleting single and multiple columns
4. Formatting Data in Calc
   • Applying border styles from available list
   • Formatting borders of cells as per our preference
   • Adding background colors in cells
   • Formatting multiple lines within a single cell
   • Automatic Wrapping
   • Merging cells
   • Shrinking text to fit the cell
5. Basic data manipulation in Calc
   • Introduction to basics of using formula in Calc
   • Basic arithmetic calculations - addition, subtraction, multiplication, division
   • Sorting by columns
   • Basics of filtering data
   • Formula for SUM
   • Formula for AVG
   • Sorting in Descending order
   • Sorting in Ascending order
   • Sort data using the Sort keys feature
   • Working of Auto Filter feature
6. Working with Data in Calc
   • Speed up using Fill tools
   • Sharing content between sheets
   • Removing data
   • Replacing data
   • Changing part of a data
   • Different Fill tool
   • Different Fill Series
7. Viewing and Printing a Spreadsheet in Calc
   • Viewing in Normal mode
   • Viewing in Page Break mode
   • Viewing in Full Screen mode
   • Setting up Page Style options
   • Setting up the page order
   • Setting up Page Margin, Orientation and Layout
   • How to use Zoom slider
   • Different Zoom & View layout options
   • How to adjust the content to fit page
   • How to use Print Preview option
   • How to print the sheet as a PDF file
   • How to print selected pages
   • How to setup no of print copies
   • How to print selected cells
   • Other printing options

Intermediate Level

1. Using Charts and Graphics in Calc
   • Create, edit and format Charts
   • Resize and move Charts
   • Different Chart formats
   • 3D Look in Chart
   • Add a title to the Chart
   • Data Series in Chart
   • Data Ranges in Chart
   • Format Chart Wall
   • Format Chart Area
   • Chart Area Legend ON/OFF
   • Changing the Position and Size of a Chart
2. Inserting Images and inbuilt Graphics in Calc
   • Insert an Image file directly
   • Insert an Image file from a graphics program
   • Insert an Image with the help of a clipboard
   • Insert an Image from the gallery
   • Insert an Image using Drag and Drop option
   • Picture toolbar in Calc
   • Graphics mode in Calc
   • Hyperlink an image
   • Crop an image
   • Add filter option to an image
3. Advanced Formatting and Protection in Calc
   • Password protect from a spreadsheet
   • Remove Password protect from a spreadsheet
   • Password protect from a single sheet
   • Remove Password protect from a single sheet
   • Define Ranges for a database
   • Validate cells
   • Database range in Calc
   • Use Clone Formatting in Calc
   • Use SUBTOTAL in Calc
   • Use GRANDSUM in Calc
4. Formulae and Functions in Calc
   • Usage of Conditional Operator in Calc
   • Usage of If.. Or statement in Calc
   • Rounding off numbers
   • Usage of Function Wizard in Calc
   • Usage of following functions in Calc:
     • SUM()
     • PRODUCT()
     • MIN()
     • MAX()
     • MEDIAN()
     • COUNT()
     • COUNTIF()
5. Linking Calc Data
   • Cell Referencing in Calc
   • Inserting a Hyperlink in a spreadsheet
   • Navigate between sheets using Hyperlink
   • Navigate between documents using Hyperlink
   • Hyperlinking to a website
   • Usage of Hyperlink dialog box
   • Setting up a target document
   • Setting up a target sheet
   • Remove the Hyperlink