Foss: LibreOffice Calc on BOSS Linux - 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
Foss: LibreOffice Calc on BOSS Linux - English
Outline: 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..
Basic
Foss: LibreOffice Calc on BOSS Linux - English
Outline: Working with Sheets Inserting and Deleting rows and columns Calc. Inserting and Deleting Sheets in Calc. Renaming Sheets
Basic
Foss: LibreOffice Calc on BOSS Linux - 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
Foss: LibreOffice Calc on BOSS Linux - 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
Foss: LibreOffice Calc on BOSS Linux - 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
Foss: LibreOffice Calc on BOSS Linux - English
Outline: Using Charts and graphs in Calc Creating,Editing and Formatting Charts Types of charts Resizing and moving of charts
Intermediate
Foss: LibreOffice Calc on BOSS Linux - 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
Foss: LibreOffice Calc on BOSS Linux - English
Outline: Linking Calc Data Referencing other sheets and documents Working with Hyperlinks