• Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month

Evaluation of Microsoft Excel

Extracts from this document...

Introduction

Evaluation of Microsoft Excel Overall using Microsoft Excel was better because I was able to do things I wouldn't usually be capable of doing on Word. Firstly, Excel was designed to make tables and spreadsheets because Excel is a spreadsheet in it self. So it was the perfect programme to make spreadsheets in order to find out the payroll for Crucial Music Company. The spreadsheet can be used for any situation; from simple as working out your daily spends to complex one for a business like Crucial Music. Therefore they can be formal and also informal. Secondly, I could format things. For example, I could format units into currency (�), decimal places, change the colour and add borders. Thirdly, grids are already there, so there was no need for me to draw gridlines, whereas in Word I would have to think about the proportions and the like. ...read more.

Middle

In addition, I could also use "Conditional Formatting" to compare things. For example, it only takes a glance to compare worker productivity, sales figures, product performance, or other measures that are important to your business. Excel makes it easier than ever to apply rich conditional formatting. Also, it is easier to make graphs. You enter the data, highlight it, go on graphs and choose which 1 is most suitable. However, there are some bad points about Excel. When an error occurs and column/row is too small for the error to be shown or the information in the cell is too small to show like a number being too big, Excel displays it as "####" . This is a disadvantage because we immediately think the "##"s mean an error when it might not be one. So if the person deleted the information on that cell, the whole spreadsheet might not work. ...read more.

Conclusion

The cell should not show hash signs, it should increase the size of the column/row giving an option of "Yes/No" to the person who's using Excel if they want to continue with the increasing of the cells. Or, there should be a setting, allowing the users to make the option for the columns/rows automatically being increased so that it is easier and less time consuming. I found using Excel really quite simple at first, but as it progressed in to more and more detail; it got harder to keep up with the intensity of using the spreadsheet effectively. I specially found working out the right formulas for each of the Sub-headings quite difficult because it was hard to figure out how the formulas were meant to come across and where they should be placed. For example, I made a mistake in my spreadsheet, because I inserted the formula =C10-$B$22 which was actually supposed to be =C10-(C10*$B$22). So another improvement for Excel could be to make settings for the user to have a choice or getting informed if something does not look right. ?? ?? ?? ?? ...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. Appropriate Software To do this project I am going to use excel because ...

    This allows the end user to perhaps reduce the expenditures to their liking; they can also make changes to the cost. The printed copy is kept as a permanent record which can be produced as evidence if there is a problem involving wages or bills.

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

    opened up a spreadsheet which lacked in design and presentation, then they probably would not bother using it or decided not to buy it. I decided to colour the background black, so that it was eye catching, and looked professional, as if I had colours the cells bright pink, then it would not have been suitable for my target audience.

  1. OCR National - Evaluation of Website

    project appropriate timings, building on and linking from previous steps (for example I have consciously structured Task 2, inserting the components into the website, to follow-on to Task 3, inserting the hyperlinks) * Before inserting the components into the website, I have planned thoroughly where they are going to go, what is going to be said (in text)

  2. AQA GCSE ICT Specification B

    - PhoneHome Table 1 - Yes - - - PhoneMobile Table 1 - Yes - - - Email Table 1 - Yes - - - Price Table 1 - Yes - - - Personalization Table 1 - Yes - - - Colour Table 1 - Yes - - - PaymentType

  1. Spreadsheet for a basketball company

    =SUM(E8+E16+E23+F31). 4 Calculate Profit The formula =SUM(C4-C5) was used where C4 contains the total income and C5 contains the total expenditure. Therefore, the expenditure is subtracted from the income. 5 Produce graphs E.g. to produce a graph for the total income the values that have to be entered are =(Income!$F$8,Income!$F$17,Income!$F$24)

  2. Spreadsheet. This coursework is based on the work of a spreadsheet, which is ...

    As well as this I will hope that my new spreadsheet will record all the sales, purchases and refunds, accurately, quickly, and sufficiently. The specification of problem is to help a company, in producing a computerised filing system which will store information, on the company's Profits/losses, amount of items sold and bought.

  1. Produce a spreadsheet for a successful and potential company

    see in the spreadsheet and there ability to use Microsoft Excel program. I expect this spreadsheet to be set up like a table with about 4 or 5 fields and at least 3 rows of the table filled in. I would like the spreadsheet to look professional and business like.

  2. Produce a spreadsheet for a successful and potential company "Belle Du Jour".

    I will also be asking about the network they use and the type of software that is available to me this will be researched by interviewing the technical director of the company. I will also be conducting a survey for the staff at employees asking what they would like to

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