Skip to main content
  • Book
  • © 2014

Advanced Excel Essentials

Apress

Authors:

  • This book is for the experienced Excel user planning to take their skills to the next level.
  • Whether you’ve been working with Excel for many years—or you’re a new up-and-comer—this book is an essential guide to begin making advanced spreadsheets right away.

Buy it now

Buying options

eBook USD 59.99
Price excludes VAT (USA)
  • Available as EPUB and PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book USD 79.99
Price excludes VAT (USA)
  • Compact, lightweight edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info

Tax calculation will be finalised at checkout

Other ways to access

This is a preview of subscription content, log in via an institution to check for access.

Table of contents (9 chapters)

  1. Front Matter

    Pages i-xvii
  2. Core Advanced Excel Concepts

    1. Front Matter

      Pages 1-1
    2. Introduction to Advanced Excel Essentials

      • Jordan Goldmeier
      Pages 3-9
    3. Introducing Formula Concepts

      • Jordan Goldmeier
      Pages 31-48
    4. Advanced Formula Concepts

      • Jordan Goldmeier
      Pages 49-66
    5. Working with Form Controls

      • Jordan Goldmeier
      Pages 67-92
  3. A Real World Example

    1. Front Matter

      Pages 93-93
    2. Getting Input from Users

      • Jordan Goldmeier
      Pages 95-114
    3. Storage Patterns for User Input

      • Jordan Goldmeier
      Pages 115-136
    4. Building for Sensitivity Analysis

      • Jordan Goldmeier
      Pages 137-163
    5. Perfecting the Presentation

      • Jordan Goldmeier
      Pages 165-189
  4. Back Matter

    Pages 191-194

About this book

Advanced Excel Essentials is the only book for experienced Excel developers who want to channel their skills into building spreadsheet applications and dashboards. This book starts from the assumption that you are well-versed in Excel and builds on your skills to take them to an advanced level. It provides the building blocks of advanced development and then takes you through the development of your own advanced spreadsheet application. For the seasoned analyst, accountant, financial professional, management consultant, or engineer—this is the book you’ve been waiting for!

Author Jordan Goldmeier builds on a foundation of industry best practices, bringing his own forward-thinking approach to Excel and rich real-world experience, to distill a unique blend of advanced essentials. Among other topics, he covers advanced formula concepts like array formulas and Boolean logic and provides insight into better code and formulas development. He supports that insight by showing you how to build correctly with hands-on examples.

Bibliographic Information

Buy it now

Buying options

eBook USD 59.99
Price excludes VAT (USA)
  • Available as EPUB and PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book USD 79.99
Price excludes VAT (USA)
  • Compact, lightweight edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info

Tax calculation will be finalised at checkout

Other ways to access