Contact

SoftMaker PlanMaker learning centre

SoftMaker PlanMaker Practical Tutorials

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

About this tutorial collection

Learn practical PlanMaker tasks using small, synthetic datasets and clearly stated expected outcomes. Each guide distinguishes independently checked sample arithmetic from interface steps checked against the official manual only. Menu labels and results may vary by version; application testing is not documented for these lessons.

Suggested first steps

FreeOffice PlanMaker: budget inputs to controlled edits

Use FreeOffice PlanMaker 2024 for Windows with the English ribbon and separate disposable workbooks. Start with only the Budget exercise in the download catalogue. Know basic cell selection and formula entry. The later names and grouped-sheet lessons are Intermediate, not a first-30-minutes promise; each uses a separate fixture. Confirm documented controls exist without upgrading. No native execution or other-platform parity is claimed.

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

  1. SoftMaker PlanMaker Starter Files and Practice Downloads

    Prepare the budget CSV inputs and check two formulas; this is a preparatory download catalogue, not a tutorial.

    Version and verification notes

    FreeOffice PlanMaker 2024 catalogue; import controls conditional, CSV inputs and arithmetic checked; native import/save/reopen unverified. Restrict this step to Budget, not the separately linked paid-2026 lessons.

  2. Center report headings without merging in FreeOffice PlanMaker

    Center a separate report heading while preserving cells and checked totals.

    Version and verification notes

    FreeOffice PlanMaker 2024 Windows English ribbon; FreeOffice-specific documentation and independent arithmetic only. Installed build, native workflow, save/reopen and screenshots unverified; no paid-2026 or other-platform parity.

  3. Create and apply range names in FreeOffice PlanMaker

    Progress to intermediate formulas: generate names and inspect conversion boundaries and changed-input results.

    Version and verification notes

    FreeOffice PlanMaker 2024 Windows English ribbon; FreeOffice-specific documentation and independent arithmetic only. Installed build, native workflow, save/reopen and screenshots unverified; no paid-2026 or other-platform parity.

  4. Edit matching monthly sheets together in FreeOffice PlanMaker

    Progress to intermediate workbook organization: edit only matching sheets, then prove later edits are isolated.

    Version and verification notes

    FreeOffice PlanMaker 2024 Windows English ribbon; FreeOffice-specific documentation and independent arithmetic only. Installed build, native workflow, save/reopen and screenshots unverified; no paid-2026 or other-platform parity.

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

Build and Update an Ordinary Chart in PlanMaker 2026

Create a direct-range column chart, verify series roles, extend its source, and distinguish automatic from manual updates.

Charts and visualization · Beginner

Unclassified: check guide

Guide’s version scope

PlanMaker 2026 paid desktop; documentation-qualified workflow for Windows, macOS and Linux. NX builds require matching controls; FreeOffice and mobile editions are not verified.

Center report headings without merging in FreeOffice PlanMaker

Center a title over a four-column report while keeping its cells separate and checking that the data still calculates correctly.

Cell formatting and layout · Beginner

FreeOffice 2024 Windows documentation

Guide’s version scope

FreeOffice PlanMaker 2024 for Windows, English ribbon; documentation-qualified. Installed build, native execution, save/reopen and screenshots unverified; no paid PlanMaker 2026 or other-platform parity claim.

Check spelling safely in FreeOffice PlanMaker with Hunspell

Correct ordinary worksheet text one occurrence at a time while protecting product codes, formulas and other sheets.

Text checking and data quality · Beginner

Unclassified: check guide

Guide’s version scope

FreeOffice PlanMaker 2024 for Windows, English ribbon; existing enabled English Hunspell dictionary required. Documentation-qualified only; no dictionary installation, settings change or native execution verified.

Compare Budget Scenarios in PlanMaker 2026

Save baseline, best-case and worst-case budget inputs, compare their results, and regenerate a scenario summary after assumptions change.

What-if analysis · Beginner

Unclassified: check guide

Create a Maintained Status Dropdown in PlanMaker 2026

