A comprehensive guide to designing, building, and implementing financial models, The Handbook of Financial Modeling provides corporate finance and accounting professionals with the tools they need to precisely and effectively create and utilize effective corporate and financial models.
Pro Excel 2007 VBA is the complete guide to creating Excel VBA applications, including coverage of new features in Excel 2007. Covering object-oriented programming techniques, debugging, and error handling methodologies, this book quickly turns novice into expert as it explores COM and .NET components and the advantages of compiled code.
This book covers the entire breadth of situations you might encounter when working with PivotTablesfrom planning and creating, to formatting and extracting data, to maximizing performance and troubleshooting.
Excel As Your Database is ideal if you need to manage facts and figures, yet have little need for a full-scale relational database management system. You'll learn how to use Excel to enter, store, and analyze your data. This book assumes some exposure to Excel, but no prior experience with databases.
Over 500 screen visuals and clear-cut instructions guide you through the features of Excel 2010, from formulas and charts to navigating around a worksheet and understanding Visual Basic for Applications and macros.
Debra Dalgleish, Microsoft Office Excel "Most Valuable Professional" since 2001, and an expert and trainer in Excel, brings together a one-stop resource for anyone curious about representing, analyzing, and using their data with PivotTables and PivotCharts.
Excel 2007: Beyond the Manual will introduce those who are already familiar with Excel basics to more advanced features, like consolidation, what-if analysis, PivotTables, sorting and filtering, and some commonly used functions.