LTEN
All services

Excel servicesfor your tasks.

From a broken formula to monthly reporting. We build and improve Excel workbooks, prepare data and automate repetitive work.

Discuss your Excel task
Sales overview.xlsx
Sales by customerEUR
Customer A€3,650
Customer B€850
Total€4,500

3 records. 2 customers. One clear view.

Illustrative example · synthetic data

See where the numbers change.

Excel reports and summaries

Sales, expenses, budgets and operational summaries in a workbook you can continue using and editing yourself.

  • PivotTables and charts
  • Budget versus actual comparisons
  • Templates built around your workflow
Discuss this task
Where did spending differ?Budget example
BudgetActual
Premises€0
€1,200
€1,200
Transport+€150
€900
€1,050
Supplies-€150
€600
€450

Budget and actual side by side. Differences at a glance.

Illustrative example · synthetic data

Formulas you can rely on.

Formulas and workbook fixes

Fix calculations, organise tables more clearly and extend the files your team already uses.

  • Formula development and troubleshooting
  • Lookup, aggregation and logical calculations
  • Reference and calculation-result checks
Discuss this task
Same code. Different entry.Lookup formula example
Before" A-104 "#N/A
Remove extra spacesTRIM(A2)
After"A-104"€125

Once the code matches, the lookup returns its price.

Illustrative example · synthetic data

Stop copying each file separately.

Data preparation and Power Query

Combine separate files into consistent data, with repeatable import and preparation steps.

  • Combine Excel and CSV files
  • Clean duplicates, dates and formats
  • Power Query workflows for repeat imports
Discuss this task
Separate files → one tablePower Query
January.xlsx
February.xlsx
March.xlsx
CombineStandardiseCheck
MonthAmount
January€1,200
February€850
March€2,450

Reuse the prepared import steps next time.

Illustrative example · synthetic data

Turn repeated steps into a workflow.

VBA and macros

Automate repetitive steps, from processing files to preparing a report. We agree the Excel environment before work begins.

  • Automate repeated tasks
  • Macros for file and report preparation
  • Fix and extend existing VBA code
Discuss this task
Repeated work → a defined sequenceMacro workflow
  1. Open filesSelect the agreed sources
  2. Prepare tablesApply formatting and calculations
  3. Prepare the reportSave the agreed result

The trigger and compatibility depend on your Excel environment.

Illustrative example · synthetic data

Excel or HTML?

The format depends on how you will use the result. A project can include both versions.

Work with the data

Excel — for entering data, calculating and editing in the workbook.

Explore and share

HTML — for a clear, interactive report in the browser.

See HTML examples
Compare the formats in detail
NeedExcelHTML report
EditingEnter data, use formulas and work directly in the workbook.View report data and use the agreed interactive features.
ViewingWorksheets, summaries, PivotTables and charts.Metrics, charts, filters and tables in a browser.
SharingShare a workbook or use it within an agreed environment.A standalone HTML file or an agreed publishing method.
EnvironmentFeature compatibility depends on your Excel version.View in a modern browser.

Where do we start?

Briefly describe your task in the enquiry. We will agree how to transfer files when we get in touch — the form does not accept attachments.

Excel, Power Query and VBA work is quoted individually after reviewing the files, calculations and agreed scope.

Discuss your Excel task
  • What files and data do you have?
  • What result would be useful?
  • Which Excel version and operating system do you use?
  • Which tasks do you repeat, and how often?

A few answers before we begin.

Can you fix an existing workbook?

Yes. We can start with your current workbook, check formulas, improve its structure and add agreed features. We assess the file and its complexity before work begins.

Will Power Query update data automatically?

Power Query can repeat the import and preparation steps we build. The way updates are triggered and the data sources are agreed for your environment. Scheduled refresh is assessed separately.

Will macros work in a browser?

VBA macros do not run in Excel for the web. We agree the desktop Excel version, operating system and required features before work begins.

What file will I receive?

Depending on the task, we deliver an Excel workbook (.xlsx), a macro-enabled workbook (.xlsm) or another result agreed in advance, with guidance on the agreed features.

How much will my task cost?

The price depends on the condition of your files, calculations, automation and validation required. We discuss your needs and provide an individual quote. The HTML report starting prices are a separate offer; Excel work is quoted for your task.

What would you liketo improve in your workbook?

Describe your current workflow and the result you need. We will discuss a suitable solution and its scope.

Discuss your Excel task