Excel 2007 Advanced: Part I
Publisher: Bookboon.com
Published: 2013
ISBN-13: 9788740300338
Table of contents: title: Content; title: 1. Advanced worksheet Functions; title: 1.1. Names; title: 1.2. Using Names; title: 1.3. Conditional & Logical Functions; title: 1.4. AND, OR, NOT; title: 1.5. Lookup Functions; title: 1.6. Other Useful Functions; title: 1.7. Data consolidation; title: 2. SViews, Scenarios, goal seek and solver; title: 2.1. Goal Seeking and Solving; title: 2.2. Views & Scenarios; title: 3. Using Excel to Manage Lists; title: 3.1. Excel Lists, List Terminology; title: 3.2. Sorting Data; title: 3.3. Adding Subtotals to a List; title: 3.4. Filtering a List; title: 3.5. List Statistics; title: 3.6. Pivottables; title: 3.7. Managing Pivottables