Contact

LibreOffice Calc learning centre

LibreOffice Calc Tutorials and Troubleshooting

89 practical tutorials. Start with the ordered route, or browse every lesson by task and learning stage.

About this tutorial collection

Learn how to solve specific Calc problems with worked examples, small practice datasets, and clear procedures. Each guide states what was checked in documentation or tested in the application. Start with CSV import issues, then explore formulas and data-cleanup workflows. These lessons complement the LibreOffice function A–Z directory.

New to the software? Begin with CSV files opening in one column or COUNTIF returning zero. Each tutorial links to the relevant official help documentation.

Suggested first steps

Calc: from readable cells to checked output

Use Calc desktop and work on copies of your files. Know how to select a cell and enter a value. Each lesson uses a separate example; version-specific menus and verification limits are stated below.

This is a short route through existing guides, not a complete course or a claim that every procedure was application-tested.

  1. Make Long Labels Readable in LibreOffice Calc

    Enter and format a readable task table.

    Version and verification notes

    Calc desktop standard menus; Guide 26.2 and Help 26.8; native workflow/save-reopen unverified.

  2. Format Numbers, Dates and Durations in LibreOffice Calc

    Distinguish stored numbers from currency, dates and duration displays.

    Version and verification notes

    Guide 26.2 and Help 26.8; English USA output conventions; documentation/arithmetic only, no native display or persistence test.

  3. Absolute and Relative Cell References in LibreOffice Calc

    Copy a formula while retaining a shared rate.

    Version and verification notes

    Calc Help documentation; installed version/OS/locale may differ; no exact runtime established by this page.

  4. Sort Whole Records and Filter a Data Range in LibreOffice Calc

    Preserve complete order records and reconcile filtered totals.

    Version and verification notes

    Guide 26.2 and Help 26.8 desktop standard menus; native UI/save-reopen untested.

  5. Fit a Wide LibreOffice Calc Sheet onto a Readable PDF Page

    Check a bounded, readable exported report.

    Version and verification notes

    Page claims LibreOffice Community Calc 26.8.1.1 Linux en-US native one-page PDF test; provenance must be revalidated before surfacing a tested badge. Do not conflate with unrelated LibreOfficeDev 26.8 alpha tests or certify stable-channel availability.

Browse all tutorials

Learning stages use the guide’s own difficulty label. Edition/platform filtering is classified only for the reviewed route above; other lessons remain unclassified, not unsupported. Read each guide’s version notes.

Beginner

Control AutoInput and AutoCorrect in LibreOffice Calc

Separate Calc typing suggestions from automatic replacements, test a small replacement rule, and restore settings without losing existing exceptions.

Data entry and editing · Beginner

Unclassified: check guide

Guide’s version scope

Calc Guide 26.2 desktop English standard menus on Windows/Linux; supplementary Help labelled 26.8

Create and Repair Hyperlinks in LibreOffice Calc

Create named text hyperlinks, edit destinations without losing labels, and test relative file links after moving a practice folder.

Links and navigation · Beginner

Unclassified: check guide

Guide’s version scope

Calc Guide 26.2 desktop English standard menus on Windows/Linux; supplementary Help labelled 26.8

Fill Date Series and Custom Lists in LibreOffice Calc

Generate weekly dates, control sequence endpoints, repeat a custom workflow list and distinguish a filled value series from copied formulas in Calc.

Data entry and editing · Beginner

Unclassified: check guide

Fix Numbers Stored as Text in LibreOffice Calc

Convert text numbers into values LibreOffice Calc can calculate using VALUE and ISNUMBER, while preserving codes with leading zeros.

Data cleanup · Beginner

Unclassified: check guide

Freeze the Top Row in LibreOffice Calc

Keep your header row visible while scrolling in LibreOffice Calc using Freeze Rows and Columns, with troubleshooting and print-header tips.

Workflow · Beginner

Unclassified: check guide

Inspect Nested Formulas with Calc's Function Wizard

Build a small IF formula, inspect its SUM argument and boundary result, and distinguish the Function Wizard from the sidebar Functions deck.

Formula troubleshooting · Beginner

Unclassified: check guide

Guide’s version scope

Calc Guide 26.2 desktop English standard menus on Windows/Linux; supplementary Help labelled 26.8

Make Long Labels Readable in LibreOffice Calc

