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

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

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

    Apple iWork Numbers is completely incompatible with the OS I'm using so that's not really a valid option. Excel is much simpler and quicker to use, however. You can merge cells, edit field widths and cell properties and data types with ease.

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

    This error would also be hard to identify. If JEM Bookshop made an error like this, it would cause a lot of trouble; Profit could Decrease, Reputation would bad, losing customers etc. furthermore, to avoid this you need training or employing new staff, which could increase the expenses.

  1. Appropriate Software To do this project I am going to use excel because ...

    Robert Price Bought This is how much my user buys it for from another distributor The distributor who the end user buys the products from. Expenditure amount/ Cost Cost of expenditure The companies that supply each of the utilities. E.g.

  2. Spreadsheet Technical report. My task was to produce a grade book for primary ...

    To copy the formula I hovered over the bottom right of the first cell, and waited till a black plus sign appeared. Once it had appeared I grabbed it and pulled it down, high-lighting all the cells I wanted the formula to be present in.

  1. AQA GCSE ICT Specification B

    Test Plan Criterion to test Test I.D. Test objectives / justification Normal Extreme Erroneous Test data Expected outcome Test data Expected outcome Test data Expected outcome 1. 1. On opening, the main menu should appear, and the navigation panel should not. Open the system. The main menu will appear without the navigation bar.

  2. Logo Report

    whilst creating my logo that it must not be too big and take up a lot of room or be too small so that it can barley be seen. Logo Research: Before I start to create my logo, I must research other travel agents and see what their logos are like.

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