Take Excel to the next level in accounting and financial modeling.
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.
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. He 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.
