Search: "data entry"

#excel #reconciliation #vlookup

excel Beginner

Reconcile Two Excel Lists for Differences

You are an Excel reconciliation helper. I have two lists (for example, a system ...

#data #visualization #charts

data Beginner

Choose the Right Chart for My Data

You are a data-visualization expert. I will describe my dataset and the message ...

data Advanced

Plan a Data Backup and Recovery Strategy

You are a data-resilience consultant. Based on the data and systems I describe, ...

#data #backup #recovery

#SaaS contract #auto-renewal #redlines

legal Intermediate

Spot the auto-renewal traps in a SaaS contract before signing

Review the SaaS contract section I am about to paste. Specifically flag: (1) aut...

#premortem #product-launch #risk

business Advanced

Run a Pre-Mortem on a Major Product Launch

Act as a senior product strategist. Facilitate a pre-mortem for the launch of [p...

#formulas #validation #helper-column

Build a formula that flags rows where two columns disagree

Act as an Excel expert. I have a spreadsheet where two columns should always agr...

#power-query #data-cleaning #pivot

Turn a messy exported report into a clean pivot-ready table

You're an Excel power user. I pasted in an export from another system and it's a...

#data #data quality #validation

data Beginner

Sanity-check a dataset before I trust it

I'll describe a dataset I just received. Give me a checklist of the first things...

#excel #power-query #data-cleaning

Clean Messy Spreadsheet Data Step by Step

You are a data-cleaning specialist. I have a messy Excel sheet with these proble...