Book description
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.
Publisher resources
Table of contents
- A Note Regarding Supplemental Files
- Preface
- 1. Excel and Statistics
- 2. Pivot Tables and Problem Solving
-
3. Workload Forecasting
- 3.1. The Procedure
-
3.2. Building an Application
- 3.2.1. Design
- 3.2.2. List the Requirements
- 3.2.3. Consider the Source of Data
- 3.2.4. Presentation
- 3.2.5. Conventions and Names
- 3.2.6. Named Values and Ranges on Settings
- 3.2.7. The Named Values on the Workarea Sheet
- 3.2.8. Named Ranges on Workarea
- 3.2.9. Other Important Links on Workarea
- 3.2.10. Linking to the Data
- 3.2.11. Visual Basic
- 3.2.12. Formatting
- 3.2.13. Running the Application
- 3.2.14. Customizing the Application
- 4. Modeling
- 5. Measuring Quality
- 6. Monitoring Complex Systems
- 7. Queuing
- 8. Custom Queuing Presentation
- 9. Optimizing
- 10. Importing Data
- 11. The Trouble with Data
- 12. Effective Display Techniques
- Index
- About the Author
- Colophon
- Copyright
Product information
- Title: Analyzing Business Data with Excel
- Author(s):
- Release date: January 2006
- Publisher(s): O'Reilly Media, Inc.
- ISBN: 9780596100735
You might also like
book
Microsoft Excel Functions Quick Reference: For High-Quality Data Analysis, Dashboards, and More
This condensed syntax reference presents the essential Excel function syntax in a well-organized format that can …
book
Business Case Analysis with R: Simulation Tutorials to Support Complex Business Decisions
This tutorial teaches you how to use the statistical programming language R to develop a business …
book
A PRACTITIONER'S GUIDE TO BUSINESS ANALYTICS: Using Data Analysis Tools to Improve Your Organization’s Decision Making and Strategy
Gain the competitive edge with the smart use of business analytics In today’s volatile business environment, …
book
Advanced Excel Success: A Practical Guide to Mastering Excel
Explore advanced skills in Excel and gain an amazing array of tricks and tools to increase …