Excel 2010 Advanced
Publisher: Bookboon.com
Published: 2013
ISBN-13: 9788776817886
Table of contents: title: Content; title: 1. Advanced worksheet functions; title: 1.1. Conditional & Logical Functions; title: 1.2. Counting And Totalling Cells Conditionally; title: 1.3. And, Or, Not; title: 1.4. Lookup Functions; title: 2. Views, scenarios, goal seek, solver; title: 2.1. Goal Seeking And Solving; title: 2.2. Advanced Solver Features; title: 2.3. Scenarios; title: 2.4. Views; title: 3. Using excel to manage lists; title: 3.1. Excel Lists,List Terminology; title: 3.2.  Sorting Data; title: 3.3. Subtotals; title: 3.4. Filtering A List; title: 3.5. Advanced Filtering; title: 3.6. Criteria Tips; title: 3.7. Multiple Criteria; title: 3.8. Calculated Criteria; title: 3.9. Data Consolidation; title: 3.10. Pivottables; title: 3.11. Modifying A Pivottable; title: 3.12. Managing Pivottables; title: 3.13. Formatting A Pivottable; title: 3.14. Banding; title: 3.15. Slicers; title: 4. Charts; title: 4.1. Introduction To Charting 143 Creating Charts 145 Formatting Charts 157 Changing The Chart Layout 163 Sparklines; title: 5. Templates; title: 5.1. Introduction To Templates; title: 5.2. Create Custom Templates; title: 6. Drawing and formatting; title: 6.1. Inserting, Formatting And Deleting Objects; title: 6.2. More Formatting; title: 7. Excel tools; title: 7.1. Reviewing; title: 7.2. Auditing; title: 7.3. Proofing Tools