Analyzing Business Data with Excel

( 2 )

Overview

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 ...

See more details below
Other sellers (Paperback)
  • All (22) from $1.99   
  • New (12) from $10.99   
  • Used (10) from $1.99   
Analyzing Business Data with Excel

Available on NOOK devices and apps  
  • NOOK Devices
  • Samsung Galaxy Tab 4 NOOK
  • NOOK HD/HD+ Tablet
  • NOOK
  • NOOK Color
  • NOOK Tablet
  • Tablet/Phone
  • NOOK for Windows 8 Tablet
  • NOOK for iOS
  • NOOK for Android
  • NOOK Kids for iPad
  • PC/Mac
  • NOOK for Windows 8
  • NOOK for PC
  • NOOK for Mac
  • NOOK for Web

Want a NOOK? Explore Now

NOOK Book (eBook)
$17.99
BN.com price
(Save 43%)$31.99 List Price

Overview

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.

Knight shows professional users in an office environment how to solve business problems using Excel, the most commonly available business software out there.

Read More Show Less

Editorial Reviews

From Barnes & Noble
The Barnes & Noble Review
Excel users don’t care about “features”; they care about solving problems. That’s what Analyzing Business Data with Excel is about: solving real business problems, like measuring quality, employee performance, or even complex business processes. You’ll get comfortable with a raft of important Excel features: array formulas, statistical functions, and PivotTables to name a few. But Gerald Knight stays focused on what you can accomplish with these tools.

You’ll learn how to forecast workloads, then learn more complex modeling techniques based on regression. There’s a full chapter on statistical process control, essential for anyone involved in Six Sigma or similar initiatives. Knight walks through capturing individual performance within complex workflows: for instance, the efficiency of customer service reps. Finally, if you’re sharing your work, you’ll appreciate Knight’s concise overview of building workbooks people can actually understand. Bill Camarda, from the April 2006 Read Only

Read More Show Less

Product Details

  • ISBN-13: 9780596100735
  • Publisher: O'Reilly Media, Incorporated
  • Publication date: 1/1/2006
  • Edition number: 1
  • Pages: 266
  • Product dimensions: 7.00 (w) x 9.19 (h) x 0.65 (d)

Meet the Author

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.

Read More Show Less

Table of Contents

Preface;
Who Should Read This Book;
What's in This Book;
How to Use This Book Effectively;
Sample Code;
Using Code Examples;
We'd Like Your Feedback!;
Safari® Enabled;
Acknowledgments;
Chapter 1: Excel and Statistics;
1.1 Array Formulas;
1.2 Addressing Cells Indirectly;
1.3 Statistical Functions;
Chapter 2: Pivot Tables and Problem Solving;
2.1 Pivot Table Basics;
2.2 Changing the Data;
2.3 Pivot Table Options;
Chapter 3: Workload Forecasting;
3.1 The Procedure;
3.2 Building an Application;
Chapter 4: Modeling;
4.1 Regression;
4.2 Defining the Problem;
4.3 Refining Metrics;
4.4 Analysis;
4.5 Building the Model;
4.6 Analyzing the Results;
4.7 Testing Non-Linear Relationships;
Chapter 5: Measuring Quality;
5.1 Statistical Process Control;
5.2 Running the Application;
5.3 Application Design;
5.4 Customizing the Application;
Chapter 6: Monitoring Complex Systems;
6.1 The Application;
6.2 The Data;
6.3 Settings;
6.4 Workarea;
6.5 Macros;
Chapter 7: Queuing;
7.1 The Data;
7.2 The Application;
7.3 The Logic;
Chapter 8: Custom Queuing Presentation;
8.1 The Application;
8.2 The Data;
8.3 The Logic;
8.4 VBA;
8.5 Extending the Application;
Chapter 9: Optimizing;
9.1 Goal Seek;
9.2 The Solver;
Chapter 10: Importing Data;
10.1 Text Files;
10.2 Databases;
10.3 XML;
Chapter 11: The Trouble with Data;
11.1 Numbers;
11.2 Dates;
11.3 Reports;
11.4 Equivalence;
Chapter 12: Effective Display Techniques;
12.1 Respect the Information and the Audience;
12.2 Large Worksheets;
12.3 Charts;
12.4 Pictures and Other Objects;
12.5 Complexity;
12.6 Repeated Elements;
12.7 Information Density;
12.8 Emphasis and Focus;
Colophon;

