SELECTED WORK

Proof of thinking.
Not just a gallery.

Real categories of Excel projects and workflow improvements from previous work. Client details are anonymized; time figures are based on previously reported outcomes.

PROJECT EXAMPLES

Excel solutions in the real world.

The best automation is the one people keep using.

Excel VBA · Data consolidation

Automated reporting imports

A recurring reporting import that previously required extensive manual handling was rebuilt into a repeatable Excel workflow.

45 min → ~1 minReported processing time improvement

Automated file selection, mapping, cleanup, and structured output. Exact implementation details are confidential.

Excel reporting · Batch processing

Management report consolidation

Instead of manually preparing reports one at a time, a batch workflow standardized consolidation and output.

~40 min → 4–5 min batchReported workflow change

Organized inputs, consistent transformation rules, and reusable reporting outputs.

Excel Tables · VBA · UserForms

Excel customer relationship manager

A structured customer and sales tool with searchable records and application-like controls, designed around a business’s everyday process.

CRM-styleExcel-based user experience

Record editing, validation, customer/order/payment tracking, and guided interactions.

Excel operations · Planning

Production and readiness scheduler

A custom Excel planning tool to manage assignment, dates, and operational status without losing visibility across the workflow.

OperationalPlanning and tracking

Structured planning tables, date logic, updates, and status reporting.

Excel formulas · VBA · Business rules

Sales and commission tracking

Multi-period commission and payment logic that considers agreement types, irregular payments, lifetimes, and changing business rules.

Rules-ledCalculation and validation

Transparent inputs, repeatable calculations, and audit-friendly reporting.

Excel data analysis · Manufacturing

Quality and process control reporting

Excel tools shaped by hands-on manufacturing and failure-analysis experience to reduce repetitive charting and organize technical information.

RepeatableReporting workflow

Process-aligned templates, chart generation, and consistent inputs.

WANT TO SEE MORE?

Let's discuss a similar workflow.

Many commissioned projects involve confidential client data. I can explain relevant methods and how I would approach your specific requirements without exposing anyone else's information.

Discuss a project
XL / VBACustom systems · not templates
LET’S SOLVE IT

Have a spreadsheet problem that looks familiar?

Describe the workflow, the input files, and what you wish Excel could do. We can work out a practical next step.

Start a project conversation