Clean, Extract, and Summarise Messy Data in Excel
A spreadsheet can look tidy and still be wrong. Turn an awkward export or inherited worksheet into a refreshable.
Technician tools and field notes
Practical support methods, scripts and specialist tools.
Start here
Choose a subtopic below, or filter this collection by format and difficulty.
7 guides
Use careful operational methods for the specialist tools and data tasks that support teams encounter in real work.
Back to the category mapA spreadsheet can look tidy and still be wrong. Turn an awkward export or inherited worksheet into a refreshable.
An enterprise browser deployment has two products: the browser installed today and the update/policy process that keeps it trustworthy tomorrow.
A legacy application can still be essential even when its vendor, operating system, database or installer is no longer supported.
Markup and margin both describe gross profit, but they divide by different numbers. That is why a 25% markup does not produce a 25% margin.
“Runtime error 91” or “Pastel update failed” is not enough to choose a fix. Diagnose a Sage/Pastel update or runtime error from the exact product.
Protect employer records, identify whether the fault is installation, access, payroll import, reconciliation, online handoff, or submission status, and repair only the failed stage.
A script becomes operational automation when another person can predict its scope, interpret every outcome and run it again safely.
3 guides
Keep device management, automation, monitoring and platform transitions accountable from enrolment through verified handover.
Back to the category mapCustom attributes can turn an endpoint platform into a useful operational database—or a pile of stale strings that trigger the wrong machines.
An RMM platform is a privileged control plane, not merely an asset list.
“Agent offline” is a relationship failure between endpoint and platform. Determine whether an RMM patch agent is absent.
1 guide
Diagnose Linux services, storage, networking, permissions and lifecycle from current state and distribution-appropriate evidence.
Back to the category mapBuild a reliable, privacy-conscious Linux incident timeline from bounded journal and file searches by recording the host, boot, clock, time zone.
1 guide
Work with Apple platform ownership, recovery and system controls without treating macOS as a Windows-shaped endpoint.
Back to the category mapSafely distinguish a macOS update problem, login/startup-software problem, system-volume problem and likely hardware failure.
1 guide
Protect data and account ownership while diagnosing mobile access, enrolment and recovery paths.
Back to the category mapThe Contacts app is a view, not necessarily the address book. Find out which account or device actually owns each Android contact.
7 guides
Diagnose Windows from effective configuration, logs and lifecycle state before applying repair commands or broad resets.
Back to the category mapLocate the first missing or failing layer between an application and paper—physical printer.
Windows may report an error against Disk 3, \Device\Harddisk2\DR5, a volume GUID, a controller port or a PnP instance.
Open Windows Terminal or PowerShell with administrative rights in a known folder.
Windows includes several administration interfaces because they answer different questions.
Windows can record thousands of warnings and errors on a healthy computer.
A Windows service can be installed but stopped, running but unusable, or healthy while the application fails somewhere else.
A link is small, but it crosses several boundaries: filesystem, path syntax, permissions and the program opening it.
Looking for something else?
Browse every current guide or search by the symptom, platform or outcome you have in mind.
Browse every guide