34


More Tips
[1] Create Scroll Bars
[1.1]
to control values in table
open sample1.xls at the end of sample files page
[1.2]
to control coefficients in equation
[2] Conditional Formatting
[2.1]
to change color of cells according to their values
[2.2]
to change color of cells based on divisibility
open sample3.xls at the end of sample files page
[3]
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. 
[4.1]
Basics: Copy and Paste Formulas; Relative and Absolute References
[4.2]
Name a Cell
[4.3]
Name a Range of Cells
[4.4]
Combine Contents of Cells: Concatenate
[4.5]
Modify Expressions with Logical Function (IF)