Excel 2010 Advanced
Publisher: Bookboon.com
Published: 2013
ISBN-13: 9788776817886
Table of contents: title: Sisältö; title: Advanced worksheet functions; title: Conditional & Logical Functions; title: Counting And Totalling Cells Conditionally; title: And, Or, Not; title: Lookup Functions; title: Views, scenarios, goal seek, solver; title: Goal Seeking And Solving; title: Advanced Solver Features; title: Scenarios; title: Views; title: Using excel to manage lists; title: Excel Lists,List Terminology; title: Sorting Data; title: Subtotals; title: Filtering A List; title: Advanced Filtering; title: Criteria Tips; title: Multiple Criteria; title: Calculated Criteria; title: Data Consolidation; title: Pivottables; title: Modifying A Pivottable; title: Managing Pivottables; title: Formatting A Pivottable; title: Banding; title: Slicers; title: Charts; title: Introduction To Charting 143 Creating Charts 145 Formatting Charts 157 Changing The Chart Layout 163 Sparklines; title: Templates; title: Introduction To Templates; title: Create Custom Templates; title: Drawing and formatting; title: Inserting, Formatting And Deleting Objects; title: More Formatting; title: Excel tools; title: Reviewing; title: Auditing; title: Proofing Tools