Enter your mobile number or email address below and we'll send you a link to download the free Kindle App. Then you can start reading Kindle books on your smartphone, tablet, or computer - no Kindle device required.

  • Apple
  • Android
  • Windows Phone
  • Android

To get the free app, enter your email address or mobile phone number.

Next Generation Excel: Modeling in Excel for Analysts and MBAs 1st Edition

4.5 out of 5 stars 24 customer reviews
ISBN-13: 978-0470824733
ISBN-10: 0470824735
Why is ISBN important?
This bar-code number lets you verify that you're getting exactly the right version or edition of a book. The 13-digit and 10-digit formats both work.
Scan an ISBN with your phone
Use the Amazon App to scan ISBNs and compare prices.
Have one to sell? Sell on Amazon
Rent On clicking this link, a new layer will be open
$21.91 On clicking this link, a new layer will be open
Buy used On clicking this link, a new layer will be open
$31.28 On clicking this link, a new layer will be open
More Buying Choices
17 New from $18.96 23 Used from $17.57
click to open popover

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


    Product Details

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

    Customer Reviews

    Top Customer Reviews

    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 30 people found this helpful. Was this review helpful to you? Yes No Sending feedback...
    Thank you for your feedback.
    Sorry, we failed to record your vote. Please try again
    Report abuse
    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 24 people found this helpful. Was this review helpful to you? Yes No Sending feedback...
    Thank you for your feedback.
    Sorry, we failed to record your vote. Please try again
    Report abuse
    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 8 people found this helpful. Was this review helpful to you? Yes No Sending feedback...
    Thank you for your feedback.
    Sorry, we failed to record your vote. Please try again
    Report abuse
    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 3 people found this helpful. Was this review helpful to you? Yes No Sending feedback...
    Thank you for your feedback.
    Sorry, we failed to record your vote. Please try again
    Report abuse

    Most Recent Customer Reviews