Excel Data Analysis: Your visual blueprint for analyzing data, charts, and PivotTables (Visual Read Less, Learn More)

3.57 avg rating
( 14 ratings by Goodreads )
 
9780764537547: Excel Data Analysis: Your visual blueprint for analyzing data, charts, and PivotTables (Visual Read Less, Learn More)

* Essential for those who know basic Excel and want to explore the full potential of the program
* Teaches how to manipulate data to suit specific needs and achieve more by doing less work
* Self-contained two-page lessons, featuring high-resolution screen shots and minimal text, show how to create custom functions, retrieve data from databases, use value chains, and slice and pivot information from the Web with Excel's PivotTable utility
* Covers data analyzing techniques for statistical functions, financial functions, data sharing, PivotTables and PivotCharts, Solver, and BackSolver

"synopsis" may belong to another edition of this title.

From the Back Cover:

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 100 key Excel data analysis techniques, including:

  • Creating PivotTables and PivotCharts
  • Importing and linking data
  • Compiling data from various sources
  • Filtering a list
  • Creating an amortization table
  • Manipulating data within a chart
  • Editing external database tables
  • Using an Excel function in a macro
  • Building PivotTable formulas
  • Using Analysis ToolPak Add-ins

Data analysis tools on CD-ROM!

  • Trial versions of FinOptions XL, Analyse-It, Sigma XL, 4TOPS Data Analysis, and XLSTAT Pro
  • UNISTAT demo version
  • Macro codes
  • A searchable e-version of the book

About the Author:

Jinjer Simon has been actively involved in the computer industry for the past 18 years. Her involvement in the industry has included programming, providing software technical support, training end-users, developing written and online user documentation, creating software tutorials, and developing Web sites. She is the author of several computer books, including Excel Programming: Your visual blueprint for creating interactive spreadsheets, Windows CE For Dummies, and Windows CE 2 For Dummies.

"About this title" may belong to another edition of this title.

Top Search Results from the AbeBooks Marketplace

1.

Jinjer Simon
Published by Visual (2003)
ISBN 10: 0764537547 ISBN 13: 9780764537547
New Paperback Quantity Available: 1
Seller:
Ergodebooks
(RICHMOND, TX, U.S.A.)
Rating
[?]

Book Description Visual, 2003. Paperback. Book Condition: New. Bk&CD-Rom. Bookseller Inventory # DADAX0764537547

More Information About This Seller | Ask Bookseller a Question

Buy New
US$ 25.49
Convert Currency

Add to Basket

Shipping: US$ 3.99
Within U.S.A.
Destination, Rates & Speeds

2.

Simon, Jinjer
Published by Visual (2003)
ISBN 10: 0764537547 ISBN 13: 9780764537547
New Paperback Quantity Available: 2
Seller:
Murray Media
(North Miami Beach, FL, U.S.A.)
Rating
[?]

Book Description Visual, 2003. Paperback. Book Condition: New. Never used!. Bookseller Inventory # P110764537547

More Information About This Seller | Ask Bookseller a Question

Buy New
US$ 33.37
Convert Currency

Add to Basket

Shipping: US$ 1.99
Within U.S.A.
Destination, Rates & Speeds

3.

Simon Jinjer
Published by John Wiley & Sons
ISBN 10: 0764537547 ISBN 13: 9780764537547
New Quantity Available: 1
Seller:
Majestic Books
(London, ,, United Kingdom)
Rating
[?]

Book Description John Wiley & Sons. Book Condition: New. pp. 352. Bookseller Inventory # 4716973

More Information About This Seller | Ask Bookseller a Question

Buy New
US$ 34.11
Convert Currency

Add to Basket

Shipping: US$ 7.27
From United Kingdom to U.S.A.
Destination, Rates & Speeds

4.

Simon, Jinjer
Published by Visual
ISBN 10: 0764537547 ISBN 13: 9780764537547
New PAPERBACK Quantity Available: 1
Seller:
Cloud 9 Books
(Wellington, FL, U.S.A.)
Rating
[?]

Book Description Visual. PAPERBACK. Book Condition: New. 0764537547 New Condition. Bookseller Inventory # NEW7.1264069

More Information About This Seller | Ask Bookseller a Question

Buy New
US$ 59.99
Convert Currency

Add to Basket

Shipping: US$ 4.99
Within U.S.A.
Destination, Rates & Speeds