Thursday, 6 June 2013

Day 3

Today I looked at MS Excel version 2010 again and noted some more of the features it possess. A list of additional features continuing from my older post (Day 1) is listed below:

- The width of a cell can be adjusted to your likeliness. It can be expanded to the length in which you need  
   your cell to be.
- There is a "Find and Select" feature available that allows you to "Find" text in which you are looking for. It
   will scan the document and highlight the possible answers.
- The "Select" feature will "select" the text and can replace the text for you without you having to scan
   through the document manually and replace it.
- You can format a table with the cells.
- You can change the style of the cells.
- There is a feature that allows you to remove duplicates within the document. This will automatically be done
   once you select this feature and enter the range of cells in which you don't want any duplicates to be
   present.
- There is a feature that allows you to check the accuracy of data. It will circle invalid data for you
   automatically.
- You can sort your work as you please either from ascending order or descending order.
- You can now get a subtotal of your work if you wish by selecting the "Subtotal" feature. Once you select
   the cell range the software will automatically calculate the subtotal for you without the use of a formula.
- Pictures, clip art and shapes can be inserted.
- A background can also be added.
- Page breaks are now available.
- You can protect your sheet or workbook by selecting the feature.
- You can share you workbook if you wish too.
- You can filter the uses whom has access to your workbook.
- You can track any changes in which someone made to your workbook.
- You can now allow users to edit the ranges of data in your workbook.

Some of the other features will be discussed tomorrow. The time line is on its way to being finished. Its not quite yet done however, we are in the process of it. We are trying to assign tasks equally and fairly to everyone.

No comments:

Post a Comment