Make a readable Calc task table with wrapping, restrained borders and consistent alignment, then test added rows and whole-record sorting.

Cell formatting and layout · Beginner

Desktop (reviewed route)

Remove Duplicate Values in LibreOffice Calc

Remove duplicate values in LibreOffice Calc with Standard Filter, No duplications and a copy-to destination. Review duplicate rows with Data > Duplicates in 26.2.

Data cleanup · Beginner

Unclassified: check guide

Guide’s version scope

LibreOffice Calc 26.2 English desktop documentation; latest Help labelled 26.8 checked separately; no exact-build or cross-platform execution claim

Split Text into Columns in LibreOffice Calc

Split names, IDs and delimited values into columns using LibreOffice Calc Text to Columns, without overwriting important data.

Data cleanup · Beginner

Unclassified: check guide

Intermediate

Build one- and two-variable sensitivity tables

A worked Calc example to build one- and two-variable sensitivity tables, with source checks, changed inputs and recovery.

Analysis and modeling · Intermediate

Unclassified: check guide

Guide’s version scope

LibreOffice Calc 26.2 desktop; English standard menus on Windows/Linux; documentary workflow, native execution unverified

Calculate pivot percentages and running comparisons

A worked Calc example to calculate pivot percentages and running comparisons, with source checks, changed inputs and recovery.

Pivot tables and analysis · Intermediate

Unclassified: check guide

Guide’s version scope

LibreOffice Calc 26.2 desktop; English standard menus on Windows/Linux; documentary workflow, native execution unverified

Check an ODS to XLSX Transfer in LibreOffice Calc

Keep an ODS master, build a small compatibility control workbook, and reconcile formulas, dates, names, charts and validation in an XLSX exchange copy.

File compatibility · Intermediate

Unclassified: check guide

Choose a Calc scripting language and understand ScriptForge

Distinguish Calc scripting languages, ScriptForge services and UNO objects using a read-only example with explicit runtime and testing limits.

Formulas and analysis · Intermediate

Unclassified: check guide

Guide’s version scope

Free LibreOffice Calc desktop; Calc Guide 26.2, English Windows/Linux menus; ScriptForge API examples from Help labelled 26.8; documentation-qualified, not native tested

Compare and merge reviewed workbook copies

Compare and merge reviewed workbook copies. A controlled example with expected outcomes, changed-input checks and recovery.

Workbook workflows · Intermediate

Unclassified: check guide

Guide’s version scope

LibreOffice Calc 26.2 desktop; English standard menus on Windows/Linux; documentary, not native tested

Compare mixed-scale series with a combination chart

A worked Calc example to compare mixed-scale series with a combination chart, with source checks, changed inputs and recovery.

Charts and visualization · Intermediate

Unclassified: check guide

Guide’s version scope

LibreOffice Calc 26.2 desktop; English standard menus on Windows/Linux; documentary workflow, native execution unverified

Compare samples with hypothesis-test tools

A worked Calc example to compare samples with hypothesis-test tools, with source checks, changed inputs and recovery.

Analysis and modeling · Intermediate

Unclassified: check guide

Guide’s version scope

LibreOffice Calc 26.2 desktop; English standard menus on Windows/Linux; documentary workflow, native execution unverified

Compare Saved Scenarios in LibreOffice Calc

A worked Calc example to compare saved scenarios, with source checks, changed inputs and recovery.

What-if analysis · Intermediate

Unclassified: check guide

Guide’s version scope

LibreOffice Calc 26.2 desktop; English standard menus on Windows/Linux; documentary workflow, native execution unverified

Control recalculation and diagnose circular references

Control recalculation and diagnose circular references. A controlled example with expected outcomes, changed-input checks and recovery.

References and calculation · Intermediate

Unclassified: check guide

Guide’s version scope

LibreOffice Calc 26.2 desktop; English standard menus on Windows/Linux; documentary, not native tested

Create a document-owned Basic custom function

Create a document-owned Basic custom function. A controlled example with expected outcomes, changed-input checks and recovery.

Formulas and analysis · Intermediate

Unclassified: check guide

Guide’s version scope

LibreOffice Calc 25.2 Community desktop; English standard menus on Windows/Linux; documentary, not native tested

Create and interpret chart trendlines and error bars

A worked Calc example to create and interpret chart trendlines and error bars, with source checks, changed inputs and recovery.

