[Data/Analysis] How do you use Excel in BA work beyond simple reporting?

Instruction: Explain how you would check the rows, calculate open value by region and report exceptions. Formulas or equivalent spreadsheet operations are acceptable.

Context:

Fictional order export; each order should appear once. Columns are Order ID, Region, Status, Amount (USD): A101, West, Open, 120; A102, East, Closed, 80; A103, West, Open, 200; A103, West, Open, 200; A104, East, Open, 150; A105, East, Open, blank. Source owner confirms the second A103 row is a duplicate export row. A blank amount is unknown, not zero. Produce a reconciled summary and identify what cannot yet be concluded.

Updated

Official answer available

Read the opening below, then unlock the full answer and practical guidance.

Keep the original export and a documented working copy. Check IDs for duplicates, validate statuses and numeric amounts, then remove the confirmed duplicate only in the working copy. Six rows become five distinct orders. Four are open, but one open amount is missing.

Known open value is West $320 (A101 $120 + A103 $200) and East $150 (A104); total known...

Upgrade to view official answer

Related Questions