Excel Data Analysis

Your Visual Blueprint for creating and analyzing data, charts, and PivotTables

Jinger Simon

302 pages, parution le 22/04/2003

Ajouter à une liste

Indisponible

Résumé

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

Contents

How to Use this Book
Getting Started with Excel
Organize Worksheet Data
Evaluate Worksheet Data
Creating Formulas
Working with External Data
Charting Data
Working with Pivottable Reports
Creating Pivotcharts
Automating Actions with Macros
Form Controls
Using the Analysis Toolpack Add-Ins

Appendixes
Index

L'auteur - Jinger Simon

Jinjer Simon has been actively involved in the computer industry for the past 18 years. Her involvement includes 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, and Windows CE 2 For Dummies.

Caractéristiques techniques

	PAPIER
Éditeur(s)	Wiley
Auteur(s)	Jinger Simon
Parution	22/04/2003
Nb. de pages	302
Format	20,2 x 23
Couverture	Broché
Poids	671g
Intérieur	2 couleurs
EAN13	9780764537547