When cleaning up large Excel or Power Query files, available memory and using a suitable 64-bit version of Excel are important considerations. Microsoft lists both as possible ways to address resource issues. You should also count the power supplies needed for the PC, monitor and peripherals: a compact PC does not mean you can do without a separately powered monitor. Finally, compare the exact configuration, including its software, ports, included components and applicable EU conformity information.
Who is this choice relevant to?
If you clean up large surveys
You sort, combine or edit larger files in Excel or Power Query, and want to match your memory and software version to your workload. Microsoft Learn lists a 64-bit version of Excel and more available memory as possible ways to address resource issues.
If you have limited access to sockets
You need to be able to connect the PC, monitor and any peripherals to the available mains sockets. The plugs you need will depend on your chosen equipment and power solution.
If you manage respondent data
You may be processing responses that could identify individuals, so you need to put appropriate data security measures in place as well as choosing a computer. The Dutch Data Protection Authority explains that organisations must protect personal data properly.
What should you look for?
Start with the files and software you use, then count the power supplies you need and compare the exact configuration, including components, ports and conformity information.
| What to consider |
What should you check? |
Who is this most relevant to? |
| Memory and files |
Compare your file sizes and the tasks you perform with the installed RAM and the version of Excel you use; check whether the memory can be upgraded. |
If I combine or edit large workbooks, I want to know whether my software and available memory are suitable for the workload. Around 29% of consumers prioritise having enough processing capacity. |
| Power sockets needed |
Count the power supplies for the PC, monitor and peripherals, and check which mains cables are included with the configuration. |
With limited access to sockets, I want to know in advance how many devices need their own mains connection. Around 23% of consumers prioritise a workspace that fits the available connections. |
| Software and ports |
Check the included operating system, the monitor connection you need and the ports for your existing peripherals. |
If I want to keep using my existing analysis software and monitor, I don’t want to discover after buying that a connection or installation is missing. Around 18% of consumers prioritise this compatibility. |
| Protecting responses |
Work out whether the survey data could identify individuals and which security measures are appropriate for your organisation and risk assessment. |
When I process respondent data that could identify individuals, I want to factor security into how I manage it, rather than focusing only on the computer. Around 18% of consumers prioritise data protection. |
| Complete configuration |
Check which components are actually included, such as memory, storage, operating system, adapter and any installation. |
If I want to know in advance what I need for my workspace, I also need to factor in any missing components and installation. Around 12% of consumers prioritise a complete overview of the configuration they need. |
Buying pitfalls
-
Assuming a mini PC only needs one plug
The PC and monitor may each need their own power supply. A small case on its own tells you nothing about how many sockets the whole workspace will use.
Plan the plugs and cables for your complete setup in advance. Don’t connect extension leads to one another to make up for a lack of sockets; the Fire Service advises against simply linking extension leads together.
-
Treating a barebone as a complete PC
A kit may not include memory or storage. Also check whether your preferred operating system is included before assuming you can get started straight away.
Check the box contents for the exact model number and work out which components and installation you still need.
-
Assuming the manufacturer’s warranty covers all your warranty rights
When you buy as a consumer in the Netherlands, your statutory warranty rights apply alongside any commercial or manufacturer’s warranty. A manufacturer’s warranty does not replace those statutory rights.
Keep your purchase and configuration details, and report a fault with a defective product to the seller first. ACM ConsuWijzer explains the difference between statutory warranty and the seller’s warranty.
Brands to compare for this choice
Lenovo
The ThinkCentre M70q Gen 5 is a business-focused mini PC range; the configuration reviewed is 12TD0017MH.
- For configuration 12TD0017MH, Lenovo lists a Core i5-14400T, 16 GB RAM and a 512 GB SSD.
- The monitor is sold separately. The specified 90 W adapter rating is not a measurement of actual power consumption.
HP
The Pro Mini 400 G9 is a pre-configured business mini PC; the configuration reviewed is 9H6Z2ET#ABH.
- For this configuration, HP lists Windows 11 Pro, a Core i5-14500T, 16 GB RAM and a 512 GB SSD.
- Check the exact configuration and included components to make sure it suits your software and workspace.
ASUS
The NUC 14 Pro is available as a mini PC or as a kit for those who want to build their own configuration.
- The different configurations give you flexibility to choose the setup you want.
- ASUS states that memory and storage are not included with the NUC 14 Pro Kit. The adapter and mains cable may vary by configuration or region.
MSI
The Cubi NUC range is a configurable business mini PC line with various display and storage options.
- MSI describes memory and storage upgrade options for the range.
- Power supplied through a selected monitor only works with a compatible combination; don’t assume every monitor or configuration supports it.
Joybuy products
These mini PCs are intended to help you compare configurations for data processing. For each configuration, check the memory, storage, ports, included power supply and operating system. Also check the applicable EU conformity information for the specific device and power supply. The European Commission and the Dutch government explain the applicable CE rules for products covered by those rules.
No image available
SOYO Y5Pro mini PC
Compare the listed memory configuration with the size of your own survey files.
Intel Core i5 8250U/8350U; 8 GB DDR4; 256 GB SATA SSD; Windows 11; Bluetooth 5.2 and Wi-Fi 5.
The product description lists two HDMI outputs, one Type-C video output and four USB ports.
Joybuy
No image available
ACEMAGIC AK1PLUS mini PC
The listed 16 GB RAM is worth considering when comparing configurations for Excel files; choose one that suits your own workload.
Intel Celeron N5095 (4C/4T); 16 GB LPDDR4X; 256 GB M.2 2280 SATA SSD; Windows 11 Pro.
The title lists HDMI 2.0, 4K 60 Hz and Wi-Fi 5.
Joybuy
No image available
ACEMAGIC E3B mini desktop
This configuration lists 16 GB RAM and can be compared with your own file-editing and display connection needs.
AMD Ryzen 5 7430U; 16 GB LPDDR4X 3200 MT/s; 512 GB M.2 2280 SATA SSD; Windows 11 Pro.
The title lists HDMI 2.0, DisplayPort 1.4b and USB-C video output.
Joybuy
No image available
FIREBAT R3 mini PC
Compare the listed memory and storage configuration with your files and the programmes you want to use.
AMD Ryzen 5 7430U; 16 GB RAM; 512 GB SSD; Wi-Fi 6 and Bluetooth 5.2.
The title lists support for three 4K displays.
Joybuy
No image available
Lenovo ThinkCentre M70q Gen 5, Core i7-14700T
Before choosing this configuration, check which power supply it needs and whether it is included.
16 GB DDR5-SDRAM; 512 GB SSD; Windows 11 Pro.
The product description states that the power adapter is not included and must be purchased separately.
Joybuy
Frequently asked questions
What can you do if Excel reports a memory error with large survey files?
Microsoft lists processing less data at a time, closing other applications, using a 64-bit version of Excel and increasing available memory as possible measures. Start by looking at your own files and workload; a specific amount of RAM does not guarantee that every task will run successfully.
Can you mount the mini PC behind the monitor without needing another socket?
Not simply by mounting the PC behind the monitor. MSI describes power supplied through a monitor selected for this purpose; check that both the exact PC configuration and the monitor support this combination.
Does a 90 W adapter automatically use less power when cleaning up files?
No. The adapter’s specified power rating is not a measurement of consumption during your work. ASUS also lists different adapters for different NUC 14 Pro configurations; only compare actual power consumption on a like-for-like basis.
What product safety information should you check for a mini PC?
For the specific device and power supply, check which applicable EU product rules and CE marking requirements apply. The European Commission explains the manufacturer’s role in conformity assessment; a product page alone does not confirm that every configuration offered complies.
What rules apply if survey responses include personal data?
If an organisation processes personal data, it must protect that data appropriately. The Dutch Data Protection Authority explains that choosing security measures starts with a risk assessment; a mini PC or an individual security feature does not replace that assessment.