Who is this workflow for?

Indexer checking duplicate entries

Compares advert entries, keeps references to the source and wants to review possible duplicates before removing any entries.

Researcher viewing scans alongside data

Checks advert text in historical newspapers against an index and needs a practical layout for comparing the source with the data entered.

Archive visitor with local files

Takes files along for source checks and weighs portability against the space needed for scans and other research files.

What should you consider when choosing?

Windows laptop

A good fit if: you regularly use Excel Power Query to import data and review possible duplicate rows.

Bear in mind: the results also depend on which columns you compare; differences in OCR text may need to be checked against the original.

MacBook

A good fit if: you work on macOS and have checked in advance that your version of Excel and your indexing software support the steps you need.

Bear in mind: Power Query features vary by Excel version; also check that the screen and ports suit your workspace.

Chromebook

A good fit if: you can do all your indexing work using suitable web apps and cloud files.

Bear in mind: the Microsoft 365 file editing workflow described by Google requires OneDrive; check that your offline workflow is suitable too.

What to consider What should you check? Who is this important for?
Software and duplicate checks Check your version of Excel and operating system; decide which fields to compare and keep an unchanged copy of the source file. If I want to review possible duplicate entries without accidentally removing source records, this check is my priority. Around 36% of consumers put duplicate checks first.
Room for the scan and index Compare the screen size and resolution with how you want to view the scan and data side by side. If I want to check the source material and index at the same time, I focus on a screen layout that works for my files. Around 29% of consumers prioritise having enough screen space to read the scan and index.
Local storage Work out how many scans and work files you’ll keep locally, and check the SSD capacity of the exact configuration. If I want to keep my own collection locally, I want storage that suits my files. Around 21% of consumers give local storage top priority.
Taking it to archives Compare the dimensions and weight with your travel plans; also check the charger and charging options at the places you usually visit. If I work at different research locations, portability matters most to me. Around 14% of consumers make portability their top priority.

Microsoft Support describes Power Query for Excel 2016 and later on Windows; availability and features can vary by platform and version. The columns you select determine which rows are treated as duplicates. An advert with different OCR text may therefore still need to be checked against the scan.

Common buying and usage mistakes

  • Confusing duplicate removal with checking historical sources

    The columns you select determine which values Power Query compares. Removing duplicates takes repeated values out of the edited list; filtering hides them temporarily. A repeated advert may also be a separate placement.

    Keep the original file and check possible matches against the scan before merging or removing any records.

  • Assuming a laptop range has one fixed configuration

    A product range can include different processors, operating systems and configurations. The specifications of one model do not necessarily apply to every configuration.

    Check the full model number and the specifications of the configuration you’re considering.

  • Confusing a cloud workflow with local editing

    The Microsoft 365 file editing workflow on a Chromebook described by Google requires OneDrive.

    Test a representative index file to check that the features you need and the file location work with your workflow. Bear in mind the cloud storage and setup you’ll need.

  • Assuming searchable newspapers mean adverts can be freely republished

    The KB points out that more recent newspapers may be subject to copyright and privacy rights. Access to searchable sources does not, by itself, mean you can freely publish adverts.

    Before publishing, check the rights and terms for the specific source and intended use.

Brands to consider

Lenovo

The ThinkPad E14 Gen 7 is a useful reference if you’re looking for a Windows workflow on a 14-inch laptop.

  • Configuration 21T9001TMH lists Windows 11 Pro, 16 GB memory, a 512 GB SSD and an anti-glare screen with a resolution of 1920 × 1200 pixels.
  • Check the availability and exact configuration of the model you’re looking at; specifications do not necessarily carry over to other models.

ASUS

The ExpertBook B1 B1503 range is worth considering if you’re looking at a larger built-in screen for checking sources.

  • ASUS lists an anti-glare 15.6-inch Full HD screen for the B1503CVA range.
  • The range includes several processors and configurations, so check the specific model rather than assuming there’s one fixed specification.

Apple

