An export is ready for analysis only after you reconcile it with the source. Keep the report selection, document keys and control total, then check the workbook before changing its presentation. A correct amount can hide a missing row, so test record count separately from value. The sign convention matters when you compare a positive supplier report with a credit-balance ledger account.
These exercises open real Excel workbooks in the simulator. Export contains records from the SAP report; Reconcile contains the source controls and blank formula cells. Write SUM, COUNTA, a signed difference and SUMIF against those imported records. Use formulas rather than typing the control value, so the reconciliation updates when the hidden source data changes.