Next Generation Excel: Modeling in Excel for Analysts and... and over one million other books are available for Amazon Kindle. Learn more
  • List Price: $120.00
  • Save: $95.33 (79%)
Rented from RentU
To Rent, select Shipping State from options above
Due Date: Dec 22, 2014
FREE return shipping at the end of the semester. Access codes and supplements are not guaranteed with rentals.
Used: Good | Details
Sold by RentU
Condition: Used: Good
Comment: Fast shipping from Amazon! Qualifies for Prime Shipping and FREE standard shipping for orders over $35. Overnight, 2 day and International shipping available! Excellent Customer Service.. May not include supplements such as CD, access code or DVD.
Access codes and supplements are not guaranteed with used items.
Trade in your item
Get a $7.90
Gift Card.
Have one to sell? Sell on Amazon
Flip to back Flip to front
Listen Playing... Paused   You're listening to a sample of the Audible audio edition.
Learn more
See this image

Next Generation Excel: Modeling in Excel for Analysts and MBAs Hardcover – December 2, 2009

ISBN-13: 978-0470824733 ISBN-10: 0470824735 Edition: 1st

Price: $44.72
Price: $24.67
16 New from $49.98 13 Used from $38.00
Rent from Amazon Price New from Used from
"Please retry"
"Please retry"
$49.98 $38.00

Customers Who Bought This Item Also Bought


Shop the new
New! Introducing the, a hub for Software Developers and Architects, Networking Administrators, TPMs, and other technology professionals to find highly-rated and highly-relevant career resources. Shop books on programming and big data, or read this week's blog posts by authors and thought-leaders in the tech industry. > Shop now

Product Details

  • Hardcover: 250 pages
  • Publisher: Wiley; 1 edition (December 2, 2009)
  • Language: English
  • ISBN-10: 0470824735
  • ISBN-13: 978-0470824733
  • Product Dimensions: 10.1 x 7.3 x 1.1 inches
  • Shipping Weight: 2 pounds
  • Average Customer Review: 4.5 out of 5 stars  See all reviews (24 customer reviews)
  • Amazon Best Sellers Rank: #779,640 in Books (See Top 100 in Books)

Editorial Reviews

From the Inside Flap

Next Generation Excel – Modeling in Excel for Analysts and MBAs is not just another "how to use Excel" book. The content of this book is the distillation of the feedback of many years of teaching, both in classrooms as well as corporate workshops settings. It is the author's conclusion that in studying applications, people do not want to read long complicated explanations. Therefore, this book is filled with short descriptions and multiple screenshots, to walk the reader through the different manipulations.

Excel is a very powerful—and extensive—software program. The intricacies can seem overwhelming to the casual user. This book is the answer to simplifying what might seem complicated. Using a step-by-step, hands-on approach, it will help anyone using the program discover many functions and achieve immediate results, quickly making efficient use of the power of the Excel options.

