Here are links to guides to various techniques in Excel.
Making a Table for a Function of Two Independent variables
Inserting an Increment Button
Using Paste Special to Lift a Copy of Values
Conditional Formatting
Triangular Arrays by Turning Off Zeros
LOOKUP Functions
Logic Tests
LCM & HCF (or GCD)
Composite Bar Charts
Making a Table for a Function of Two Independent variables
Inserting an Increment Button
Using Paste Special to Lift a Copy of Values
Conditional Formatting
Triangular Arrays by Turning Off Zeros
LOOKUP Functions
Logic Tests
LCM & HCF (or GCD)
Composite Bar Charts