Analyzing Business Data with Excel
Forecasting, Statistics, and Data Management
Gerald Knight - Collection Windows Applications/Excel
Résumé
As one of the most widely used desktop applications ever created, Excel is familiar to just about everyone with a computer and a keyboard. Yet most of us don't know the full extent of what Excel can do, mostly because of its recent growth in power, versatility, and complexity. The truth is that there are many ways Excel can help make your job easier-beyond calculating sums and averages in a standard spreadsheet.
Analyzing Business Data with Excel shows you how to solve real-world business problems by taking Excel's data analysis features to the max. Rather than focusing on individual Excel functions and features, the book keys directly on the needs of business users. Most of the chapters start with a business problem or question, and then show you how to create pointed spreadsheets that address common data analysis issues.
Aimed primarily at experienced Excel users, the book doesn't spend much time on the basics. After introducing some necessary general tools, it quickly moves into more specific problem areas, such as the following:
- Statistics
- Pivot tables
- Workload forecasting
- Modeling
- Measuring quality
- Monitoring complex systems
- Queuing
- Optimizing
- Importing data
If you feel as though you're getting shortchanged by your overall application of Excel, Analyzing Business Data with Excel is just the antidote. It addresses the growing Excel data analysis market head on. Accountants, managers, analysts, engineers, and supervisors-one and all-will learn how to turn Excel functionality into actual solutions for the business problems that confront them.
L'auteur - Gerald Knight
Gerald Knight has nearly 30 years experience in the computer industry as a developer, teacher, and consultant. During an over twenty-year career at FedEx, he was a project leader and system architect working on imaging and revenue control systems. He has specialized in Excel development for the last ten years. Now retired, he consults and occasionally writes in Memphis, Tennessee.
Sommaire
- Preface
- Excel and Statistics
- Pivot Tables and Problem Solving
- Workload Forecasting
- Modeling
- Measuring Quality
- Monitoring Complex Systems
- Queuing
- Custom Queuing Presentation
- Optimizing
- Importing Data
- The Trouble with Data
- Effective Display Techniques
- Index
Caractéristiques techniques
PAPIER | |
Éditeur(s) | O'Reilly |
Auteur(s) | Gerald Knight |
Collection | Windows Applications/Excel |
Parution | 30/01/2006 |
Nb. de pages | 248 |
Format | 17,5 x 23,5 |
Couverture | Broché |
Poids | 274g |
Intérieur | Noir et Blanc |
EAN13 | 9780596100735 |
ISBN13 | 978-0-596-10073-5 |
Avantages Eyrolles.com
Nos clients ont également acheté
Consultez aussi
- Les meilleures ventes en Graphisme & Photo
- Les meilleures ventes en Informatique
- Les meilleures ventes en Construction
- Les meilleures ventes en Entreprise & Droit
- Les meilleures ventes en Sciences
- Les meilleures ventes en Littérature
- Les meilleures ventes en Arts & Loisirs
- Les meilleures ventes en Vie pratique
- Les meilleures ventes en Voyage et Tourisme
- Les meilleures ventes en BD et Jeunesse
- Informatique Informatique d'entreprise
- Informatique Bureautique Logiciels bureautiques Office
- Informatique Bureautique Logiciels bureautiques Excel
- Entreprise & Droit Marketing et vente Marketing stratégique - Marketing direct
- Entreprise & Droit Marketing et vente Management commercial
- Entreprise & Droit Création d'entreprise