Next Generation Excel

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. 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. Some of the subjects covered in the book include:Financial functionsData mining using Pivot TablesStatistics for non-statisticiansAccountingWhat-if analysis, and many more.