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.
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.
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
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
If you are still looking for something else, try our search option to find out.