Power Search
Low Price Guarantee
We Take School POs
Structuring Excel Models: Update, Validate, Maintain, and Transfer with Ease
Contributor(s): Goldfynn, Dan (Author)

View larger image

 ISBN: 170040475X     ISBN-13: 9781700404756
Publisher: Independently Published
OUR PRICE: $8.54  

Binding Type: Paperback
Published: October 2019
Qty:
Additional Information
BISAC Categories:
- Business & Economics | Finance - General
Physical Information: 0.09" H x 6" W x 9" L (0.15 lbs) 36 pages
 
Descriptions, Reviews, Etc.
Publisher Description:
Many know how to do basic work in Excel. Some know how to build complicated models in Excel. But few know how to structure their models such that the Workbook is easy to follow, update, maintain, and hand over to someone else. Pulling from real-world experience in management consulting and finance, this book is great for Excel users--whether you are a student, professional, consultant, financial analyst, banker, accountant, or an exec that dabbles with lots of numbers.

In this guide that follows the style of Dan Goldfynn's Keep It Simple books, you will learn how to structure your Excel workbook for modeling so that you (or your teams) do not get lost in the messiness of Excel. You will learn how to implement the "separation of concerns" and build your sheets such that it is easy for you to update, maintain, and produce output that can go to presentations and executive reports, and be intuitive for anyone else to take over. Along the way you will also learn how to error check your sheets and build an error index page that can quickly and efficiently show which sheets have problems.

This book presumes you are conversant with basics of Excel. No knowledge of advanced Excel or Macros is required.
Table of Contents
  1. Introduction
  2. Separation Of Concerns
  3. Real-World Instances
  4. Anatomy Of A Model
  5. Managing Sections
  6. Error Checks
  7. Notes On Sample Excel Model
  8. Obligatory Top 10
  9. Conclusion
Also check out Dan's other "Keep It Simple" books that cover emerging technology and job search
 
Customer ReviewsSubmit your own review
 
To tell a friend about this book, you must Sign In First!