Excel Data Analysis

Your Visual blueprint for analyzing data, charts, and Pivot Tables

Jinger Simon

292 pages, parution le 18/08/2005 (2^eme édition)

Ajouter à une liste

Indisponible

Résumé

Excel is a spreadsheet / data analysis tool attached to the Microsoft Office suite and is available in all Office offerings. Office holds 80-90% of the market share for productivity suites. Though many consumers know the basics of using Excel, they may not know the full power of the program. With Excel, you can harness the power of your data, manipulate it to suit your needs, and achieve more by doing less work. Charts are interactive, allowing the consumer to tweak results with the click of a mouse. Pivot tables allow you to fuse data from several sources into one document. Excel has an enhanced Find function, allowing users to easily search entire workbooks, and search worksheets by cell format. Excel supports XML as a file format for easy importing or exporting of XML data. Excel also includes enhancements for saving files as Web pages, and enhancements to Pivot Tables.

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.

Sommaire

How To Use This Book
Getting Started With Excel
Organize Worksheet Data
Evaluate Worksheet Data
Creating Formulas
Working With External Data
Chart Data
Working With Pivottable Reports
Creating Pivotcharts
Automating Actions With Macros
Using Forms And Dialog Boxes
Using The Analysis Toolpack Add-Ins
Appendix A: Excel Keyboard Shortcuts
Appendix B: Excel Function Quick Reference
Appendix C: VBA And Excel Events Quick Reference
Appendix D: Formula Basics In Excel
Appendix E: What's On The CD-Rom
Index

Voir tout

Replier

Caractéristiques techniques

	PAPIER
Éditeur(s)	Wiley
Auteur(s)	Jinger Simon
Parution	18/08/2005
Édition	2^eme édition
Nb. de pages	292
Format	20,5 x 23
Couverture	Broché
Poids	689g
Intérieur	2 couleurs
EAN13	9780764597800
ISBN13	978-0-7645-9780-0