Advanced Excel Skills
Tables & Formatting.
Pivot tables & Pivot Reporting.
VBA & Macros.
Using Excel Productively.
Data Tables, Simulations & Solver.
The spread sheet will be managed by an administrators and used by office staff with little to no excel experience.
Two levels of access Administrator and General Staff
The spread sheet will need to present simple to use sequenced based input.
It will need to present a front page with the following information in a clean and clear format.
The user will need to populate the fields with the relevant information
Nominated information will need to be enter to a normal field or from an auto populate list
For example if the user inputs an address in New South Wales, Australia, the spreadsheet will automatically select and populate the names of the people that are involved in the work in that region from a list of people that can be edited by an administrator of the spreadsheet, the spreadsheet will automatically select and populate the relevant laws associated with working in that region , the spreadsheet will automatically select and populate the relevant training required by each worker working in that region
Various fields will need to have images based selections
The office staff will be presented with a neat set of fields to fill in and buttons to create various reports.
The printed or electronic soft copy of the final report the must be very neat, no wasted space or excess pages and in PDF for the end user and email to the client.
As example the colors in the attached document relate to the what the field should do with the information. Green area information will need to auto populate other fields with the same information or a default set of information will need to be able to be selected from a drop down list. Blue is default information created by selecting a table with green information. Yellow is a drop down list or set of images to select
see sample Word Doc attached with color coding.
6 freelancers are bidding on average $2389 for this job
How are you today? I have seen your proposal carefully, and I very interested in your project. I am confident to complete your project perfectly. Please contact me. Thank you.