Book 2014

Advanced Excel Essentials

Authors:

ISBN: 978-1-4842-0735-2 (Print) 978-1-4842-0734-5 (Online)

Table of contents (9 chapters)

  1. Front Matter

    Pages i-xvii

  2. Core Advanced Excel Concepts

    1. Front Matter

      Pages 1-1

    2. No Access

      Chapter

      Pages 3-9

      Introduction to Advanced Excel Essentials

    3. No Access

      Chapter

      Pages 11-29

      Visual Basic for Applications for Excel, a Refresher

    4. No Access

      Chapter

      Pages 31-48

      Introducing Formula Concepts

    5. No Access

      Chapter

      Pages 49-66

      Advanced Formula Concepts

    6. No Access

      Chapter

      Pages 67-92

      Working with Form Controls

  3. A Real World Example

    1. Front Matter

      Pages 93-93

    2. No Access

      Chapter

      Pages 95-114

      Getting Input from Users

    3. No Access

      Chapter

      Pages 115-136

      Storage Patterns for User Input

    4. No Access

      Chapter

      Pages 137-163

      Building for Sensitivity Analysis

    5. No Access

      Chapter

      Pages 165-189

      Perfecting the Presentation

  4. Back Matter

    Pages 191-194