• Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month
  1. 1
  2. 2
  3. 3
  4. 4
  5. 5
  6. 6
  7. 7
  8. 8
  9. 9
  10. 10
  11. 11
  12. 12
  13. 13
  14. 14
  15. 15
  16. 16
  17. 17
  18. 18
  19. 19
  20. 20
  21. 21
  • Level: GCSE
  • Subject: ICT
  • Word count: 2240

In the following report, I will describe, using screenshots, the advanced features of Microsoft Excel I have used in the spreadsheet system.

Extracts from this document...


Implementation Advance Features Report In the following report, I will describe, using screenshots, the advanced features of Microsoft Excel I have used in the spreadsheet system. 1. Macros I used macros in mostly all parts of the system to link the sheets together. After creating a box using the drawing toolbar and adding the appropriate text, I right clicked on the box, selected 'assign macro' and in the dialogue box typed 'moveto........' and clicked 'record'. I then clicked 'ok' in the next dialogue box from which appeared. I then went to the sheet that the particular was to open and selected the 'stop recording' button, shown in the icon above. 2. Check Boxes/COUNTIF Function/Training Chart Above is part of the 'Training' section of the 'Staff' sheet. Here I used checkboxes to show which of the six modules have been completed by each of the Pharmacy employees. I created the tick boxes by clicking on the 'View' men, 'Toolbars' and 'Forms. From the forms toolbar, I selected the checkbox and dragged it across to where I wanted it. I then right clicked on it and selected 'Format Control'. From the dialogue box I selected 'checked' and in the 'cell link' part I clicked on which minimized the dialogue box and I was able to select in which cell I wanted true or false to appear. ...read more.


Step 2 of the template wizard asked for the location and name for the database that I want created. I typed the appropriate name and location and clicked 'Next', which opened up step 3 (shown on the next page). In the 'Cell' box, I clicked in D16 for 'Title', and pressed the Tab key. I continued like this until I had entered all the required and then clicked 'Next'. I clicked 'Next' again in step 4 which opened up the final step of the template wizard (below). Step 5 notified me that the wizard had created the template and database. I clicked finish. Testing the Template Firstly I filled in the form with some data and then selected 'File' and 'Save', which opened up the following screen. I selected create a new record, clicked 'Ok' and closed the workbook. I then opened the recruitment database from the C: Drive. A record (shown below) had been added corresponding to the data that I entered in the form. I then saved and closed the workbook. 7. 'VLOOKUP' Function =VLOOKUP(N14,'Staff Finance'!B6:E35,3) Above is the 'Payroll' sheet, where I have used the VLOOKUP Function in the following fields: -Title -Basic Hours -Modules Completed -Surname -Overtime Hours -Present Module -F/Name -Sick Hours -Hourly Pay -Holiday Hours I used the function in such a way that when the employee number of each employee is selected in the 'Emp. ...read more.


Calculators were used to work out all mathematical calculations, for example 'Gross Pay'. After all the payslips had been prepared, a copy was filed in each employee's record, which were stored in a filing cabinet. This method had various problems. Working out their wages was time consuming and mistakes often occurred in the calculations. Each employee's record had then to be searched individually, which also wasted time. Sometimes, even the copies were misfiled. Another problem was that the Pharmacy Recruitment File was saved on a computer separate from the filing cabinet. This file displayed a recruitment form that was given to newly recruited staff. Their details were then manually inputted into another file, which contained all the details about the rest of the employees. This was time also consuming My newly designed system on Microsoft Excel, in my opinion, has solved the problems mentioned as a spreadsheet program is designed to display and process numbers. It is made up of a grid into which numbers are entered. The program contains many mathematical, statistical and financial calculations which can be applied to the numbers, therefore it was ideal. More detail of this will be provided in the evaluation section of the project. At first it took some time getting used to the way each formula worked but by the method of trial and error I was soon able to overcome these problems. AMDG SAJID KARA JANUARY 03 ...read more.

The above preview is unformatted text

This student written piece of work is one of many that can be found in our GCSE Software section.

Found what you're looking for?

  • Start learning 29% faster today
  • 150,000+ documents available
  • Just £6.99 a month

Not the one? Search for your essay title...
  • Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month

See related essaysSee related essays

Related GCSE Software essays

  1. Design a spreadsheet that can be used by a school tuck shop.

    There are number of improvements I made to my spreadsheet as I went along. There were also quite a few problems encountered as I went along and I had to mend them. The first thing I found went wrong was when I can to putting my rank data in a graph.


    But I did solve all Mr. Gudi's problem. One of user requirements was that the database must be user friendly, with a user interface including Main Menus and Data Entry Forms. I believe I achieved this objective by providing clear and forms and reports.

  1. Evaluation of Microsoft Excel

    Furthermore, it is too complicated to get to the "Absolute Cells Reference" stage. We have to type the $ sign and fix the cell into place. What if Excel had already made a function based on "Absolute Cells Reference"? This would've made the whole process much easier to get across.


    On the end column of the table are some advantages and disadvantages to all the programs which basically explains what each of the programs feature or don't feature and why. Although they are all very good programs I would have to recommend the following two * Adobe Premier Pro CS3

  1. AQA GCSE ICT Specification B

    main menu will appear, as this is how the system is opened for administration. Refinements - Criteria 2 Criteria Details The database must be called 'Ducks System'. Evaluation The criterion was met. Evidence Limitations - Refinements - Criteria 3 Criteria Details Every button should work Evaluation Every button tested worked-

  2. Software Report

    user wishes - different versions can be saved so it is possible to go back to an earlier version of the same document, the user can change fonts and add boards etc, the user can use spell check and grammar check to make sure there work is of good standard,

  1. Software used in my created system. To begin with, the one software I must ...

    in thumbnail format, the pictures are vector pictures meaning they can be enlarged and made smaller without blurring the image.

  2. Evaluate the benefits of a particular spreadsheet solution and describe potential refinements to improve ...

    office, making it easier to write the report or change anything in the table, chart or graph. Retaining a link to the original data: This method allows the pasted cell to be connected to the original spreadsheet while being on a different document e.g.

  • Over 160,000 pieces
    of student written work
  • Annotated by
    experienced teachers
  • Ideas and feedback to
    improve your own work