Page 1 - Excel Data Analysis

•
•
•
•
•
Perfect bind
useful tips
Filtering a list
Trim: 8 X 9
*85555-IGFJJa
sidebars highlight
“Apply It” and “Extra”
Bleed: .25”
Importing and linking data
$26.99
$39.99
£18.95
Category:
Creating an amortization table
UK
Spreadsheets
USA
CAN
Compiling data from various sources
Creating PivotTables and PivotCharts
537547 Cover 2/25/03 10:15 AM Page 1
•
•
•
•
•
each task
System requirements: Windows 98 or higher.
over 100 key Excel data analysis techniques,
shots demonstrate
High-resolution screen
including:
4-color process plus Pantone 2945 cv Matte layflat
Welcome to the only guidebook series that takes a visual
See the What’s on the CD-ROM Appendix for details and complete system requirements.
Building PivotTable formulas
Using Analysis ToolPak Add-ins
and you’ll discover step-by-step screen shots that demonstrate
Editing external database tables
approach to professional-level computer topics. Open the book
Manipulating data within a chart
Using an Excel function in a macro
step by step
walk you through
www.wiley.com/compbooks
Succinct explanations
book
CD-ROM!
• Macro codes

• UNISTAT demo version
Data analysis tools on
Analyse-It, Sigma XL, 4TOPS
• A searchable e-version of the
Data Analysis, and XLSTAT Pro
ISBN 0-7645-3754-7
• Trial versions of FinOptions XL,
Two-page lessons
bite-sized modules
break big topics into
,!7IA7G4-fdhfeh!:p;m;Q;t;T

Simon
Excel Data Analysis

•
•

book, and more
Y

and other trial software

Data analysis tools on CD-ROM!
FinOptions XL, Analyse-It, Sigma XL,
Plus macro codes, an e-version of the
data,

charts,
our visual blueprint
™

and PivotT

for analyzing
ables
Excel Data Analysis