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.
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 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.
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
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.
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.
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.
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.
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.
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.
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.
Use PlanMaker Special filter dialog conditions and Copy to position to extract checked records without a worksheet criteria grid.
Sorting and filtering · Intermediate
Unclassified: check guide
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.
Create nested PlanMaker row and column outlines, preserve visible totals, and remove grouping safely.
Workbook organization · Intermediate
Unclassified: check guide
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.
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
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
Learn what PlanMaker 2026 dynamic array functions do, test a small sorted unique-list example and avoid spill-cell conflicts.
Analysis and formulas · Intermediate
Unclassified: check guide
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.
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.
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.
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
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.
Build a PlanMaker 2026 pivot table from a simple sales CSV and verify each region/channel total before sharing the summary.
Analysis and formulas · Intermediate
Unclassified: check guide
Use predecessors, successors, syntax highlighting and the watch list to find a wrong reference and verify its repair.
Formula auditing · Intermediate
Unclassified: check guide
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
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