Some of the subjects covered in the book include:

  • Financial functions
  • Data mining using Pivot Tables
  • Statistics for non-statisticians
  • Accounting
  • What-if analysis, and many more.

    Each chapter is subject-specific and can be consulted independently from the others. By opening the book at any chapter, the reader will find valuable information for immediate efficiency improvement.

    Neither a beginner’s introductory book, nor a power-user's manual, Next Generation Excel—using Excel 2007, with explanations pertaining to Excel 2003 and previous versions when needed—is designed to appeal to analysts, executives, students, daily users as well as instructors in the software. All the techniques described have been extensively tested with students and workshop participants.

    Users at any level will benefit from the wealth of information within, easily and rapidly.

  • From the Back Cover

    "Dr. Isaac Gottlieb personally trained 35 of our top analysts and finance professionals in a customized advanced Excel seminar. Many of the tools covered in this book were part of this well-received training. For the past five years, Isaac’s monthly Excel-Tip-Of-The-Month newsletter has been a personal favorite of mine. In an age where email overload is common, I always look forward to his email and many of my associates and team members around the world are part of his over 50,000 monthly recipients. This compilation is a must-have for any finance professional who wants to be a better business partner and truly add value in a more efficient manner!"
    Anthony N. Caspio, CMA
    Vice President - Finance
    Sealed Air Corporation

    "Excel has been one of the most powerful applications of recent times, but most users, unfortunately, only scratch its surface. Prof. Gottlieb’s book leverages his years of Excel workshops in the US, Europe and Asia, and he unleashes the tremendous potential and power of Excel. His to-the-point explanations and his innovative screenshots bring Excel alive to readers who may just have a working knowledge of the software. This amazing volume is an application-oriented book for Excel users who want answers fast, and who need to maximize the application’s awesome potential."
    Prof. Farrokh Langdana, Ph.D.
    Director, Rutgers Executive MBA
    Professor, Rutgers Business School

    "If I should thank Microsoft for inventing Excel, then I would like to thank Dr. Isaac Gottlieb more for teaching me how to use it to solve the real problems in my real work. Keep going Isaac!"
    Wu Haowen
    Director of International Programs
    School of Management, Dalian University of Technology

    "Isaac Gottlieb's Next Generation Excel is an invaluable resource. The fruit of many years of teaching Excel to university business students, Gottlieb’s book covers the topics that the Excel user needs to become more efficient and sophisticated. It is easy to read and follow. A wonderful book!"
    Simon Benninga
    Professor of Finance, Faculty of Management, Tel Aviv University
    Author of Principles of Finance with Excel

    "As an avid user of Excel, several years ago I came across Isaac's Excel-Tip-Of-The-Month newsletter. I quickly realized that Isaac exploits Excel to the “next usability level.” Like his monthly newsletters, Isaac has composed a book that is clear and concise similarly reflecting his teaching methods. This book helps intermediate users to rapidly acquire Excel-pro skills, while allowing advanced users to grasp concepts in one single pass-through. Furthermore, Isaac takes day-to-day challenges and provides elegant ease of use solutions."
    Moshe Castiel
    Manager, IT – Technology & Operations

    "Next Generation Excel presents an interesting perspective on the resourcefulness of Microsoft Excel like never before. This book is an excellent and a much-needed resource to MBA students, educators and Excel enthusiasts. In reviewing this book, the principal criteria included content, organization and Excel add-on files. The book is neatly organized into sections; starting with basic Excel tools and functions, commonly used statistical tools, what-if-analysis and then moving on to advanced data features, solver-add ins and various other ToolPaks, nicely complemented with the Excel snapshots to provide a user friendly experience. As a result, one can jump directly to the relevant sections and use the Excel files provided to get a more hands-on experience. The right mix of theory and practice, is the unique selling point (USP) of this book!"
    Anirudha "Andy" Vaidya, MBA
    AVS System

    More About the Author

    Dr. Isaac Gottlieb earned his PhD in Management Engineering from Columbia University. He is a clinical professor at the Fox Business School of Temple University and has over 15 years of industrial experience.

    Dr. Gottlieb has taught Excel over the last 15 years to over 30,000 MBA, executive MBA, MS, PhD and undergraduate students at Columbia, NYU, Temple, and other universities. He has conducted numerous corporate seminars in the United States and abroad.

    As a result of years of teaching, Dr. Gottlieb has found that step-by-step and hands-on approaches are the most effective learning tools. The first edition of his book was written to appeal to practitioners, students, and instructors.

    In the second edition Dr. Gottlieb added chapters for recently developed features. His book is written with Excel 2010 in mind. Every chapter has an appendix for Excel 2007, 2003, and MAC Excel 2011.

    Next Generation Excel has hundreds of screen shot graphic illustrations. Every chapter has review questions at the end (with the answers!). Applying one's knowledge to various problems ensures that the reader truly understands the topics covered in each chapter of Next Generation Excel.

    If you wish to get the Excel-Tip-of-the-Month newsletter send an email to See a sample of recent ones at
    See a short clip of the last chapter:

    Customer Reviews

    4.5 out of 5 stars
    5 star
    4 star
    3 star
    2 star
    1 star
    See all 24 customer reviews
    His book is laid out in a very concise, neat organization.
    Paige Turner
    If you want to learn how to really take advantage of the magic of model-building in Excel, this book is probably a great starting point.
    Paul A. King
    Very thorough, without unnecessary broad coverage of common things that everybody already knows.
    Amazon Customer

    Most Helpful Customer Reviews

    30 of 31 people found the following review helpful By Paige Turner on December 6, 2009
    Format: Hardcover Verified Purchase
    I heartily recommend this book to anyone that uses Excel on a daily basis for business analysis or for MBA students. Early in the introduction, Dr. Gottlieb promises that if you use Excel for 10 hours a week or more, this book will save you hundreds of hours per year. He delivers!

    You don't need to build an excel spreadsheet to calculate that this book is worth many times its cover price to users of excel. Even if you are a "power user" you will quiclky find tips that will make you more efficient.

    I was fortunate enough to take an Excel class from Dr. Gottlieb a few years ago during the "crash math course" week while getting an MBA at Columbia University. I don't want to offend any of my esteemed professors, but those few hours with Dr. Gottlieb were probably more useful than several of my semester-long courses to me. I currently use Excel for 3-4 hours per day to analyze stocks at my hedge fund and his tips have saved me hours and helped to make my graphical representation of data look top-notch.

    This book is not a basic "how-to" or "for dummies" book on Excel. It is the perfect book for you if you use Excel frequently, but are frustrated that you have to perform certain repetitive keystrokes or clicks to get it do what you want. Perhaps you want your charts to look better. Maybe you didn't even know that you could have custom lists built in, for example, instead of manually entering FQ01, FQ02, etc. You can add trend lines to graphs; you can format parts of graphs differently than other parts. You can name cells, groups of cells to make your work easier.

    Dr. Gottlieb exposes the many keystroke shortcuts that can make your daily grind with Excel less laborious. His book is laid out in a very concise, neat organization.
    Read more ›
    Comment Was this review helpful to you? Yes No Sending feedback...
    Thank you for your feedback. If this review is inappropriate, please let us know.
    Sorry, we failed to record your vote. Please try again
    24 of 25 people found the following review helpful By Jaewoo Kim VINE VOICE on May 27, 2010
    Format: Hardcover Verified Purchase
    This book offers some of the more useful features of MS Excel for analysts and MBAs. It does not offer Excel tips that one can't obtain from far cheaper and more comprehensive Excel books.

    The explanations are well done and every chapter has review problems. The DVD also contains the Excel spreadsheets for each chapter for practice exercises.

    Most of the Excel topics are covered superficially yet enough to benefit most people. For example, the chapter on Pivot Tables was well done but it only covered the main features of pivot table and lacked depth and details. If you want detailed understanding of all the Excel's features, then this book will fall short. If you only want the most useful Excel features specifically for finance and business school students, then this book will do its job.

    The book covers the following:

    1)Using Excel efficiently (autofill, formulas, functions, naming cells, ranges, charts)
    2)If and Text Manipulations(if functions, text manipulation,Stat tools)
    3)What if Analysis (What if, goal seek, one and two way data tables, scroll bars)
    4)Multiple page systems and lookups (Lookup tables)
    5)Data menu and ribbon (Sorting, autofilter, grouping data, subtotal, pivot tables, data mining)
    6)Excel financial tools (NPV, IRR, XNPV, XIRR, Amortization, depreciation)

    If you already have basic understanding of Excel, then this book will take your Excel skill to the next level. If you are a total beginner, then I recommend a more beginner's book. If you are looking for a comprehensive Excel text and want to become an Excel expert, then I would look elsewhere or use this book as a supplement.
    Comment Was this review helpful to you? Yes No Sending feedback...
    Thank you for your feedback. If this review is inappropriate, please let us know.
    Sorry, we failed to record your vote. Please try again
    7 of 7 people found the following review helpful By BOOKBURNER01 on March 31, 2012
    Format: Hardcover Verified Purchase
    If the reader expects a book which treats Excel and the subject of various analyses topics at the basic, superficial level mostly, or moderately advanced level few times, this book should prove satisfactory.

    On the other hand, if the reader expects to gain sophisticated analytical skills, tools, or advanced decision making templates, this book fails to satisfy that expectation.

    Case in point, the book contains 289 pages of text, excluding introduction, index, etc, and the author dedicates 39 of these pages to very basic topics such as, auto-fill, relative and absolute cell references, working with named ranges, and similar basic skills.

    The chapters dealing with charts, descriptive statistics, and sensitivity analysis are very useful and informative, but fairly basic.

    It is regrettable that the treatment of "what-if analysis" function, and "Solver Add-ins" are discussed only very briefly.

    On the CD ROM which accompanies this book, the various data tables, practice sets, and solutions worksheets are presented with very little consistency in formatting, style, or sophistication. Certainly not how skilled analysts manage data or present their finished analyses.

    This book offers very little for a skilled Excel user, or analyst.
    Comment Was this review helpful to you? Yes No Sending feedback...
    Thank you for your feedback. If this review is inappropriate, please let us know.
    Sorry, we failed to record your vote. Please try again
    3 of 3 people found the following review helpful By Paul A. King on November 28, 2010
    Format: Hardcover Verified Purchase
    I have taken Isaac Gottlieb's MBA Excel course twice. I didn't / couldn't get enough the first time; it was just too fast-paced to get it all in one two-day event. I enjoy Isaac's Excel Tip-of-the-Month newsletters, but I rarely get time to regularly read them when they arrive. This new book is a very carefully organized, easy to read practice manual designed to get most mid-level Excel users to near-Wizard status.

    If you currently use Excel on a regular basis in your work or studies, then his claim that you will save ten hours per week is probably true. If you want to learn how to really take advantage of the magic of model-building in Excel, this book is probably a great starting point.

    The accompanying practice CD works with Excel 2003 and 2007 and I have found that is also works just as well in Excel 2010).
    Comment Was this review helpful to you? Yes No Sending feedback...
    Thank you for your feedback. If this review is inappropriate, please let us know.
    Sorry, we failed to record your vote. Please try again

    Most Recent Customer Reviews