Documented for PlanMaker 2026 paid desktop. Keep task statuses consistent with a cell-backed dropdown, audit pasted exceptions, and extend the allowed list safely. FreeOffice/mobile dropdown controls are unverified.

Data entry and validation · Beginner

Unclassified: check guide

Guide’s version scope

PlanMaker 2026 paid desktop; documentation-qualified workflow for Windows, macOS and Linux. NX builds require matching controls; FreeOffice and mobile editions are not verified.

Create and Reuse a PlanMaker Document Template

Create a reusable PlanMaker PMVX template, save independent requests and revise the master without changing earlier documents.

Templates · Beginner

Unclassified: check guide

Guide’s version scope

PlanMaker 2026 paid desktop, English ribbon interface; documentation-backed instructions, native application execution pending. NX builds require matching controls; compatibility with every NX build is not established here. FreeOffice 2024 and Android/iOS are outside this tutorial scope.

Find and Replace Values Safely in PlanMaker 2026

Replace selected PlanMaker constants while preserving formulas, case-sensitive exceptions and other worksheets, with an auditable practice fixture.

Find and replace · Beginner

Unclassified: check guide

Guide’s version scope

PlanMaker 2026 paid desktop, English ribbon interface; documentation-backed instructions, native application execution pending. NX builds require matching controls; compatibility with every NX build is not established here. FreeOffice 2024 and Android/iOS are outside this tutorial scope.

Format Numbers, Dates, Currency and Durations in PlanMaker 2026

Separate stored values from display, choose currency and date formats, preserve identifiers, show elapsed hours beyond 24, and test precision safely.

Number, date and currency formatting · Beginner

Unclassified: check guide

Guide’s version scope

PlanMaker 2026 paid desktop; documentation-qualified workflow for Windows, macOS and Linux. NX builds require matching controls; FreeOffice and mobile editions are not verified.

Freeze a Header Row in PlanMaker 2026

Keep row 1 visible while scrolling, use the classic-menu equivalent, and check a custom row-and-column boundary with a small inventory list.

Freeze panes and navigation · Beginner

Unclassified: check guide

Insert and maintain pictures and drawings in FreeOffice PlanMaker

Add a picture and a simple AutoShape beside a worksheet, preserve the underlying data, and check the saved copy.

Pictures and worksheet layout · Beginner

Unclassified: check guide

Guide’s version scope

FreeOffice PlanMaker 2024 for Windows, English ribbon; documentation-qualified only. No installed-build, native execution, screenshot, save/reopen or cross-platform parity claim.

Print a PlanMaker Sheet Without Tiny Text

Set a focused print range, choose orientation and scaling, and stop forcing one page when the result is too small to read.

Printing and PDF output · Beginner

Unclassified: check guide

Review and Navigate Cell Comments in PlanMaker 2026

Attach actionable notes to cells, find and edit comments, preserve them in saved files, and manage review copies deliberately.

Comments and navigation · Beginner

Unclassified: check guide

Guide’s version scope

PlanMaker 2026 paid desktop; documentation-qualified workflow for Windows, macOS and Linux. NX builds require matching controls; FreeOffice and mobile editions are not verified.

Split Text into Columns in PlanMaker 2026

Use PlanMaker Text to columns with a custom separator and safe destination so existing worksheet values are not overwritten.

CSV and data import · Beginner

Unclassified: check guide

Use AutoFilter in PlanMaker to Find Matching Sales

Filter PlanMaker sales by region and channel in FreeOffice 2024 or paid 2026; check matching records and restore hidden rows without deleting orders.

Data cleanup · Beginner

Unclassified: check guide

Guide’s version scope

FreeOffice 2024 English desktop ribbon documentation for Windows, macOS and Linux; separate retained paid PlanMaker 2026 English ribbon workflow. No native build, mobile or NX parity verification.

Intermediate

Add trendlines and error bars to a measurement chart

Add a linear trend and fixed measurement-error bars, distinguish their meanings and check a changed-data fit independently.

Charts and visualization · Intermediate

Unclassified: check guide

Guide’s version scope

