Pivot Tables
Pivot Tables are a feature that will show information from a table the way that you want it to be shown. I could use this in my project to display the amount of sales that are made in different ways.
Cell protection
When you have many cells with important information such as formulae and formatting, the last thing you want is for the user to accidentally clear these cells. In order to make sure that this does not happen you can protect the cells against alteration. This will make sure that the user does not mess-up anything on the sheet.
Functions IF etc.
There are many functions in excel that will aid the user tom do functions for them. For example using a sum formula will add up the total of a range that the user selects. This could be used to add up profits.
MACROS
A macro can automate tasks. If you perform a task repeatedly in Word, you can automate the task using a macro. A macro is a series of Word commands and instructions that you group together as a single command to accomplish a task automatically. Instead of manually performing a series of time-consuming, repetitive actions in Word, you can create and run a single macro in effect, a custom command that accomplishes the task for you.
Lookup tables
Naming a range will give the data a meaning. You can then set the information to be put into a cell to come from the range that you named in my project I could this in my project to input the information for orders into the order form, which will save the user time.
Data validation
The cell can be set to validate the information that is put into the cell. This is to prevent the wrong information from being put into the cell. This will make the spreadsheet more accurate to use and to take information from.
Scenarios
This shows that the various outcomes of the shop that can occur depending on different information that can happen. By inputting different values to different scenarios it will produce the outcome values of those scenarios.
Comments
To help the user of the spreadsheet I can give a cell a comment. Whenever the user enters into the cell, a note is produced for that cell that will inform the user what information is to be put into the cell. I can use this to show where to put important information e.g. Customer ID.
Cell validation
The cell data can be validated so that to ensure against mistakes. This will make sure that no errors are put into the cells, so we can avoid GIGO (Garbage in, Garbage out).
An error message will be displayed to make the user aware of the error. For example a cell can be set to a certain value. If putting in a higher value 54 exceeds this value, e.g. 45 then the error message will appear.
Conditional formatting
Cells can be set so that the contents of the cell can be changed when the wrong or incorrect data is entered into the field. For example if values in the cell are beyond a set value then the information will change Colour to alert the user. This is useful, as it will show when stocks are too low for the orders.
Fill Function
By highlighting a cell and then dragging the bottom right hand corner of it, you can replicate the contents of the cell. This saves the time of retyping complicated formulae or long figures. I can use this to replicate lookup formulae and to control stock records.
Insert Pictures
To make the spreadsheet look more professional I can put pictures onto the sheet. The pictures can be of the items of Christmas stock or company logo.