Advanced Excel Essentials

By:

Sign Up Now! Already a Member? Log In
You must be logged into Bookshare to access this title. Learn about membership options, or view our freely available titles.

Synopsis
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. What you'll learn How to build better, faster, and leaner spreadsheets that will make you a force to be reckoned with in your organization How to write optimized code and formulas that are easily understood even by less experienced users How to turn a spreadsheet into a powerhouse application that rivals commercial software About the tools and techniques for optimal layout, data storage, and advanced analytics Who this book is for Intermediate or advanced excel users who wish to learn how to be more productive and develop more powerful applications Table of Contents 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
Copyright:
2014

Book Details

Book Quality:
Publisher Quality
ISBN-13:
9781484207345
Related ISBNs:
9781484207352
Publisher:
Apress, Berkeley, CA
Date of Addition:
Copyrighted By:
Springer
Adult content:
No
Language:
English
Has Image Descriptions:
No
Categories:
Nonfiction, Computers and Internet
Submitted By:
Bookshare Staff
Usage Restrictions:
This is a copyrighted book.

Reviews

No Rating Yet