Using a series of step-by-step tutorial and easy to follow screenshots, this book shows you a visual way how to create and customize PivotTables and PivotCharts, use it to analyze business data, and ultimately achieve more by working less. Explain the benefits and PivotCharts PivotTables, two powerful features of Excel which allows users to create dynamic spreadsheets Covers creating and modifying, analyzing business data, building custom calculations, linking to external data sources (including Access databases, Word tables, Web pages, XML data, database SQL Server, and OLAP cubes), create macros to automate tasks, and step-by-step tutorial Using more screenshots and easy to follow, a "learning by seeing" approach to visual learners Practical, visual, and packed with content, this is the book you need to improve your Excel skills with PivotTables and PivotCharts.