- Hardcover: 304 pages
- Publisher: Wiley; 2 edition (March 4, 2013)
- Language: English
- ISBN-10: 1118469100
- ISBN-13: 978-1118469101
- Product Dimensions: 7.4 x 1.4 x 10.3 inches
- Shipping Weight: 1.8 pounds (View shipping rates and policies)
- Average Customer Review: 4.7 out of 5 stars See all reviews (8 customer reviews)
- Amazon Best Sellers Rank: #852,550 in Books (See Top 100 in Books)
To get the free app, enter your mobile phone number.
Next Generation Excel: Modeling In Excel For Analysts And MBAs (For MS Windows And Mac OS) 2nd Edition
Use the Amazon App to scan ISBNs and compare prices.
This month's Book With Buzz: "The Lying Game" by Ruth Ware
From the instant New York Times bestselling author of blockbuster thrillers "In a Dark, Dark Wood" and "The Woman in Cabin 10" comes Ruth Ware’s chilling new novel, "The Lying Game." See more
Frequently bought together
Customers who bought this item also bought
From the Inside Flap
Most Excel users never realize just how powerful the program really is. Featuring more than 400 functions, Excel is packed with an array of complex data mining, analytical, statistical, and graphical representation tools and other powerful features of inestimable value to business professionals. But learning how to exploit those features with confidence can be tricky, even overwhelming, for the casual user.
Enter Next Generation Excel, Second Edition.
Growing out of Dr. Gottlieb's many years of teaching university classes, as well as his extremely popular corporate workshops, Next Generation Excel, Second Edition is based upon his well-founded conviction that, when it comes to teaching people how to use and get the most out of complex software, "show, don't tell" is the golden rule.
Staying true to that philosophy, he eschews the lengthy, often perplexing, verbal explanations typical of such guides in favor of bite-sized descriptive passages, liberally supplemented with Excel-in-action screenshots, skill-building exercises, and review questions. Also, for ease of reference, each subject-specific chapter is self-contained, affording you the option of focusing on only those features of immediate interest to you.
Demystifying the obscure and simplifying the complex, Dr. Gottlieb walks you, step by step, through all of Excel 2010's advanced business and finance functions (with explanations for users of Excel 2007, 2003, and previous versions, as needed), including:
- Financial tools, including NVP and IRR
- Data mining using Pivot Tables
- Charting, sparklines, and other advanced charting options
- Data analysis tools
- What-if analysis
- Statistics for non-statisticians
- Accounting functions, including amortization tables and depreciation functions
Not just another general how-to Excel guide, this fully updated and expanded Second Edition of Isaac Gottlieb's internationally acclaimed Next Generation Excel shows you how to harness the full power of Excel to help you to perform an array of advanced business decision making, financial, and accounting functions. You'll learn how to quickly create models that deliver accurate, relevant information to boost efficiency, improve your forecasting ability, and perform an array of other crucial business and reporting functions.
From the Back Cover
Advance Praise for Next Generation Excel, Second Edition
"As an avid user of Excel, I rely on Isaac's 'Excel Tip Of The Month' newsletter, which reflects his teaching methods and ability to clearly present ideas and topics. In his newest book, Isaac showcases how the reader can engage with Excel to the 'next level of usability.' This edition helps intermediate users to quickly acquire 'pro Excel' skills, while enabling advanced users to grasp concepts in a single pass-through. Isaac takes day-to-day Excel challenges and provides the reader with elegant ease of use solutions. With this newest edition, Isaac propels practical information even further."
Moshe Castiel, Vice President, Data Management and Analytics, JPMorgan Chase
"If you thought MS Excel was nothing more than an overpriced calculator with a pretty chart wizard thrown in, then hold your hat and get ready for some fun. Next Generation Excel will revolutionize how you do your work and make you a better manager, at any career level."
John Tintera, VP, Sales & Publicity, Osprey Group
"A detailed understanding of Excel is critical to the performance of nearly all financial analysts today. Dr. Gottlieb's book not only describes the most important Excel functions, but also dramatically increases the productivity of Excel users. My favorite parts of the book include the sections on Solver, Pivot Tables, and Sensitivity Analysis. Each of these areas is critical to the work done by advanced financial analysts. Companies are expecting more from their MBA hires today, and this book can give recent graduates a leg up on the competition."
John M. Longo, PhD, CFA, Clinical AssociateProfessor of Finance and Economics, Rutgers Business School; Chief Investment Officer, The MDE Group, Inc.
"Isaac Gottlieb is an Excel master and a teacher par excellence. The second edition of Next Generation Excel improves on an already excellent first edition. New materials like multi regression simplified and the new Excel 2010 features make this an invaluable resource for the Excel user. Mac users (a growing group) will like the chapter appendices dedicated to making their lives easier."
Simon Benninga, Professor, Faculty of Management, Tel Aviv University
If you are a seller for this product, would you like to suggest updates through seller support?
Top customer reviews
Great way to get up to speed quickly
Every chapter comes with spread sheets for quickly duplicating everything in the book
Lots of good review questions at the end of the book
Teaches and reinforces efficient ways of solving practical business problems
Incredible amount of typos for a second edition
Kindle version doesn't include an index with page numbers - so its useless
This is the second version of Gottieb's very popular book teaching excel to business and finance professionals. I spent about a week 4-5 hours a day working through this book in conjunction with the downloadable excel files going through it chapter by chapter. It was time well spent and my excel skills improved dramatically.
I found the reviews of the first version of this book to be right on. The author does do a great job of painlessly teaching the information. True power users will likely learn something new but may find some of the information to be too basic.
The biggest problem with the old version is still here. Surprisingly, this updated edition is still filled with lots of typos, errors in spreadsheets and a few incorrect answers which seems to get worse towards the end of the book.
For example, figure 29.7 contains formulas that omit the last row. The screen shot in excel even points this out and includes the warning indicator that the formula is missing adjacent cells - i.e., the missing row. Chapter 29 question #6 option #3 asks the reader to calculate the IRR for a situation with an initial investment of 300,000 to gain 450,000 at the end of year 3. My excel spreadsheet and an online calculator indicates the correct answer to be 14.47% but the book says 7.46%.
I would guess I probably spent an extra 5-6 hours overall from double checking and reviewing stuff due to the errors in the book. For some readers this won't be a big deal. However, for those of us meticulously going through every exercise in the book it does get quite tiresome after awhile.
So why did I give it 4 stars and not a lower score? It really is organized incredibly well and laid out in a way that makes it easy to rework the problems and integrate the most efficient process for solving a range of typical business problems. I had tried other well reviewed books previously but found some of them took too much time and effort trying to figure out what the author was trying to teach and then to learn how to do it in the spreadsheet. As a result, I never got very far using those books.
In this book, the author includes hundreds of well thought out screen shots with arrows and inserted notes pointing out where the reader should be looking, what exactly they should be clicking and how to perform the new skill as effortlessly as possible. Yes, it is more expensive compared to other books teaching similar skills but far less time is wasted learning the new skills.
I used the kindle version on my Nexus 7 and found it typical of most kindle version textbooks. Most of the graphs were easy to read requiring no extra zooming, there are no page numbers in the table of contents but does contain active links and the index is useless containing neither page numbers nor active links.
This book is specifically for Excel versions 2007 and 2010 with extra material for Mac's excel 2011 and excel 2003. I started the book using my old copy of excel 2007. However, once I saw a few cool newer options that wasn't in my version I decided to try excel 2013 via the free trial as this was going to be my one chance to really spend lots of time learning excel so might as well try to be up to date. This worked out very well and the book was still very easy to follow. I'll most likely continue the Office 365 subscription as its clearly better than my old version.
If you already work with excel, then this book is probably not for you. I will suggest it for beginners. (I work with excel on a daily basis constructing complicated financial models, so my definition of basic might be a bit high, but you can judge the level of this book by using the free previews). Intermediate and advanced users can probably still pick up a few new tricks from this book.