Closed

Excel Spreadsheet within programming and macros

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.

Skills: Microsoft

See more: microsoft excel programming, excel macro tutorial for beginners, excel 2016 macro tutorial, how to create a macro in excel 2010, excel macro examples, macros in excel for beginners, use of macros in excel, excel macros for dummies, excel spreadsheet quickbooks, send bulk mail excel spreadsheet, reformat excel spreadsheet, excel spreadsheet macros web, excel spreadsheet macros, turning excel spreadsheet macros web page, searching macros excel spreadsheet vbs script, electronic engineering excel spreadsheet, excel spreadsheet macros ipad, excel spreadsheet medical coding, create simple excel spreadsheet template macros, convert excel spreadsheet macros google spreadsheet

About the Employer:
( 0 reviews ) Australia

Project ID: #18751121

6 freelancers are bidding on average $2389 for this job

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. More

$2500 AUD in 30 days
(3 Reviews)
3.6
langlangFan

Hi, thanks for your job posting. I don't look new client but I read your serious job posting. I am good at website design and development and marco. The most important thing for me is the client's satisfaction, good More

$2500 AUD in 30 days
(0 Reviews)
0.0
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 More

$1500 AUD in 10 days
(1 Review)
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 days
(0 Reviews)
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 More

$2833 AUD in 30 days
(0 Reviews)
0.0
premsingh488

Hi There I am a full time programmer with more than 8 years of experience in MS Access, MS Excel, VBA, SQL, and Power BI. I have done more than 1000 projects and still hunger for more work. I’ll keep it short and More

$2500 AUD in 30 days
(0 Reviews)
0.0