Excel 2003 Advanced
Publisher: Bookboon.com
Published: 2013
ISBN-13: 9788740300505
Table of contents: title: Content; title: 1. Introduction; title: 1.1. Using advanced Worksheet functions; title: 1.2. Names; title: 1.3. USING NAMES; title: 1.4. Conditional & Logical Functions; title: 1.5. Value if True / False; title: 1.6. SOLVER; title: 2. Views, Scenarios & Reports; title: 2.1. Views & Scenarios; title: 3. Using Excel to Manage Lists; title: 3.1. Excel Lists; title: 3.2. Sorting Data; title: 3.3. Adding subtotals to a list; title: 3.4. Filtering a List; title: 3.5. Advanced Filtering; title: 3.6. Copying filtered data; title: 3.7. List Statistics; title: 3.8. Pivot Tables; title: 4. Charts; title: 4.1. Introduction to Charting; title: 4.2. ChartWizard; title: 4.3. Data Layout; title: 4.4. Chart Toolbar; title: 4.5. Chart Types; title: 4.6. Font; title: 4.7. Manipulating Chart Data; title: 5. Templates; title: 5.1. Introduction to templates; title: 6. Auditing; title: 6.1. Auditing features; title: 6.2. Precendents and Dependants; title: 6.3. Comments