Who is this choice for?

Anyone indexing duplicate reviews

You’re combining review lists and want to establish which entries really match before deleting any data. Microsoft Support explains that Power Query checks for duplicates based on the columns you select.

Anyone viewing reviews and an index side by side

You regularly compare reviews with an index at one workstation, so screen space and a keyboard layout suited to your data entry are important.

Anyone moving between workstations

You take your laptop with you and weigh up screen space against the convenience of a more compact size.

What should you look for?

Windows laptop with Excel

A good fit if: you want to carry out recurring imports and checks on selected columns in Excel.

Keep in mind: check that the version of Excel you use includes the features you need. Microsoft Support describes Power Query for Excel on Windows, Mac and the web.

MacBook with Excel for Mac

A good fit if: you want to keep using macOS and Power Query in Excel for Mac suits your workflow, as described by Microsoft Support.

Keep in mind: test your own files and tasks in the version of Excel you plan to use. Don’t assume every feature will work in the same way.

Laptop with Google Sheets or LibreOffice Calc

A good fit if: the features available in Sheets or Calc suit the way you enter and check reviews.

Keep in mind: Google Docs Editors Help describes a feature for removing duplicates from a selected range. LibreOffice Help notes that the Calc method described for unique values is case-sensitive.

Consideration What should you check? Who does this matter to most?
Checking duplicate records Decide which columns together identify a review, and test the operation on a copy first. If I want to check repeated titles without losing unique reviews, I look at the duplicate-checking feature first; around 31% of consumers give this check top priority.
Reading and entering data Compare the screen size of the exact configuration and check the keyboard layout. When I view review text and an index side by side and enter lots of data, I look for screen space and a comfortable keyboard; around 25% of consumers prioritise reading and typing comfort.
Taking it between workstations Compare the screen size, weight and ports of the specific model. If I often take my laptop with me, I weigh portability against having enough screen space for indexing; around 19% of consumers make portability their top priority.
Software and costs Check which version of Excel or alternative you use, and test it with one of your own sample files. When I don’t want to choose extra software before finding out what my current programme can do, I check the available features first; around 13% of consumers prioritise software suitability and cost.
Data protection Establish whether files contain personal data and what security measures and recoverable backups are appropriate for the way you handle them. If my index contains information that could identify people, I want to protect it carefully; around 12% of consumers give data protection top priority.

Common pitfalls

  • Treating every review with the same exhibition name as a duplicate

    A repeated exhibition name doesn’t automatically mean it’s the same review. As Microsoft Support explains, Power Query’s comparison depends on the columns you select.

    Decide which fields together identify a review, then check the results on a copy before deleting any rows.

    If you delete unique index data, it may take time to restore it.

  • Assuming spreadsheet programmes handle duplicates in the same way

    The result can depend on the programme’s features and settings. The method described for unique values in LibreOffice Calc is case-sensitive, while Google Sheets has its own duplicate-handling feature.

    Test familiar sample records in the programme you plan to use, including titles that differ only by capitalisation.

  • Confusing a product range name with the exact laptop configuration

    Keyboard layouts and other features can vary between configurations. For example, Lenovo lists an English (EU) keyboard for the ThinkPad E14 Gen 7 configuration 21T9001TMH.

    Check the full model number and specifications of the configuration you’re considering, especially the screen and keyboard layout.

Brands to compare

Lenovo

The ThinkPad E14 Gen 7 is a business Windows laptop with a 14-inch screen, suited to anyone looking for a more compact size.

  • For configuration 21T9001TMH, Lenovo Netherlands lists Windows 11 Pro, 16 GB RAM, a 512 GB SSD and an anti-glare 1920 × 1200 screen.
  • This configuration has an English (EU) keyboard. Check that the layout suits the way you enter data.

HP

The 16-inch ProBook 4 G1i is a Windows option for anyone who wants a larger screen at a dedicated workstation.

  • For configuration D4TM6EA#ABH, HP lists a 16-inch WUXGA screen, 16 GB RAM and a 512 GB SSD.
  • These specifications apply to the configuration listed. Check the setup of the specific model you’re considering.

ASUS

