| Description of use |
Functions and Features of Excel Used |
More information please |
| Combine many linked workbooks into one work book quickly and reliably
without losing the interrelationships. |
Cut and Paste |
|
| Rank a list of items based on certain criteria (see which item
is first, which is second etc.) |
Rank |
|
| Use the same formulae over and over again and safely change the
cells and sheets it refers to, |
Copy and Paste
Find/ Replace |
|
| Have your spreadsheet automatically run sensitivities for up to
2 variables. No more changing the input, writing the results, changing
the input etc. |
Tables |
|
| Use a reference cell to lookup a related value in a list of information,
both for an exact match or an approximate match ( for example in
what tax bracket do you fall). |
Vlookup |
|
| Switch between different scenarios on a spreadsheet quickly and
reliable, for example to show your worst case, best case, and realistic
case. |
Scenarios |
|
| Let excel work through your spreadsheet to find the input value
that will give you your desired output value. |
Goalseek |
|
| Find an optimal value for a formula in one cell by working with
a group of cells that are related, either directly or indirectly,
to the formula in the target cell. Where necessary apply constraints
to restrict the values. Also determine the maximum or minimum value
of one cell by changing other cells. |
Solver |
|
| Automatically change the formatting of a cell depending on the
contents of either that cell, or another cell. |
Conditional formatting |
|
| Protect a cell from accidental deletion or change either as a
precaution (without a password) or as security (with a password). |
Protection |
|
| Manage a long list of items and list the items you want to focus
on depending on certain criteria. |
Filter |
|
| Control what is input into a cell by restricting what the user
can do. Provide useful initial messages as well as meaningful error
messages. Control the formats and limits of numbers, dates or words. |
Validation |
|
| Automatically change a rows of information into columns, or columns
of information into rows. |
Transpose |
|
| Combine and compare large amounts of data. Rotate the presentation
of the material depending on your needs. Graph the results, exclude
items, sort the data. |
Pivot Tables |
|
| Arrange your screen so that you can see the same spreadsheet in
two different windows (useful if you are comparing Sheet 1 to Sheet
2 on a cell by cell basis). |
New Window
Arrange |
|
| Calculate a number of days based on working days only instead
of a guess of when the weekends are. |
Net Working Days |
|
Join combinations or characters into one cell, for example put
the title, initial and surname from 3 columns into one cell.
|
Concatenate |
|
| Change all characters in a cell to lower case. |
Lower |
|
| Change all characters in a cell to upper case. |
Upper |
|
| Change all characters in a cell to proper case. (The start of
a sentence has a capital followed by lower case). |
Proper |
|
| Display only certain characters depending on where they are in
the cell e.g. so many characters from the left, so many characters
from the right, so many characters starting from a point in the
middle of the cell. |
Left
Right
Mid |
|
Sort a list automatically within a spreadsheet without using macros.
|
Rank
Vlookup |
|
