Microsoft� Office Excel� 2007 Data Analysis and Business Modeling

ISBN-10: 0735623961

ISBN-13: 9780735623965

Edition: 2nd 2007 (Revised)

Authors: Wayne L. Winston

List price: $39.99
30 day, 100% satisfaction guarantee

If an item you ordered from TextbookRush does not meet your expectations due to an error on our part, simply fill out a return request and then return it by mail within 30 days of ordering it for a full refund of item cost.

Learn more about our returns policy

Description:

Master the techniques that business analysts at leading companies use to transform data into bottom-line results. Award-winning educator Wayne Winston shares the best of his classroom experience in this practical, business- focused guide-updated and expanded for Excel 2007. Each chapter advances your data analysis and modeling expertise using real-world examples and learn-by-doing exercises. You'll learn how to create best, worst, and most-likely scenarios for sales, estimate a product's demand curve, forecast using trend and seasonality, and determine which product mix will yield the greatest profit. You'll even discover how to interpret the effects of price and advertising on sales and how to assign a dollar value to customer loyalty. You get all the book's problem-and-solution files on CD-for all the practice you need to solve complex problems and work smarter with Excel.
what's this?
Rush Rewards U
Members Receive:
coins
coins
You have reached 400 XP and carrot coins. That is the daily max!
Study Briefs

Limited time offer: Get the first one free! (?)

All the information you need in one place! Each Study Brief is a summary of one specific subject; facts, figures, and explanations to help you learn faster.

Add to cart
Study Briefs
SQL Online content $4.95 $1.99
Add to cart
Study Briefs
MS Excel® 2010 Online content $4.95 $1.99
Add to cart
Study Briefs
MS Word® 2010 Online content $4.95 $1.99
Add to cart
Study Briefs
MS PowerPoint® 2010 Online content $4.95 $1.99
Customers also bought
Loading
Loading
Loading
Loading
Loading
Loading
Loading
Loading
Loading
Loading

Book details

List price: $39.99
Edition: 2nd
Copyright year: 2007
Publisher: Microsoft Press
Publication date: 5/16/2007
Binding: Mixed Media
Pages: 624
Size: 7.25" wide x 8.75" long x 1.50" tall
Weight: 2.244
Language: English

Wayne L. Winston is a professor of Decision Sciences at Indiana University's Kelley School of Business and the recipient of more than 30 teaching awards. For the past 20 years, Wayne has also taught Fortune 500 companies how to use Excel to make smarter business decisions. He has written 15 books on Excel, management science, and mathematics in sports.

Preface
Introduction to Excel 2007: What's New?
Range Names
Lookup Functions
The INDEX Function
The MATCH Function
Text Functions
Dates and Date Functions
Evaluating Investments by Using Net Present Value Criteria
Internal Rate of Return
More Excel Financial Functions
Circular References
IF Statements
Time and Time Functions
The Paste Special Command
The Auditing Tool
Sensitivity Analysis with Data Tables
The Goal Seek Command
Using the Scenario Manager for Sensitivity Analysis
The COUNTIF, COUNTIFS, COUNT, COUNTA, and COUNTBLANK Functions
The SUMIF, AVERAGEIF, SUMIFS, and AVERAGEIFS Functions
The OFFSET Function
The INDIRECT Function
Conditional Formatting
Sorting in Excel
Tables
Spin Buttons, Scroll Bars, Option Buttons, Check Boxes, Combo Boxes, and Group List Boxes
An Introduction to Optimization with Excel Solver
Using Solver to Determine the Optimal Product Mix
Using Solver to Schedule Your Workforce
Using Solver to Solve Transportation or Distribution Problems
Using Solver for Capital Budgeting
Using Solver for Financial Planning
Using Solver to Rate Sports Teams
Importing Data from a Text File or Document
Importing Data from the Internet
Validating Data
Summarizing Data by Using Histograms
Summarizing Data by Using Descriptive Statistics
Using PivotTables to Describe Data
Summarizing Data with Database Statistical Functions
Filtering Data and Removing Duplicates
Consolidating Data
Creating Subtotals
Estimating Straight Line Relationships
Modeling Exponential Growth
The Power Curve
Using Correlations to Summarize Relationships
Introduction to Multiple Regression
Incorporating Qualitative Factors into Multiple Regression
Modeling Nonlinearities and Interactions
Analysis of Variance: One-Way ANOVA
Randomized Blocks and Two-Way ANOVA
Using Moving Averages to Understand Time Series
Winter's Method
Forecasting in the Presence of Special Events
An Introduction to Random Variables
The Binomial, Hypergeometric, and Negative Binomial Random Variables
The Poisson and Exponential Random Variable
The Normal Random Variable
Weibull and Beta Distributions: Modeling Machine Life and Duration of a Project
Introduction to Monte Carlo Simulation
Calculating an Optimal Bid
Simulating Stock Prices and Asset Allocation Modeling
Fun and Games: Simulating Gambling and Sporting Event Probabilities
Using Resampling to Analyze Data
Pricing Stock Options
Determining Customer Value
The Economic Order Quantity Inventory Model
Inventory Modeling with Uncertain Demand
Queuing Theory: The Mathematics of Waiting in Line
Estimating a Demand Curve
Pricing Products by Using Tie-Ins
Pricing Products by Using Subjectively Determined Demand
Nonlinear Pricing
Array Formulas and Functions
About the Author
×
Free shipping on orders over $35*

*A minimum purchase of $35 is required. Shipping is provided via FedEx SmartPost® and FedEx Express Saver®. Average delivery time is 1 – 5 business days, but is not guaranteed in that timeframe. Also allow 1 - 2 days for processing. Free shipping is eligible only in the continental United States and excludes Hawaii, Alaska and Puerto Rico. FedEx service marks used by permission."Marketplace" orders are not eligible for free or discounted shipping.

Learn more about the TextbookRush Marketplace.

×