Read More Show Less

Customer Reviews

Average Rating 3
( 2 )
Rating Distribution

5 Star

(1)

4 Star

(0)

3 Star

(0)

2 Star

(0)

1 Star

(1)

Your Rating:

Your Name: Create a Pen Name or

Barnes & Noble.com Review Rules

Our reader reviews allow you to share your comments on titles you liked, or didn't, with others. By submitting an online review, you are representing to Barnes & Noble.com that all information contained in your review is original and accurate in all respects, and that the submission of such content by you and the posting of such content by Barnes & Noble.com does not and will not violate the rights of any third party. Please follow the rules below to help ensure that your review can be posted.

Reviews by Our Customers Under the Age of 13

We highly value and respect everyone's opinion concerning the titles we offer. However, we cannot allow persons under the age of 13 to have accounts at BN.com or to post customer reviews. Please see our Terms of Use for more details.

What to exclude from your review:

Please do not write about reviews, commentary, or information posted on the product page. If you see any errors in the information on the product page, please send us an email.

Reviews should not contain any of the following:

  • - HTML tags, profanity, obscenities, vulgarities, or comments that defame anyone
  • - Time-sensitive information such as tour dates, signings, lectures, etc.
  • - Single-word reviews. Other people will read your review to discover why you liked or didn't like the title. Be descriptive.
  • - Comments focusing on the author or that may ruin the ending for others
  • - Phone numbers, addresses, URLs
  • - Pricing and availability information or alternative ordering information
  • - Advertisements or commercial solicitation

Reminder:

  • - By submitting a review, you grant to Barnes & Noble.com and its sublicensees the royalty-free, perpetual, irrevocable right and license to use the review in accordance with the Barnes & Noble.com Terms of Use.
  • - Barnes & Noble.com reserves the right not to post any review -- particularly those that do not follow the terms and conditions of these Rules. Barnes & Noble.com also reserves the right to remove any review at any time without notice.
  • - See Terms of Use for other conditions and disclaimers.
Search for Products You'd Like to Recommend

Recommend other products that relate to your review. Just search for them below and share!

Create a Pen Name

Your Pen Name is your unique identity on BN.com. It will appear on the reviews you write and other website activities. Your Pen Name cannot be edited, changed or deleted once submitted.

 
Your Pen Name can be any combination of alphanumeric characters (plus - and _), and must be at least two characters long.

Continue Anonymously
Sort by: Showing all of 2 Customer Reviews
  • Anonymous

    Posted June 18, 2006

    VERY VERY HIGHLY RECOMMENDED!!

    Are you an experienced Excel user? If you are, then this book is for you! Author Gerald Knight, has done an outstanding job of writing a practical guide that shows you how to solve real-world business problems by taking Excel's data analysis features to the max. Knight, begins by covering averages, trends, correlation, distributions and array formulas. Then, the author examines pivot table basics and ways to modify data to make it work better with pivot tables. Next, he covers the application development process, worksheet organization, and forecasting techniques. The author continues by exploring regression, problem definition, analysis, model construction, and interpretation of results. He also works with statistical process control, X and Y charts, and application design. Knight, then examines data requirements, statistical techniques and logic, application design, and organization. Then, he shows you how to apply formatting, VBA, and logic in an application that measures worker performance in a queuing operation. The author continues the discussion of queuing with another application by focusing on the status of the queue. He also explains how to use Goal Seek and Solver for various kinds of problems. Knight next covers importing from text files, databases, and XML. Then, he examines common problems with dates, numeric information, dealing with data in report form, and equivalence problems. Finally, he covers display design, color combination, dealing with complexity, and visual consideration. This most excellent book keys directly on the needs of business users. More importantly, this book addresses the growing Excel data analysis market head-on.

    0 out of 1 people found this review helpful.

    Was this review helpful? Yes  No   Report this review
  • Anonymous

    Posted September 22, 2009

    No text was provided for this review.

Sort by: Showing all of 2 Customer Reviews

If you find inappropriate content, please report it to Barnes & Noble
Why is this product inappropriate?
Comments (optional)