Who is this relevant to?

Excel data cleaner

You combine survey files or refresh import steps, and want to check first that your version of Excel includes the Power Query features you need. Microsoft Support outlines how features and data sources vary by version.

Working with several files at once

You keep spreadsheets, documentation and other programmes open side by side, and compare memory and storage with the files you work with. The Consumers’ Association recommends 16 GB where possible for smoother multitasking across several programmes.

Regular home worker

You spend long periods looking at spreadsheets at a desk and want the screen space and ports to suit your workspace. For employees who spend more than two hours a day working with a screen, Arboportaal sets out specific requirements for screens and keyboards.

What should you look for when choosing?

First check your software and data sources, then compare memory and file storage, and finally make sure the screen and ports suit your home workspace.

What to consider What should you check? Who should pay closer attention?
Software compatibility Check your version of Excel, your licence and the connectors you need for the import and refresh steps you use. If I rely on specific Power Query connectors, I want to know whether my existing steps will work on the system I choose; around 28% of consumers prioritise software compatibility.
Memory and file storage Compare the RAM with your needs and check that the SSD has room for source files and working copies. If you work with several programmes and large files at once, you’ll need enough space for those tasks; around 22% of consumers prioritise memory and storage.
Home workspace Balance screen space against portability and check the ports for an external screen and keyboard. If I spend a long time checking spreadsheets at a desk, I want a screen setup that suits my work; around 22% of consumers prioritise their workspace needs.
Protecting responses Check that storage, access and working from home comply with your organisation’s policies and risk assessment. If you process responses that could identify people, you’ll want to know whether you can work in the required secure environment; around 17% of consumers start with data protection.
Overall functionality Compare the complete specification and check whether your existing peripherals will connect without an extra adapter. If I want the right functionality without unnecessary spending, I first compare the specification and the connections I need; around 11% of consumers prioritise this trade-off.

Excel also has fixed worksheet limits. Microsoft Support states that each worksheet can contain up to 1,048,576 rows and 16,384 columns; more memory won’t change those limits.

Pitfalls to avoid when buying

  • Assuming all versions of Power Query are interchangeable

    Microsoft Support explains that features and data sources vary by version of Excel. Switching to a different operating system therefore doesn’t guarantee that every existing import step will still be available.

    Before buying, test the connectors and refresh steps you need with the version of Excel and licence you plan to use.

    You may need to use a different software version or adapt your existing import steps.

  • Assuming more RAM will solve every Excel limitation

    Memory and system resources matter, but Excel also has fixed row and column limits. More RAM won’t change these worksheet limits.

    Check the number of rows, file size and import method before choosing additional hardware.

  • Choosing a workspace based on the laptop alone

    For employees who spend more than two hours a day working with a screen, Arboportaal states that the screen and keyboard must not be attached to each other.

    Check your current setup and the ports on the configuration you choose. Discuss any changes you need with your employer.

  • Confusing a security feature with a secure data-handling process

    The Dutch Data Protection Authority links appropriate security measures to the risks involved in processing personal data. A laptop feature alone doesn’t determine whether your working practices are suitable.

    Follow the responsible organisation’s policies on storage, access and working from home.

Brands to consider

Lenovo

The ThinkPad E14 Gen 7 is a compact business Windows model to compare configurations against.

  • For configuration 21SXCTO1WWNL5, Lenovo lists 16 GB of memory, a 512 GB SSD and an anti-glare 14-inch screen.
  • These are specifications for that configuration, not measured performance figures for the entire ThinkPad range. The listed keyboard layout is English (EU).

HP

The ProBook 4 G1i range includes business Windows models. The 16-inch configuration reviewed is a useful comparison for anyone looking for a larger built-in screen.

  • For configuration A23QQEA#ABH, HP lists 16 GB of RAM, a 512 GB SSD, HDMI, Type-A and two Type-C ports.
  • These details apply to the configuration named and don’t automatically apply to other configurations.

Apple

The 13-inch MacBook Air M5 is a macOS option if the software and import steps you use are compatible with macOS.

  • For the base model, Apple lists 16 GB of memory, a 512 GB SSD and two Thunderbolt 4 ports.
  • Check the features available in your version of Excel and the connections needed for your screen and peripherals.

