Moffat S. Excel 2007 Advanced. Part I

The Mouse Training Company & Ventus Publishing ApS, 2012. – 131 p.Advanced worksheet Functions.
Names.
Using Names.
Conditional & Logical Functions.
AND, OR, NOT.
Lookup Functions.
Other Useful Functions.
Data consolidation.
Views, Scenarios, goal seek and solver.
Goal Seeking and Solving.
Views & Scenarios.
Using Excel to Manage Lists.
Excel Lists, List Terminology.
Sorting Data.
Adding Subtotals to a List.
Filtering a List.
List Statistics.
Pivottables.
Managing Pivottables.