Excel Spreadsheet within programming and macros
$1500-3000 AUD
Pago na entrega
Advanced Excel Skills
Advanced Formulas.
Tables & Formatting.
Conditional Formatting.
Advanced Charting.
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.
ID do Projeto: #18751121
Sobre o projeto
5 freelancers estão ofertando em média $2367 nesse trabalho
Hello, I have gone through your job posting and become very much interested to work with you. I am an expert in this field. I have already completed several projects like this. For evidence you can see my profile. Mais
Hello. How are you? I am highly interested to work on the "Excel Spreadsheet within programming and macros". I am a full stack Excel/VBA developer. I have more than 7 years experience in "Microsoft". I will make s Mais
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.