Charts and visualization · Intermediate

Unclassified: check guide

Guide’s version scope

LibreOffice Calc 26.2 desktop; English standard menus on Windows/Linux; documentary workflow, native execution unverified

Create and Maintain Named and Database Ranges in LibreOffice Calc

Define scoped formula names and database record ranges in Calc, extend each explicitly, and verify totals and retained sort settings. Compare #Data, #Totals and #All selectors without double-counting.

Ranges and names · Intermediate

Unclassified: check guide

Create editable array-formula results safely

Create editable array-formula results safely. A controlled example with expected outcomes, changed-input checks and recovery.

References and calculation · Intermediate

Unclassified: check guide

Guide’s version scope

LibreOffice Calc 26.2 desktop; English standard menus on Windows/Linux; documentary, not native tested

Create pivot charts linked to pivot summaries

A worked Calc example to create pivot charts linked to pivot summaries, with source checks, changed inputs and recovery.

Charts and visualization · Intermediate

Unclassified: check guide

Guide’s version scope

LibreOffice Calc 26.2 desktop; English standard menus on Windows/Linux; documentary workflow, native execution unverified

Customize and Restore a Calc Toolbar and Keyboard Workflow

Customize toolbars, shortcuts and interface variants. A controlled example with expected outcomes, changed-input checks and recovery.

Automation and productivity · Intermediate

Unclassified: check guide

Guide’s version scope

LibreOffice Calc 26.2 desktop; English standard menus on Windows/Linux; documentary, not native tested

Enter and correct records with Data Form

Enter and correct records with Data Form. A controlled example with expected outcomes, changed-input checks and recovery.

Data preparation · Intermediate

Unclassified: check guide

Guide’s version scope

LibreOffice Calc 25.2 Community desktop; English standard menus on Windows/Linux; documentary, not native tested

Fill Reproducible Random Test Data in LibreOffice Calc

Use Calc's seeded random-fill tool to create a fixed test fixture, compare a repeat run, and check bounds without inventing a guaranteed sequence.

Data entry and filling · Intermediate

Unclassified: check guide

Filter pivot fields and drill into summary records

A worked Calc example to filter pivot fields and drill into summary records, with source checks, changed inputs and recovery.

Pivot tables and analysis · Intermediate

Unclassified: check guide

Guide’s version scope

LibreOffice Calc 26.2 desktop; English standard menus on Windows/Linux; documentary workflow, native execution unverified

Find a Required Input with Goal Seek in LibreOffice Calc

A worked Calc example to solve a single target with Goal Seek, with source checks, changed inputs and recovery.

What-if analysis · Intermediate

Unclassified: check guide

Guide’s version scope

LibreOffice Calc 26.2 desktop; English standard menus on Windows/Linux; documentary workflow, native execution unverified

Fix LibreOffice Calc Err:502 (Invalid Argument)

Understand LibreOffice Calc Err:502 and fix invalid function arguments, including mismatched COUNTIFS range sizes with tested examples.

Formula troubleshooting · Intermediate

Unclassified: check guide

Import and refresh a registered Base source

Import and refresh a registered Base source. A controlled example with expected outcomes, changed-input checks and recovery.

Data preparation · Intermediate

Unclassified: check guide

Guide’s version scope

LibreOffice Calc 25.2 Community desktop; English standard menus on Windows/Linux; documentary, not native tested

Improve spreadsheet readability and keyboard navigation

Improve spreadsheet readability and keyboard navigation. A controlled example with expected outcomes, changed-input checks and recovery.

Sharing, safety and accessibility · Intermediate

Unclassified: check guide

Guide’s version scope

LibreOffice Calc 26.2 desktop; English standard menus on Windows/Linux; documentary, not native tested

Insert and refresh a linked external data table

Insert and refresh a linked external data table. A controlled example with expected outcomes, changed-input checks and recovery.

References and calculation · Intermediate

Unclassified: check guide

Guide’s version scope

LibreOffice Calc 26.2 desktop; English standard menus on Windows/Linux; documentary, not native tested

Link external workbooks and manage update prompts

Link external workbooks and manage update prompts. A controlled example with expected outcomes, changed-input checks and recovery.

References and calculation · Intermediate

Unclassified: check guide

Guide’s version scope