Dell

Latitude is a business Windows range worth comparing with other business configurations if support is a factor.

  • Dell describes Latitude as a range for working on the move and provides links to product support.
  • That positioning doesn’t tell you whether every Latitude configuration will suit your workload; compare a complete model code.

Joybuy laptops for working from home

These Joybuy laptops are options to compare for cleaning survey data and working with spreadsheets at home. Check that the software version, connectors and ports you need suit the way you work.

Auusda T156A laptop

Auusda T156A laptop

The listed screen and storage specifications are useful points of comparison for spreadsheet work and your local files.

15.6-inch FHD IPS screen; 16 GB DDR4 RAM; 512 GB SSD; 3050E processor.

The product description lists USB-C, USB-A and HDTV connections, a fingerprint reader and a backlit keyboard.

View at Joybuy
ASUS Zenbook A16 16-inch WUXGA

ASUS Zenbook A16, 16-inch WUXGA

The 16-inch screen and listed storage are worth considering if you work with spreadsheets and local files at home.

16-inch WUXGA anti-glare screen; 16 GB memory; 512 GB SSD; Windows 11 Home.

The product description lists two USB4 Type-C ports.

View at Joybuy
Lenovo IdeaPad Slim 5 15ARP10, 15.3-inch

Lenovo IdeaPad Slim 5 15ARP10, 15.3-inch

The listed screen size and storage help you weigh up spreadsheet work against the space available for files.

Ryzen 5 7535HS; 16 GB fixed, non-upgradeable memory; 512 GB SSD; Windows 11 Home.

15.3-inch WUXGA IPS anti-glare screen; QWERTY keyboard. The power adapter is not included; charging requires a 45–65 W USB-C Power Delivery adapter.

View at Joybuy
Microsoft Surface Laptop 7, 13.8-inch, Snapdragon X Elite

Microsoft Surface Laptop 7, 13.8-inch, Snapdragon X Elite

The screen size and storage are worth considering when choosing a home workspace and deciding where to keep your working files.

13.8-inch touchscreen; 2304 × 1536 resolution; 16 GB memory; 512 GB SSD.

The product description lists USB4 connectivity and Windows 11 Pro.

View at Joybuy
Microsoft Surface Laptop 7, 13.8-inch, Snapdragon X Plus

Microsoft Surface Laptop 7, 13.8-inch, Snapdragon X Plus

The screen size and storage are worth considering when choosing a home workspace and deciding where to keep your working files.

13.8-inch touchscreen; 2304 × 1536 resolution; 16 GB memory; 512 GB SSD.

The product description lists USB4 connectivity and Windows 11 Pro.

View at Joybuy

Frequently asked questions

Do I always need a Windows laptop for Power Query?

No. Microsoft Support lists Power Query for Excel on Windows, Mac and the web, but the available data sources and features vary by version. Check that you have the connector and Excel licence you need.

Is more RAM always enough for a very large survey file?

No. Memory and system resources matter, but Excel also has a worksheet limit of 1,048,576 rows and 16,384 columns. Check the size of your file and how you import and process the data.

What should I add to my home workspace if I use a laptop for long periods?

If you’re an employee who spends more than two hours a day working with a screen, Arboportaal states that the screen and keyboard must not be attached to each other. Check whether you can use a separate screen or keyboard, and discuss your setup with your employer.

Can I clean survey responses containing personal data on a personal laptop?

That depends on how the data is processed and your organisation’s policies. The Dutch Data Protection Authority requires organisations to apply appropriate, risk-based security measures and advises using a secure working environment and organisation-owned equipment when working from home, where possible. Follow the rules that apply to your data and working situation.

What do the manufacturer’s warranty and cooling-off period mean when buying a laptop online?

The Dutch government states that the Netherlands has no fixed statutory warranty period and that many distance purchases come with a 14-day cooling-off period. Exceptions may apply, so check the terms before buying. Your statutory rights if a product doesn’t meet the contract are separate from the manufacturer’s warranty.