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 data graphs, data entry worksheet, data entry score, concept graphs, average data entry score, type graphs, dashboard formulas, test scores dashboard excel, excel sheet formula, birth data entry, format excel, excel html, excel graphs, excel formulas, excel formula, data entry raw, Dashboard, worksheet html, workbook html, data set formula, excel format formula

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 excel.give a chance.thanks 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