PlanMaker 2024 paid Windows desktop, English ribbon; no 2026, FreeOffice or mobile parity claim.

Build a validated entry form with linked controls

Link a dropdown form object to a numeric selection index, validate fee output and test source-list maintenance.

References and calculation · Intermediate

Unclassified: check guide

Guide’s version scope

PlanMaker 2024 paid Windows desktop, English ribbon; no 2026, FreeOffice or mobile parity claim.

Build and check your first PlanMaker workbook

Build a two-item workbook, distinguish input cells from formulas, verify a quantity change and reopen the native saved file. Choose a documented FreeOffice 2024 basic-workbook route.

Workbook workflows · Intermediate

Unclassified: check guide

Guide’s version scope

Separate documentation-only routes: FreeOffice 2024 basic workbook and retained paid PlanMaker 2024 walkthrough, Windows desktop English ribbon; no native, 2026 or mobile parity claim.

Check Named Ranges Between PlanMaker and Excel

Use XLSX and a small named-range round trip to check names, references, scope and recalculation without assuming perfect compatibility.

File compatibility · Intermediate

Unclassified: check guide

Compare Values with Data Bars, Color Scales and Icons in PlanMaker

Build a PlanMaker report with data bars, color scales and icon sets, inspect range and threshold settings, and audit changed values.

Conditional formatting · Intermediate

Unclassified: check guide

Guide’s version scope

PlanMaker 2026 paid desktop, English ribbon interface; documentation-backed instructions, native application execution pending. NX builds require matching controls; compatibility with every NX build is not established here. FreeOffice 2024 and Android/iOS are outside this tutorial scope.

Consolidate monthly sheets by position or labels

Compare positional and label-based monthly consolidation, catch a matching error that preserves the grand total, and rerun static results.

Workbook workflows · Intermediate

Unclassified: check guide

Guide’s version scope

PlanMaker 2024 paid Windows desktop, English ribbon; no 2026, FreeOffice or mobile parity claim.

Copy Formulas with Fixed and Mixed References in PlanMaker

Build a reference matrix and compare relative, absolute and mixed references in a documented FreeOffice 2024 direct-copy branch or the separate paid PlanMaker 2026 fill-and-growth workflow.

Names and references · Intermediate

Unclassified: check guide

Guide’s version scope

FreeOffice 2024 English desktop ribbon direct-copy branch only; separate retained paid PlanMaker 2026 workflow. Exact installed-build, native application and save/reopen verification remain pending; no general edition or mobile parity claimed.

Create and apply range names in FreeOffice PlanMaker

Generate range names from column headings, apply them to selected formulas, and check which references remain relative in FreeOffice PlanMaker.

Formulas and named ranges · Intermediate

FreeOffice 2024 Windows documentation

Guide’s version scope

FreeOffice PlanMaker 2024 for Windows, English ribbon; documentation-qualified. Installed build, native execution, save/reopen and screenshots unverified; no paid PlanMaker or other-platform parity claim.

Create QR codes and barcodes from worksheet cells

Generate a QR picture and an EAN-13 barcode from synthetic cell values, check payload changes, and verify saved or exported output.

Presentation, collaboration and files · Intermediate

Unclassified: check guide

Guide’s version scope

PlanMaker 2024 paid Windows desktop, English ribbon; QR feature requires Professional or NX Universal; no 2026, FreeOffice or mobile parity claim.

Design Reusable Cell Styles and Layouts in PlanMaker 2026

Build a readable task sheet with reusable styles, controlled style inheritance, wrapped notes, and a repeatable reset.

Cell formatting and layout · Intermediate

Unclassified: check guide

Guide’s version scope

PlanMaker 2026 paid desktop; documentation-qualified workflow for Windows, macOS and Linux. NX builds require matching controls; FreeOffice and mobile editions are not verified.

Edit matching monthly sheets together in FreeOffice PlanMaker

Apply one shared header and formula to selected monthly sheets, then deselect them before entering different monthly quantities.

Workbook organization · Intermediate

FreeOffice 2024 Windows documentation

