Carlene Hatcher

Capability Examples

Outstanding Accounts Payable Report

You will find the following in this sample Excel file:

Suppliers sheet

Contains the 'SuppliersTable'

This table was created manually

SupplierInvoices

Contains the 'SupplierInvoicesTable' table

This table was created partially from VBA code and partially manually

Outstanding AP Invoices

Displays the 'Outstanding Accounts Payable Report' on the last tab

Contains the 'UnpaidAPInvoicesTable' table

This table was created entirely with formulas, except for the user interaction cells, which I filled in as if I were the user

This sheet shows both a list of unpaid invoices, derived from the SupplierInvoices sheet, and a Summary of Scenarios at the top