More Tips
[1] Create Scroll Bars
to control values in table
open sample1.xls at the end of sample files page
to control coefficients in equation
[2] Conditional Formatting
to change color of cells according to their values
to change color of cells based on divisibility
open sample3.xls at the end of sample files page
Protect Worksheet and Hide Formulas
[4] Working with Formulas
Create table of values (e.g. for studying sequences or functions). The first demo shows the basic steps in setting up tables. The others show formulas and expressions presented with usual algebraic notations. 
Basics: Copy and Paste Formulas; Relative and Absolute References
Name a Cell
Name a Range of Cells
Combine Contents of Cells: Concatenate
Modify Expressions with Logical Function (IF)