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