Advanced Excel Essentials - Brossura

Goldmeier, Jordan

 
9781484207352: Advanced Excel Essentials

Sinossi

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.

Le informazioni nella sezione "Riassunto" possono far riferimento a edizioni diverse di questo titolo.

Contenuti

1. Introduction

2. Visual Basic for Applications for Excel, a Refresher

3. Introducing Formula Concepts

4. Advanced Formula Concepts

5. Introduction to Controls

6. Getting Input from Users

7. Storage Patterns for User Input

8. Building for Sensitivity Analysis

9. Perfecting the Presentation

Le informazioni nella sezione "Su questo libro" possono far riferimento a edizioni diverse di questo titolo.

Altre edizioni note dello stesso titolo

9781484207369: Advanced Excel Essentials

Edizione in evidenza

ISBN 10:  148420736X ISBN 13:  9781484207369
Casa editrice: SPRINGER NATURE, 2015
Brossura