GCSE excel proeject

Assignment Scenario

The following assignment scenario has a task and a mark scheme. The spreadsheet has been worked on already and below is the main bulk of the tasks.

Assignment Tasks

Mail merger

Mail merger for ‘AWARD certificate for prize winners’ to produce individual certificates for each winner. The columns that need to be used are first name of winners surname and subject successfully complete from the student list and prizes worksheet


Simple macro that sets the print area and print preview before printing a list of the following columns first name, surname and awards in the prizeData and budget

COUNTIF function

The countif function which must produce a list showing how many books tokens of each monetary value is needed to be brought. To do this, need to refer to student list and prizes worksheet and the student list and prizes worksheet to count the particular book token amount e.g. £10 = 4 token required to be brought to the prize ceremony.

SUM function

Calculate the total amount of the tokens give on the student list and prizes.

Habilidades: Inglês (Britânico), Excel, Word

Veja mais: excel macro to word, excel macro how to, excel certificate, certificate excel, excel scenario, excel mark, bulk mark, scheme excel, excel scheme, excel 2014 macro, excel macros spreadsheet macro, excel mail list, need excel macros, macro excel total count, word excel assignment, print excel, simple budget spreadsheet, excel list delhi area, excel assignment word, excel budget macro, simple excel macro, simple assignment excel, simple excel assignment, print certificates, assignment word excel

Acerca do Empregador:
( 27 comentários ) London, United Kingdom

ID do Projeto: #6839841

Concedido a:


Hello, I am top excel developer on this forum with 200+ five star reviews and with a completion rate of 90%. I have understood your requirement and I am sure I can implement this. Check my past reviews for your refere Mais

£25 GBP em 0 dias
(233 Comentários)

8 freelancers are bidding on average £20 for this job


Hello sir, I am an excel expert. Check my reviews. Contact me if you are interested! Kind regards, Dragos!

£25 GBP em 1 dia
(44 Comentários)

Hello , I am IT engineer with European diploma since 2005 Certified as Technical specialist in Microsoft SQL Server databases, i have more than 8 years of experience working around Microsoft Excel database and VBA o Mais

£24 GBP em 1 dia
(6 Comentários)

Hello Sir/Madam, Thanks this great opportunity, if you like than can we discuss further, awaiting for your positive response, I am extremely interested to your project and ready to start immediately. Sir/Madam if you Mais

£20 GBP em 1 dia
(18 Comentários)

A proposal has not yet been provided

£18 GBP em 1 dia
(0 Comentários)

A proposal has not yet been provided

£18 GBP em 1 dia
(0 Comentários)

hard working,dedicated,keeping in mind the time value on time performance,accurate,very much aware of the computer knowledge

£21 GBP em 1 dia
(0 Comentários)

I have good in Excel. And I know countif function and much more in excel. If u give me chance to work with your project. its great deal..

£19 GBP em 1 dia
(0 Comentários)

New freelancer, old excel programmer. Looking to establish so thriving on quality work and low cost. Win win for both. Thanks,

£10 GBP em 1 dia
(0 Comentários)