Advanced Spreadsheet Operations

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- an Overview
Summing across Multiple Worksheets
Logical functions - If
Logical functions - Lookup

---