Introduction to LibreOffice Calc

Foss: LibreOffice Suite Calc - English

Outline: 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 ..

Basic

Working with Cells

Foss: LibreOffice Suite Calc - English

Outline: 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..

Basic

Working with Sheets

Foss: LibreOffice Suite Calc - English

Outline: Working with Sheets Inserting and Deleting rows and columns Calc. Inserting and Deleting Sheets in Calc. Renaming Sheets

Basic

Formatting Data

Foss: LibreOffice Suite Calc - English

Outline: 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 ..

Basic

Basic Data Manipulation

Foss: LibreOffice Suite Calc - English

Outline: 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) Subto..

Basic

Working with data

Foss: LibreOffice Suite Calc - English

Outline: Working with data Speed up using Fill tools and Selection lists. Sharing content between sheets Remove data,Replace data,Change part of a data.

Basic

Using Charts and Graphs

Foss: LibreOffice Suite Calc - English

Outline: Using Charts and graphs in Calc Creating,Editing and Formatting Charts Types of charts Resizing and moving of charts

Intermediate

Images and Graphics

Foss: LibreOffice Suite Calc - English

Outline: Images and graphics in Calc Inserting images in Calc Modifying images

Intermediate

Advanced Formatting and Protection

Foss: LibreOffice Suite Calc - English

Outline: Advanced Formatting and Protection Cell Protection Ranges Validity

Intermediate

Formulas and Functions

Foss: LibreOffice Suite Calc - English

Outline: Formulas and Functions Creating formulas,operator types and referencing Basic arithmetic and statistic functions - relative and fixed ($) referencing in a function Rounding off number..

Intermediate

Linking Calc Data

Foss: LibreOffice Suite Calc - English

Outline: Linking Calc Data Referencing other sheets and documents Working with Hyperlinks

Intermediate