The ExpertBook B1 B1502CVA-BQ0491X is a business laptop with a QWERTY layout, as specified by ASUS.

  • ASUS lists a Full HD screen and QWERTY keyboard for this model.
  • Check the memory, ports and support services for the exact configuration on sale; features of other ExpertBook B1 models won’t necessarily apply.

Apple

The MacBook Air offers a macOS option for anyone who wants to carry out indexing work on a Mac.

  • Apple lists 13-inch and 15-inch configurations. Microsoft Support confirms that Power Query is available in Excel for Mac.
  • This doesn’t confirm that every Excel feature or existing workflow works the same way on Mac as it does on Windows. Test your own files and version.

Acer

The TravelMate P2 range includes business Windows configurations, so check the model number and generation.

  • For the TMP215-53, NX.VQBEH.006, Acer lists a 15.6-inch Full HD screen, 16 GB RAM and a 512 GB SSD.
  • These specifications apply to that configuration and not necessarily to every TravelMate P2.

Joybuy products for spreadsheet and indexing work

This selection includes laptops with a range of screen sizes and configurations for spreadsheet and indexing work. Check each configuration to make sure its software and keyboard layout suit the way you work.

HP OmniBook 3 16-by0058ndx laptop

HP OmniBook 3 16-by0058ndx

The 16-inch screen and numeric keypad suit comparing and entering data at a dedicated workstation.

16-inch IPS screen, 1920 × 1200 resolution, 16:10 aspect ratio, 8 GB RAM and 512 GB SSD. Power adapter not included.

Joybuy
HP OmniBook 5 Flip 14-fp0250ndx 2-in-1 laptop

HP OmniBook 5 Flip 14-fp0250ndx 2-in-1

The 14-inch size may suit you if you want to view documents and move between workstations.

14-inch IPS touchscreen with 1920 × 1200 resolution and a 16:10 aspect ratio; the 360-degree hinge supports laptop, tablet, tent and stand modes. International English QWERTY keyboard; a suitable USB-C charger and stylus are not included.

Joybuy
ASUS Vivobook S16 S3607QA-SH109W laptop

ASUS Vivobook S16 S3607QA-SH109W

The 16-inch screen gives you room to view review text and an index side by side.

16-inch WUXGA OLED screen, Snapdragon X processor, 16 GB LPDDR5X and 512 GB SSD.

Joybuy
Auusda T161N laptop

Auusda T161N

The 16-inch screen and numeric keypad may suit data entry at a fixed workstation.

16-inch IPS screen with 1920 × 1200 resolution, i3 1000NG4 processor, 16 GB DDR4 RAM, 1 TB SSD and fingerprint unlocking.

Joybuy
Lenovo V15 G5 IRL laptop

Lenovo V15 G5 IRL

The 15.6-inch anti-glare screen is worth considering if you want to view documents and an index side by side.

15.6-inch Full HD screen, Intel Core i5-13420H, 16 GB DDR5 memory and 512 GB SSD. The product description lists an English keyboard.

Joybuy

Frequently asked questions

Should I delete duplicate reviews straight away?

No. First check which columns you’re using to identify a duplicate. Microsoft Support distinguishes between temporarily filtering duplicates and deleting them permanently; Power Query bases its comparison on the columns you select.

Can I use a Mac if I want Power Query?

Yes. Microsoft Support lists Power Query for Excel on Mac. Make sure the features and data sources you need for your workflow are available in the version of Excel you plan to use.

How can I stop a clean-up from affecting my original index?

Start with a copy and check the selected columns before deleting any rows. The Dutch Data Protection Authority gives recoverable backups as an example of a security measure for organisations processing personal data.

What warranty and cooling-off period apply to a laptop bought online?

When you buy as a consumer, you’re entitled to the statutory guarantee that a product will work properly. For distance sales, a 14-day cooling-off period applies in many cases, according to the Dutch government. Check the terms and any exceptions for the specific purchase. A manufacturer’s warranty is separate from your statutory rights.

Do privacy requirements apply to my review register?

That depends on the data and how you process it. Names and other information that can identify someone may count as personal data. According to the Dutch Data Protection Authority, organisations must protect personal data properly. Buying a laptop alone doesn’t determine which measures you need for your data processing.