Advanced Topics

This section covers a range of more advanced spreadsheeting topics including the use of powerful inbuilt functions such as IF statements and Lookup tables.

Topics include:

Windows and Titles
Range Names
Protecting Your Investment
Functions
Inbuilt Formulas
Summing across Multiple Worksheets
Logical functions - If
Logical functions - Lookup

---