All Excel Titles
-
A Complete Guide to PivotTables
A Complete Guide to PivotTables: A Visual Approach shows you why PivotTables are so versatile for data analysis and how you can leverage PivotTables to rapidly spot trends and make fast business decisions on mountains of data.
-
Beginning Database Design 2nd Edition
Beginning Database Design, Second Edition helps you ask and answer important questions about your data so that you can avoid pitfalls and get database design right the first time.
-
Beginning Excel What-If Data Analysis Tools
Excel's "what-if" data analysis tools let you experiment with your data to project future results. In turn, these predictions will lead to better decisionmaking and unlock the mystery of many business analysis scenarios.
-
Beginning Microsoft Excel 2010
Beginning Microsoft Excel 2010 is a practical, step-by-step guide to getting started with the world's most widely-used spreadsheet application. The book offers a hands-on approach to learning how to efficiently use Microsoft's 2010 version of Excel.
-
Beginning PivotTables in Excel 2007
Beginning PivotTables in Excel 2007 explains what PivotTables are, how you can benefit from using them, how to create them and modify them, and how to use their enhanced features. Using a PivotTable in Microsoft Office Excel 2007 is a quick and exciting way to slice and dice a large amount of data.
-
Beginning SharePoint with Excel
Beginning SharePoint with Excel is for advanced Excel users who want to extend the usefulness of Excel by adding the collaborative features of SharePoint. The authors provide easy-to-implement examples of powerful business solutions, and they take care to explore the interaction between Excel and SharePoint.
-
Dashboards for Excel is your key to creating informative, vibrant and and interactive dashboards using a hands-on approach based on real-world experience.
-
In this book, Michael Kofler provides definitive coverage of Visual Basic for Applications (VBA) for Excel by showing how it can be used to implement real-world business solutions. Designed to be useful to programmers who have never used VBA before, it also covers advanced topics needed for users already familiar with VBA.
-
Definitive Guide to Excel VBA 2nd Edition
This book is a completely updated, comprehensive introduction to programming Excel versions 2000 to 2003 using Visual Basic for Applications (VBA).
-
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.
-
Excel 2007 PivotTables Recipes
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.
-
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.



