LibreOffice Calc Tutorial

This page contains all the LibreOffice Calc Tutorial(s) grouped based on the learning curve. You can read them and grasp the concept of the LibreOffice Calc spreadsheet application.

LibreOffice Calc Tutorial Index

1. Basics

1.1 Work Area

List of articles describing the basics of Calc and helping to understand the work area of Calc.

• Maximum Number of Rows, Columns, Cells
• Supported File Formats

1.2 Workbook and Worksheet

Concept of the workbook, save Calc file formats to Microsoft Excel formats and view multiple workbooks together. Add, Insert, Delete, Copy, Move, Rename a Worksheet, Split, Zoom, and Freeze a worksheet.

• Create, Save, Open and Close a Workbook
• Add, Insert, Delete, Copy, Move, Rename Worksheet
• Freeze and Unfreeze
• Zoom In, Zoom out
• Find, Replace
• Split a Worksheet View

1.3 Formatting Cells

A set of articles on formatting a cell value in multiple ways, data and time, currency, fractions, text to numbers, and numbers to text.

• Format Cells
• Delete Empty Rows
• Custom Number Format
• Convert Text to Number
• How to Enter, Display Fractions
• Date and Time
• Decimal Places
• Upper case, lower case and camel case
• Paste special – values & formats
• Split cell contents to multiple columns – text to columns
• Formatting currency

1.4 Data Validation

How to do basic data validation while accepting input in Calc cells.

• Numeric Data Validation
• Double Dependent Dropdown List
• DropDown List

1.5 Count and Sums

About counting and sums.

• Autosum
• SUMPRODUCT
• SUMIF and SUMIFS
• Count Characters
• Running Total
• Count Blank Non-Empty Cells
• COUNTIF
• Calculate percentage % change

1.6 Date and Time related

Various date and time related tutorials.

• Find out workday, weekday
• Basics of Date and Time
• Calculate date difference (days between two dates)
• Insert current date and time

1.7 Functions

Various functions tutorials with case study examples, sorted alphabetically.

• Comma or semicolon – which one to use in formula
• Concatenate two strings
• COUNTIF
• Count Blank Non-Empty Cells
• Count Characters – LEN and SUBSTITUTE
• EXACT
• IF, Nested IF, AND, OR, IF basics
• IFS
• MATCH
• MID function
• REPLACE
• Running Total
• SEARCH Text, Check if cell contains a specific text using SEARCH and FIND
• SEARCH character position
• SUBSTITUTE , with replace
• SUMPRODUCT
• SUMIF and SUMIFS
• TEXT
• UPPER, LOWER and PROPER – Upper case, lower case and camel case using
• VLOOKUP

2. Advanced

2.1 Cell references

Linking to internal and external sheets and workbooks.

• Relative, absolute and mixed reference for cells
• Hyperlink to cell, sheet, workbook
• Reference to external workbook

2.2 Lookup and search

• Basics of lookup and references
• VLOOKUP with examples
• Case sensitive lookup
• Find character position in a string
• Count words in LibreOffice Calc cell
• Find and remove space in cells
• Find substring

2.3 Fixing Errors

• Calc Spreadsheet Err 502 – How to Solve

3. Others

• Supported File Formats
• Maximum Number of Rows, Columns, Cells in LibreOffice Calc
• Find empty and blank cells
• Delete empty rows
• Remove duplicates
• Compare two columns
• Protect Calc spreadsheet with password
• Repeat Rows Headers or Columns in Every Print Pages
• Templates: How to use templates in LibreOffice Calc with example.
• Fill empty cells from the above values
• Add sparklines in cells
• Print: Make sheet fit to a page layout for print
• Print: Add header and footer to Sheet
• Print: Repeat same header in each print pages