Guide’s version scope

FreeOffice PlanMaker 2024 for Windows, English ribbon and worksheet-tab controls; documentation-qualified, installed build and native execution unverified. No paid PlanMaker 2026, macOS, Linux, mobile or web parity claim.

Group pivot results by years and quarters

Group a two-year pivot by years and quarters, reconcile a quarter-boundary change, and distinguish grouping from refreshing.

Pivot tables and analysis · Intermediate

Unclassified: check guide

Guide’s version scope

PlanMaker 2024 paid Windows desktop, English ribbon; no 2026, FreeOffice or mobile parity claim.

Highlight whole records with formula-based formatting

Apply one formula rule to complete records, verify strict-threshold boundary cases and respect PlanMaker-specific relative-reference offsets.

Formatting and layout · Intermediate

Unclassified: check guide

Guide’s version scope

PlanMaker 2024 paid Windows desktop, English ribbon; no 2026, FreeOffice or mobile parity claim.

Link and Update Two PlanMaker Workbooks

Create an external reference, verify a saved source change, and distinguish current linked data from a stored fallback value.

External workbook references · Intermediate

Unclassified: check guide

Make a PlanMaker Table Expand with New Rows

Create a structured table, check automatic expansion, and handle new records safely when a total row is enabled.

Tables and structured references · Intermediate

Unclassified: check guide

Plot Paired Measurements in a PlanMaker XY Chart

Build a numeric-X PlanMaker scatter chart, verify paired ranges and unequal spacing, then update and extend measured data.

Charts and visualization · Intermediate

Unclassified: check guide

Guide’s version scope

PlanMaker 2026 paid desktop, English ribbon interface; documentation-backed instructions, native application execution pending. NX builds require matching controls; compatibility with every NX build is not established here. FreeOffice 2024 and Android/iOS are outside this tutorial scope.

Protect workbook structure and encrypt a saved file

Separate sheet-structure restrictions from saved-file read protection, then test a disposable encrypted copy without risking the original.

Sharing, safety and accessibility · Intermediate

Unclassified: check guide

Guide’s version scope

PlanMaker 2024 paid Windows desktop, English ribbon; no 2026, FreeOffice or mobile parity claim.

Recover Earlier Work with PlanMaker Backups and File Versions

Distinguish FreeOffice 2024 simple backups from paid PlanMaker 2026 file versions, and preserve current work when checking an earlier copy.

Recovery · Intermediate

Unclassified: check guide

Guide’s version scope

FreeOffice 2024 simple-backup branch, plus a separate PlanMaker 2026 paid desktop rehearsal in the English ribbon interface; documentation-backed, native application execution pending. Paid instructions do not apply to FreeOffice. NX builds require matching controls; compatibility with every NX build is not established here. Android/iOS are outside this tutorial scope.

Refresh a Pivot Chart in PlanMaker 2026

Update the source pivot, expand its source range for new records, and verify the chart against independently checked sales totals.

Pivot tables and charts · Intermediate

Unclassified: check guide

Sort PlanMaker Records by Multiple Keys

Reorder complete records by region and amount, preserve identity and restore original order in a documented FreeOffice 2024 six-record sort; use the separate paid PlanMaker 2026 workflow to include new rows and check saved files.

Sorting and filtering · Intermediate

Unclassified: check guide

Guide’s version scope

FreeOffice 2024 six-record sort/edit/restore branch plus retained PlanMaker 2026 paid desktop workflow for Windows, macOS and Linux; documentation-qualified English ribbon instructions, not native application verification. NX builds require matching controls; mobile editions and blanket FreeOffice parity are not established.

Understand PlanMaker Function-Language Settings

Separate localized function names from spelling language and number separators, then rebuild a small formula safely in your installed language.

Formula entry and language · Intermediate

Unclassified: check guide

Use Goal Seek in PlanMaker to Reach a Target

Set up a simple target-profit calculation in PlanMaker 2026 Goal Seek and understand the formula, target and variable cell fields.

Analysis and formulas · Intermediate

Unclassified: check guide