Home | Best Seller | FAQ | Contact Us
Browse
Art & Photography
Biographies & Autobiography
Body,Mind & Health
Business & Economics
Children's Book
Computers & Internet
Cooking
Crafts,Hobbies & Gardening
Entertainment
Family & Parenting
History
Horror
Literature & Fiction
Mystery & Detective
Nonfiction
Professional & Technology
Reference
Religion
Romance
Science
Science Fiction & Fantasy
Sports & Outdoors
Travel & Geography
   Book Info

enlarge picture

Excel Data Analysis: Your Visual Blueprint for Creating and Analyzing Data, Charts and PivotTables  
Author: Jinjer Simon
ISBN: 0764537547
Format: Handover
Publish Date: June, 2005
 
     
     
   Book Review


From Book News, Inc.
Intended for novice data analysts familiar with Excel, this guide demonstrates how to create Excel lists, apply conditional formatting and filters, build complex formulas with the insert function dialog box, optimize the presentation of data with charts and PivotTables, and use VBA to create macros. The CD-ROM contains trial versions of FinOptions XL 2.0, Sigma XL 1.1, Unistat 5.5, and 4Tops Data.Copyright © 2004 Book News, Inc., Portland, OR


Book Description
* 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


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.




Excel Data Analysis: Your Visual Blueprint for Creating and Analyzing Data, Charts and PivotTables

FROM THE PUBLISHER

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

SYNOPSIS

Intended for novice data analysts familiar with Excel, this guide demonstrates how to create Excel lists, apply conditional formatting and filters, build complex formulas with the insert function dialog box, optimize the presentation of data with charts and PivotTables, and use VBA to create macros. The CD-ROM contains trial versions of FinOptions XL 2.0, Sigma XL 1.1, Unistat 5.5, and 4Tops Data. Annotation © 2004 Book News, Inc., Portland, OR

     



Home | Private Policy | Contact Us
@copyright 2001-2005 ReadingBee.com