LibreOffice Calc is a spreadsheet application that is part of the LibreOffice suite, an open-source alternative to Microsoft Excel. It offers similar functionality for creating, editing.

Open Run Command – Window +R –>> scalc

Key Features:

1. Basic Spreadsheet Functions: Supports calculations, formulas, and functions like SUM, AVERAGE, IF, VLOOKUP, etc.
2. Data Visualization: Allows creating various types of charts and graphs.
3. Data Import and Export: Compatible with various file formats, including Excel (.xlsx), CSV, and more.
4. Data Analysis Tools: Includes pivot tables, filters, goal seek, and solver for advanced data analysis.
5. Collaboration: Allows multiple users to work on a spreadsheet simultaneously.
6. Macros: Supports macros for automating repetitive tasks using LibreOffice Basic, Python, and JavaScript.
7. Customizable: Highly customizable interface, including the ability to add extensions.

Basic Tips:

• Using Formulas: Start formulas with = (e.g., =SUM(A1:A10) ).
• Formatting Cells: Use Ctrl+1 to open the cell formatting options for numbers, dates, currency, etc.
• Sorting and Filtering: Access sorting and filtering options from the Data menu.
• Creating Charts: Select your data and go to Insert > Chart to visualize it.
• AutoFill: Drag the fill handle (small square at the bottom right corner of a cell) to auto-fill sequences or replicate data.

keyboard Shortcuts:

• Ctrl+C to copy, Ctrl+V to paste.
• Ctrl+Z to undo, Ctrl+Y to redo.
• Ctrl+S to save the file.

Calc Formulas

Basic Arithmetic Operations:

• Addition: =A1 + B1
• Subtraction: =A1 - B1
• Multiplication: =A1 * B1
• Division: =A1 / B1
• Average =AVERAGE(A1:A10)
• IF =IF(A1 > 100, “Above 100”, “100 or less”)
• =IFERROR(A1/B1, “Error: Division by Zero”)
• =VLOOKUP(D1, A1:B10, 2, FALSE)
• =HLOOKUP(D1, A1:J2, 2, FALSE)
• =CONCATENATE(A1, ” “, B1)
• =LEFT(A1, 3) // Extracts the first 3 characters
• =MID(A1, 2, 4) // Extracts 4 characters starting from the second character
• =RIGHT(A1, 5) // Extracts the last 5 characters
• Today =TODAY()
• Now =NOW()
• =ABS(A1)
• =MAX(A1:A10)
• =MIN(A1:A10)
• =COUNT(A1:A10)
• =SUM(B2:B20)
• =DATEDIF(A1, B1, “D”) // Difference in days
• AND: Returns TRUE if all conditions are true. =AND(A1 > 0, B1 < 100)
• OR: Returns TRUE if any condition is true =OR(A1 > 100, B1 < 50)
• =ROUND(A1, 2) // Rounds A1 to 2 decimal places
• Countdown to an Important Date: Days Until Formula
• =DAYS(TargetDate, TODAY())
• =DAYS(“2024-12-31”, TODAY())
• Median =median(A1:A7)
• Mode =mode(A1:A7)
• =TRIM(start cell:end cell)
• =POWER(A1, B1)
• =SQRT(A1)
• =IF(A1 > B1, “A1 is greater”, “B1 is greater or equal”)