Formulas
In the
previous lesson, the focus was on naming the cells that are included in a
formula. We looked at the difference between Relative and
Absolute Cell References. This lesson will use formulas to
calculate, compare and format Text. We will also use formulas to
summarize the data.
I know, I
know: the mere thought of formulas sends folks out the door. I believe
that math is taught very poorly and that most people do NOT have a
comfortable understanding of the rules and options. This lesson will
include a discussion of the math as well as what the spreadsheet
software can do.