Visual Blueprint
2 primary works • 4 total works
Book 8
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
Book 40
Even if you use Excel all the time, you may not be up to speed on two of Excel's most useful features. PivotTable and PivotChart turn long lists of unreadable data into dynamic, easy-to-read tables and charts that highlight the information you need most; you can tweak results with a click or easily fuse data from several sources into one document. Now you can learn how to tap these powerful Excel tools with this practical guide.
Using a series of step-by-step tutorials and easy-to-follow screenshots, this book shows you in a visual way how to create and customize PivotTables and PivotCharts, use them to analyze business data, and ultimately achieve more with less work.
Explains the benefits PivotTables and PivotCharts, two powerful features of Excel that allow users to create dynamic spreadsheetsCovers creating and customizing, analyzing business data, building custom calculations, linking to external data sources (including Access databases, Word tables, Web pages, XML data, SQL Server databases, and OLAP cubes), creating macros to automate tasks, and moreUses step-by-step tutorials and easy-to-follow screenshots, a "learn by seeing" approach for visual learnersPractical, visual, and packed with content, this is the book you need to ramp up your Excel skills with PivotTables and PivotCharts.
Aimed at Excel power users who appreciate logical, clean explanations of techniques, this visual guide features numerous screenshots and easy-to-follow numbered steps in order to show you how to perform professional-level modeling, charting, data sharing, data access, data slicing, and other functions. You'll find super techniques for getting the most out of Excel's statistical and financial functions, Excel PivotTables and PivotCharts, Excel Solver, and more.
Demonstrates how to crunch and analyze Excel data the way the professionals do in an uncluttered, visual style
Offers a clear look at power-using the new Excel 2013, the latest version of the world's leading spreadsheet application from Microsoft
Expands your Excel knowledge and helps you use Excel data more efficiently
Explains how to retrieve data from databases; cut, slice, and pivot data using PivotTables; model data and chart data; and use advanced formulas
Explores all features and functions in two-color pages packed with screenshots, numbered steps, and other visual graphics that clearly show you how to accomplish tasks
Includes practical examples, tips, and advice to help you get the most out of Excel's features and functions
Learn the full power of Excel 2013 with this helpful guide!
