
by PaulMcFedries (Author)
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 130 key techniques for working with PivotTables and PivotCharts, including: Building PivotTables from Excel ranges Customizing PivotTable field lists Converting PivotTables to regular data Grouping numeric, text, or date/time values Developing various summary calculations Turning a PivotTable into a PivotChart Displaying data tables with a PivotChart Creating an OLAP cube data source Exporting Access(r) PivotTable(r) forms to Excel Using Microsoft Query with PivotTables EXTRA Apply It Apply It and Extra sidebars highlight useful tips 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
Format: Paperback
Pages: 290
Edition: Pap/Dig
Publisher: John Wiley & Sons
Published: 02 Nov 2007
ISBN 10: 0470132310
ISBN 13: 9780470132319