• 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. OCR National - Evaluation of Website

    accurately; Roll-over buttons and the navigation bar from Unit 21, the advertising animation from Unit 20, and various skills from Unit 1 (mainly through the Publisher task) * Good at finding appropriate images of good quality and size using appropriate search functions * I have given each task of the

  1. AQA GCSE ICT Specification B

    Address 2 * Address 3 * Address 4 * Home Phone * Mobile Phone * Email * Colour * Personalization * Personalization Character Count (Calculated Immediately) * Payment Type * CC Number * Primary Cost * Personalization Cost * Total Cost 5.

  2. Spreadsheet for a basketball company

    to be used =D5-Income!D5 which is the same as the above one except that because D5 cell that is used in this formula is from the expenditure page the 'Expenditure!' bit does not have to be included. 2.5. Data Flow Diagrams 1. Ordering a ticket Type and no. of seat(s)

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

    * The spreadsheet should be quicker, by calculating everything. Quick calculations shall be made, as soon as the description of item is keyed in. * Will have formulas that will allow new information to be typed and will affect the profit/loss of the company accordingly.

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

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

  2. In the following report, I will describe, using screenshots, the advanced features of Microsoft ...

    I selected 'Next' in step 2 then in step 3 I typed the chart title and labelled the X and Y axis. After clicking 'Finish' I right clicked on each separate bar of the chart and seleceted 'Format Data Series', which opened up the formatting dialogue box.

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