LibreOffice Calc 26.2 desktop; English standard menus on Windows/Linux; documentary, not native tested

Link spreadsheet results into other office documents

Link spreadsheet results into other office documents. A controlled example with expected outcomes, changed-input checks and recovery.

References and calculation · Intermediate

Unclassified: check guide

Guide’s version scope

LibreOffice Calc 26.2 desktop; English standard menus on Windows/Linux; documentary, not native tested

Measure correlation and fit regression models

A worked Calc example to measure correlation and fit regression models, with source checks, changed inputs and recovery.

Analysis and modeling · Intermediate

Unclassified: check guide

Guide’s version scope

LibreOffice Calc 26.2 desktop; English standard menus on Windows/Linux; documentary workflow, native execution unverified

Optimize a constrained model with Solver in LibreOffice Calc

A worked Calc example to optimize a constrained model with Solver, with source checks, changed inputs and recovery.

Analysis and modeling · Intermediate

Unclassified: check guide

Guide’s version scope

LibreOffice Calc 26.2 desktop; English standard menus on Windows/Linux; documentary workflow, native execution unverified

Preview Data Provider transformations in LibreOffice Calc

Prepare a local CSV Data Provider import, check transformation order and distinguish a documented refresh command from verified refresh behavior.

Data preparation · Intermediate

Unclassified: check guide

Guide’s version scope

Free LibreOffice Calc desktop; Calc Guide 26.2, English Windows/Linux menus; supplemental online Help labelled 26.8; documentation-qualified, not native tested

Record and replay a document-owned macro in LibreOffice Calc

Record and replay a document-owned macro. A controlled example with expected outcomes, changed-input checks and recovery.

Formulas and analysis · Intermediate

Unclassified: check guide

Guide’s version scope

LibreOffice Calc 25.2 Community desktop; English standard menus on Windows/Linux; documentary, not native tested

Recover earlier document versions and protect file access

Practice recovery of stored Calc versions, protect an ODS copy with an opening password, and inspect Description and Custom Properties before a document handoff.

Sharing, safety and accessibility · Intermediate

Unclassified: check guide

Guide’s version scope

LibreOffice Calc 26.2 desktop; English standard menus on Windows/Linux; documentary, not native tested

Run a Chi-Square Independence Check in LibreOffice Calc

Prepare an observed count table for Calc's chi-square tool, check expected counts and degrees of freedom, and distinguish independence from goodness of fit.

Statistical analysis · Intermediate

Unclassified: check guide

Guide’s version scope

LibreOffice Calc 26.2 desktop, English menus; source-reviewed workflow, native execution unverified

Smooth time series and inspect frequency content

A worked Calc example to smooth time series and inspect frequency content, with source checks, changed inputs and recovery.

Workbook workflows · Intermediate

Unclassified: check guide

Guide’s version scope

LibreOffice Calc 26.2 desktop; English standard menus on Windows/Linux; documentary workflow, native execution unverified

Summarize and sample data with Statistics tools

A worked Calc example to summarize and sample data with Statistics tools, with source checks, changed inputs and recovery.

Analysis and modeling · Intermediate

Unclassified: check guide

Guide’s version scope

LibreOffice Calc 26.2 desktop; English standard menus on Windows/Linux; documentary workflow, native execution unverified

Use bubble, net or stock charts for appropriate data

A worked Calc example to use bubble, net or stock charts for appropriate data, with source checks, changed inputs and recovery.

Charts and visualization · Intermediate

Unclassified: check guide

Guide’s version scope

LibreOffice Calc 26.2 desktop; English standard menus on Windows/Linux; documentary workflow, native execution unverified

Use shared-file editing and resolve save conflicts

Use shared-file editing and resolve save conflicts. A controlled example with expected outcomes, changed-input checks and recovery.

Sharing, safety and accessibility · Intermediate

Unclassified: check guide

Guide’s version scope

LibreOffice Calc 26.2 desktop; English standard menus on Windows/Linux; documentary, not native tested

Advanced

Construct a Box Plot with Min–Max Whiskers in LibreOffice Calc

Build a positive-data box plot from stacked columns and cell-range error bars, with an explicit quartile method and independently checked endpoints.

Charts and visualization · Advanced

Unclassified: check guide

Guide’s version scope

LibreOffice Calc 26.2 desktop, English menus; source-reviewed workflow, native execution unverified