Год выпуска: 2010 Автор: Paul McFedries Издательство: Страниц: 304 ISBN: 9780470591611
Описание
Welcome to the only guidebook series that takes a visual approach to professional–level computer topics. Open the book and you?ll discover step–by–step screen shots that demonstrate over 135 key techniques with Excel PivotTables and PivotCharts, including: Creating a table for a PivotTable report Converting a PivotTable to regular data Changing the Report Filter layout Formatting PivotTable cells Displaying a data table with a PivotChart Performing PivotTable calculations Building formulas for PivotTables Filtering records with Query criteria Creating an OLAP cube data source Learning VBA basics for PivotTables High–resolution screen shots demonstrate each task Succinct explanations walk you through step by step Two–page lessons break big topics into bite–sized modules "Apply It" and "Extra"...
