Debra Dalgleish eBooks

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. The author presents tips and techniques in this collection of recipes that cannot be found in Excel's Help section, and she carefully explains the most confusing features of PivotTables. All chapters have been organized into a collection of recipes that take you step-by-step from the problem you are experiencing to the solution you are aiming for. Theres no fuss to this book, only clear and precise informati...

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 Pivot Table in Microsoft Office Excel 2007 is a quick and exciting way to slice and dice a large amount of data. Carefully explains the benefits of using Pivot Tables for fast data analysis Provides a step-by-step approach to those new to Pivot Tables Offers tips and tricks that cannot be found elsewhere What youll learn Summarize thousands of records in a PivotTable with a few clicks of the mouse Quickly change the PivotTable layout to view a different summary of the data Filter a PivotTable to focus on one region or the top 10 products Add colors or icons to ...