Denise Etheridge 
Excel Data Analysis 
Your visual blueprint for creating and analyzing data, charts and PivotTables

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 Pivot Tables and
Pivot Charts, 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 Pivot Tables; 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.

About the author

Denise Etheridge (Burlington, NJ) is a certified public accountant as well as the president and founder of Bay Con Group, Inc. She publishes Web sites, provides consulting services on accounting-related software, teaches college-level computer and accounting courses, and has authored or coauthored two computer related books: Flash Action Script: Your visual blueprint for creating Flash-enhanced Web sites. In addition, she authored Excel 2007 Visual Quick Tips and Excel 2007 Top 100 Simplified Tips and Tricks. Denise has trained and assisted clients with the implementation of accounting-related software since 1985. Stanford University and the United States House of Representatives are among her former clients. Prior to founding Bay Con Group, she spent two years working for Oracle Corporation as an Oracle Financials software consultant.