Excel Data Analysis
：Your visual blueprint for creating and analyzing data, charts and PivotTables
( Visual Blueprint )
Publication subTitle ：Your visual blueprint for creating and analyzing data, charts and PivotTables
Publication series ：Visual Blueprint
Author： Denise Etheridge
Publisher： John Wiley & Sons Inc
Publication year： 2010
E-ISBN: 9780470901724
P-ISBN(Paperback): 9780470591604
P-ISBN(Hardback): 9780470591604
Subject： TP317.3 list processing software
Language： ENG
Disclaimer: Any content in publications that violate the sovereignty, the constitution or regulations of the PRC is not accepted or approved by CNPIEC.
Description
Advanced techniques for Excel power users
Crunch and analyze Excel data the way the professionals do with this clean, uncluttered, visual guide to advanced Excel techniques. Using numerous screenshots and easy-to-follow numbered steps, this book clearly shows you how to perform professional-level modeling, charting, 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.
- Provides a clear look at power-using Excel, the world's leading spreadsheet application from Microsoft, and part of the new Microsoft Office 2010 suite
- Expands your Excel knowledge and helps you use Excel data more efficiently
- Demonstrates 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 friendly, 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 Excel at the highest levels with this practical guide.
Chapter