Prepare the worksheet

Data Manipulation

Recode, compute, filter, and reshape Excel data into a new worksheet — without overwriting the original range.

Build a reusable preparation recipe, preview each step, then write a Prepared_Data sheet. A built-in survey sample lets you try the workspace immediately.

Designed for serious statistical analysis inside Excel.

Why analysts choose Statistico

Instead of overwriting formulas or copying columns by hand, Statistico builds a preparation recipe you can preview, reorder, and apply to a new worksheet.

From messy columns to an analysis-ready sheet — this is Interactive Statistical Computing, not a one-off Excel edit.

Recode
Compute
Filter
Reshape

What the module provides

Recode values into a new column
Compute formulas from existing columns
Reverse-score Likert items
Build composite scores
Filter cases and flag duplicates
Reshape wide data to long
Preview each step before writing
Leaves the original Excel range untouched
Interactive workflow

From selected range to a prepared worksheet

Each operation is previewed and stacked in a recipe — the source sheet is never overwritten.

Select Range
Choose Operation
Preview Step
Build Recipe
Create Sheet
Recipe

Steps stay inspectable, not buried in Excel edits

Stack recode, compute, filter, and reshape operations. Disable or reorder a step and preview again before writing the new sheet.

Recode Compute Reverse-score Composite Filter cases Drop variables Wide to long Survey sample
Stays connected

The original worksheet is never overwritten

Pick the Excel range in the input panel, or load the built-in survey sample. The recipe writes a new Prepared_Data worksheet and leaves the source range intact.

Why Statistico

Built for analysts who already know the method

Excel remains the working data environment.

Recipes stay inspectable, never a hidden sequence of Excel edits.

Preparation supports the analysis rather than replacing data judgment.

A preparation recipe speeds up cleaning, but does not replace checking codes, missingness, and whether a recode or filter is appropriate.

Explore Data Manipulation as part of the workflow