Excel Spreadsheet within programming and macros

Encerrado Postado há 5 anos Pago na entrega
Encerrado 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.

Microsoft

ID do Projeto: #18751121

Sobre o projeto

5 propostas Projeto remoto Ativo em há 5 anos

5 freelancers estão ofertando em média $2367 nesse trabalho

schoudhary1553

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

$2500 AUD in 30 dias
(5 Comentários)
4.1
lightingdavid

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

$1500 AUD in 10 dias
(1 Comentário)
0.0
naishodayo

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.

$2500 AUD in 30 dias
(0 Comentários)
0.0
mbyham

I'm currently building and have mostly completed, a similar project for a large industrial company. Roughly speaking there was a requirement for users to enter data but for them to only have access to enter data and th Mais

$2833 AUD in 30 dias
(0 Comentários)
0.0