In Progress

Excel formulas/workbook/dashboard wanted

I want a workbook that displays up to 30 persons' progress. It should have these columns:

Name

Date of Birth

• me to Input a birthdate in dd/mm/yyyy format

Chronological Age

• generated (by your formula) chronological age in years/month/days format This should update each time the worksheet opens.

Test Scores - 4 each week (I will enter this data)

• data entry columns (me to enter a raw score, all out of 20 items)

Output - 3 types: each with Name - dob, Chronological Age ( your formula to calculate in y/m/d format)

1. the worksheet see attachment for detail

2. A dashboard page showing class average % scores for each test over 10 sets of tests.

3. set of individual pages (Max 30) each with a dashboard showing -

Name - dob, Chronological Age (your formula to calculate)

individual student's scores in a table (from sheet 1) hori or vert and vertical bar graphs or other type display - see attachment for concept/detail

I am open to suggestions for a better solution (including html) for my enquiry.

Skills: Data Entry, Data Processing, Excel

See more: dashboard excel data entry, dashboard workbook excel, workbook dashboard, wanted format, types of data graphs, type of graphs, m format in excel, data entry worksheet, data entry score, data entry class, concept graphs, average data entry score, all type of graphs, 3 types of data entry, dashboard formulas, test scores dashboard excel, excel sheet formula, birth data entry, y m concept, format excel, excel to html, excel table, excel html, excel graphs, Excel Formulas

About the Employer:
( 18 reviews ) Ipswich, Australia

Project ID: #1283454

Awarded to:

FIBIN

Hi, I am an expert in Excel and VBA Programming in Excel. I have lot of experience working in excel dashboards and reports. I am interestyed to work with you for this project. Please see my PM and the sample project More

$50 AUD in 2 days
(38 Reviews)
5.1

13 freelancers are bidding on average $75 for this job

binaryromel

##### Excel expert here! Please check PM. #####

$100 AUD in 2 days
(47 Reviews)
5.2
dimkastoras

Profesional work.

$80 AUD in 1 day
(6 Reviews)
3.2
denisangelov

Helle, I have experiance with data entry in excell sgeet please send more details.

$30 AUD in 5 days
(0 Reviews)
0.0
chandu1407

i have an exp with [url removed, login to view] a [url removed, login to view] in advance

$50 AUD in 4 days
(0 Reviews)
0.0
Inbasekaran

I have experience in excel work and i can able to do this

$30 AUD in 3 days
(0 Reviews)
0.0
aslamhossain

respective sir, I am accustom to work with both ms excell and open excell and also have a experience of working with Access data base. sir, your provided job is a job to a data entry operator to show his quality. No More

$50 AUD in 3 days
(0 Reviews)
0.0
prasanta2950

i have a good idea on excel.i done it well.

$65 AUD in 3 days
(0 Reviews)
0.0
tiberiugheorghe

Let's get to work. Up to friday it will be ready.

$30 AUD in 3 days
(0 Reviews)
0.0
evearado

Hi, I am proficient in using excel. I can do this in no time. Please email me so I can send you thru pm my sample excel sheet formula as per your requirements. Thanks.

$30 AUD in 1 day
(0 Reviews)
0.0
XhevahireT

I CAN DO IT :)

$188 AUD in 2 days
(0 Reviews)
0.0
mgm05267

Good in Dashboard creation & Database consolidation & manipulation

$50 AUD in 1 day
(0 Reviews)
0.0
FreelanceExcel87

I have understood the requirement of your project. Hope we need to get in touch to get this done.

$220 AUD in 15 days
(0 Reviews)
0.0