Excel - Analyze Data
Excel is a great program for creating
Spreadsheets that do numerical calculations, and Analyzing Data. It gives you the ability
to keep track of and manage your data.
Financial Functions
Financial functions can be very useful
for calculating things such as costs and payments. These formulas
make it a lot easier, and take up less space by calculating it in
one cell rather than three or four cells.
to learn more about Financial Functions
Use References (absolute & relative) locking cell References
When inserting formulas, they can
be either absolute or relative form. When using absolute references,
the exact address of a cell will be used, regardless of the position
of the cell that contains the formula. Whereas, with relative referencing,
the address of a cell is based on the relative position of the cell
that contains the formula and the cell referred to. If you make
copies of the formula and place it in other cells, the reference
automatically changes accordingly.
to
learn more about Using References
Adding Formulas
Adding formulas lets you apply a formula
on information from a number of specific cells. It is also
very useful when doing things such as calculating marks.
to
see a viewlet on Adding Formulas
Copying Formulas
Copying formulas can save you time
when you are using the same formula multiple times.
to
see a viewlet on Copying Formulas
Using the If function
You can use the If function in Excel
to evaluate questions, like answers that were selected from drop
down boxes.
to
learn more about using the If funtion
Using the Sum function
Excel is great for testing students
or even as a small survey tool. With the functions of Excel,
you are able to enter data to calculate marks, and even expenses.
to
watch a viewlet on Calculating Marks
Home
| Analyze Data | Worksheets
| Graphs | VBA
Boxes
|