
UPPER, LOWER and PROPER – Upper case, lower case and camel case using.SEARCH Text, Check if cell contains a specific text using SEARCH and FIND.
Comma or semicolon – which one to use in formula.
Various functions tutorials with case study examples, sorted alphabetically.
Calculate date difference (days between two dates). How to do basic data validation while accepting input in Calc cells. Split cell contents to multiple columns – text to columns. Add, Insert, Delete, Copy, Move, Rename WorksheetĪ set of articles on formatting a cell value in multiple ways, data and time, currency, fractions, text to numbers, and numbers to text. Create, Save, Open and Close a Workbook. Add, Insert, Delete, Copy, Move, Rename a Worksheet, Split, Zoom, and Freeze a worksheet. List of articles describing the basics of Calc and helping to understand the work area of Calc.Ĭoncept of the workbook, save Calc file formats to Microsoft Excel formats and view multiple workbooks together. You can read them and grasp the concept of the LibreOffice Calc spreadsheet application. This page contains all the LibreOffice Calc Tutorial(s) grouped based on the learning curve.