A 13-inch MacBook Air with M5 offers a compact macOS option if you’ve checked in advance that it supports the software features you need.

  • For the base configuration described, Apple lists 16 GB memory, a 512 GB SSD, a 13.6-inch screen and two Thunderbolt 4 ports.
  • Check that your version of Excel for Mac includes the Power Query features you need, and that the screen space and ports suit your work.

Dell

The Latitude 5450 is an example of a business Windows range with different processor and operating system options.

  • The range can be a useful reference when comparing business Windows configurations.
  • Check the specifications and availability of the exact model; information about the product range does not confirm the configuration of another model.

Joybuy laptops for this workflow

These Joybuy laptops are Windows models for viewing scans alongside index data and storing work files.

HP OmniBook Ultra Next Gen AI 16-bk0002nd laptop

HP OmniBook Ultra Next Gen AI 16-bk0002nd

The listed 16-inch screen may suit a workflow where you view the source and index side by side.

16-inch 3K OLED touchscreen with 120 Hz; 64 GB RAM; 2 TB SSD; Windows 11 Pro; QWERTY keyboard.

Use an HP adapter approved for this model and keep the ventilation openings clear.

View at Joybuy
HP OmniBook Ultra Next Gen AI 16-bk0001nd laptop

HP OmniBook Ultra Next Gen AI 16-bk0001nd

The listed 16-inch screen may suit you if you want room for source material alongside your data while indexing.

16-inch 3K OLED touchscreen with 120 Hz; 32 GB RAM; 1 TB SSD; Windows 11 Pro; QWERTY keyboard.

Use an HP adapter approved for this model and keep the ventilation openings clear.

View at Joybuy
Ruzava 15.6-inch laptop with N5095 processor

Ruzava 15.6-inch laptop, N5095

The 15.6-inch screen may be useful if you want to view source material and the index side by side.

FHD screen; 8 GB RAM; 256 GB SSD, expandable to 1 TB according to the product name; N5095 processor; Windows 11 Pro.

View at Joybuy
HP OmniBook Ultra Next Gen AI 16-bk0004nd laptop

HP OmniBook Ultra Next Gen AI 16-bk0004nd

The listed 16-inch screen may suit a workflow where you view scans and index data side by side.

16-inch 3K OLED touchscreen with 120 Hz; 128 GB RAM; 2 TB SSD; Windows 11 Pro; QWERTY keyboard.

Use an HP adapter approved for this model and keep the ventilation openings clear.

View at Joybuy
Lenovo Yoga Pro 9 15N1X11 83SR0032MH laptop

Lenovo Yoga Pro 9 15N1X11 83SR0032MH

The listed 15.3-inch screen may suit you if you’re looking for a larger built-in screen for checking sources.

15.3-inch screen; 64 GB RAM; 1 TB SSD; QWERTY keyboard.

Keep the ventilation openings clear and use a compatible power adapter.

View at Joybuy

Frequently asked questions

Should I remove duplicate advert entries straight away?

No. Check possible duplicates before removing them. Filtering hides duplicate values temporarily, while removing them takes them out of the edited list. Microsoft Support says that Power Query uses the selected columns to identify duplicate values; keep the source file and compare matches with the scan.

Does Excel work on a Chromebook for this task?

It depends on the features and workflow you need. Google describes opening and editing Excel files through Microsoft 365 on a Chromebook; this workflow requires OneDrive. Also check that your index file and any offline work are suitable for the apps you choose.

What extra software, storage or accessories should I check?

Check whether the software, storage service and any adapters you need are included in your chosen setup. Also read about any additional costs listed by the seller. Paid extended cover does not replace your statutory rights under Dutch law.

Can I publish indexed historical adverts online?

Not automatically: being searchable does not, by itself, give you permission to republish material. The KB says that more recent newspapers may be subject to copyright and privacy rights, and that conditions may apply to reuse. Check the rights and terms for the specific source and intended use.

Who should I report a faulty laptop to if I bought it as a consumer in the Netherlands?

According to the Dutch government, you should contact the seller to resolve an issue under the statutory guarantee, rather than contacting only the manufacturer. A manufacturer’s guarantee or additional cover is on top of this.