## With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

No credit card required

## Book Description

"

Advanced Excel Essentials is the only book for the experienced Excel developer. This book starts from the assumption that you are well-versed in Excel and builds on your your skills to take them to the advanced level. This book will show you the building blocks of advanced development and then take you through the development of your own advanced spreadsheet application. For the seasoned analyst, accountant, financial professional, management consultant, and engineerthis is the youve been waiting for!

Covers advanced formula topics like array formulas and Boolean logic

Shows you how to build correctly with hands-on examples

Provides insight into better code and formulas development

Builds on a foundation of industry best practices and the authors hard won real-world experience

"

1. Cover
2. Title
4. Dedication
5. Contents at a Glance
6. Contents
9. Acknowledgments
10. Part I: Core Advanced Excel Concepts
1. Chapter 1: Introduction to Advanced Excel Essentials
1. What to Expect from this Book
2. The Two Most Important Principles
3. Available Resources
4. The Last Word
2. Chapter 2: Visual Basic for Applications for Excel, a Refresher
1. Making the Most of Your Coding Experience
2. Naming Conventions
3. Referencing
4. Development Styles and Principles
5. The Last Word
3. Chapter 3: Introducing Formula Concepts
1. Formula Help
2. Excel Formula Concepts
3. When to Use Conditional Expressions
4. Introduction to Boolean Concepts
5. Do We Really Need IF?
6. The Last Word
4. Chapter 4: Advanced Formula Concepts
1. Filtering and Highlighting
2. Selecting
3. Aggregating
4. Reusable Components
5. The Last Word
5. Chapter 5: Working with Form Controls
1. Welcome to the Control Room
2. Form Control Fundamentals
3. Creating Scrollable Tables
4. Highlighting Data Points on Charts
5. The Dynamic Legend
6. The Last Word
11. Part II: A Real World Example
1. Chapter 6: Getting Input from Users
1. Of Input Forms and Excel
3. The Last Word
2. Chapter 7: Storage Patterns for User Input
1. The World Health Organization: An Applied Example
2. The Database
4. Wizard Summary Buttons
5. The Last Word
3. Chapter 8: Building for Sensitivity Analysis
1. Weighted Average Models
2. Sensitivity Analysis on a Weighted Average Model
3. Building the Tool
4. The Last Word
4. Chapter 9: Perfecting the Presentation
1. Implementation and Design of the Weight Adjustment System
2. Displaying Data from the Intermediate Table
3. “Sort By” Dropdown and Sort Labels
4. The Presentation Display Buttons
5. Data Display and Aesthetics
6. The Last Word
12. Index