ABLE ADMINISTRATION AID

Able Administration Aid has prepared spreadsheets, recreating forms inclusive of data entry pages for repeated data with lookup fields, validation and drop down lists and calculation fields with the occasional graph.  

Extensive experience with Excel,  testing has scored knowledge level as Intermediate to Advanced - both online and and via agencies.  Working experience includes:

Dinkum Energy

Recreation of various supplier forms as required per customer into Excel workbooks for population of repeated data. Spreadsheets for submission of expenses (including images of receipts), customer invoice tracking and payment summaries.

Avon Sales

An Excel workbook was created for customer details, orders submitted, order confirmation and invoicing.  This workbook included lookup of listed product via product codes and detailed product in the invoicing.

Capitalcorp Finance and Leasing

Recording daily banking; Allocation of bulk commission payments via queries, vlookup formulas, pivot tables and branch summaries in preparation for database uploading and reconciliation journals.  Running data integrity checks via spread sheet formulas and maintaining an accumulative deals spreadsheet for non-Access users.

Pacific Brands

Automation of repeated data via Workcover Injury Management Workbook to all relevant workers' compensation forms created for each state (see 2004 Queensland Version without employee data).  

Site Action Plan, Workplace Inspections, Casual Inductions and Employee OHS Induction Checklists, First Aiders’ Certificate register, Emergency Equipment Report, Industrial Truck & Car License Register, Mobile Plant Authorisation & Checks Register, Training register and preparation of training schedules, sign off sheets and evaluation forms.