Excel Books
-
Pro Excel Financial Modeling: Building Models for Technology Startups
Published 11 years ago includes sample chapter
by Tom Y. Sawyer, Apress
Learn the business thinking behind financial modeling and execute what you know effectively using Microsoft Excel. Many believe that sales and profitability projections shown in financial models are the keys to success in attracting investors. The truth is that investors will come up with their own projections. The investor wants to understand the assumptions, structure, and relationships within the modeling of a startup.
-
Beginning PivotTables in Excel 2007: From Novice to Professional
Published 13 years ago includes sample chapter
by Debra Dalgleish, Apress
Beginning PivotTables in Excel 2007 explains what Pivot Tables are, how you can benefit from using them, how to create them and modify them, and how to use their enhanced features. Using a Pivot Table in Microsoft Office Excel 2007 is a quick and exciting way to slice and dice a large amount of data.
-
Excel 2007: Beyond the Manual
Published 13 years ago includes sample chapter
by Helen Dixon, Apress
Many experienced users may initially find Excel 2007 rather disorientating. But 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. Youll learn how to maximize your efficiency at producing professional-looking spreadsheets and charts and become competent at analyzing data using a variety of tools.
-
Excel as Your Database
Published 14 years ago includes sample chapter
by Paul Cornell, Apress
Excel As Your Database guides those of you who need to manage facts and figuresyet have little experience, budget, or need for a full-scale relational database management system. Youll learn how to use Excel to enter, store, and analyze your data. This book is written and organized in a way that assumes you have some familiarity with Excel, but not with databases. The book features quick-start solutions, practice exercises, troubleshooting tips, and best practices.
-
Excel Pivot Tables Recipe Book: A Problem-Solution Approach
Published 15 years ago includes sample chapter
by Debra Dalgleish, Apress
Here is the item of choice for any advanced Excel user who seeks recipes for pivot table success. — Midwest Book Review, California Bookwatch Excel Pivot Tables Recipe Book: A Problem-Solution Approach is for anyone who uses Excel frequently. This book follows a problem-solution format that 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.