Flylib.com
MicrosoftВ® Office ExcelВ® 2007: Data Analysis and Business Modeling (Bpg -- Other)
MicrosoftВ® Office ExcelВ® 2007: Data Analysis and Business Modeling (Bpg -- Other)
ISBN: 0735623961
EAN: 2147483647
Year: 2007
Pages: 200
Authors:
Wayne L. Winston
BUY ON AMAZON
Table of Contents
Back Cover
Microsoft Office Excel 2007-Data Analysis and Business Modeling
Preface
What You Should Know Before Reading this Book
How to Use this Book
Using the Companion CD
Support Information
Acknowledgments
Introduction to Excel 2007-Whats New?
Chapter 1: Range Names
How Can I Create Named Ranges?
Remarks
Problems
Chapter 2: Lookup Functions
Problems
Chapter 3: The INDEX Function
Problems
Chapter 4: The MATCH Function
Problems
Chapter 5: Text Functions
Text Function Syntax
Text Functions in Action
Extracting Data by Using the Text To Columns Wizard
Problems
Chapter 6: Dates and Date Functions
Problems
Chapter 7: Evaluating Investments by Using Net Present Value Criteria
Problems
Chapter 8: Internal Rate of Return
Problems
Chapter 9: More Excel Financial Functions
CUMPRINC and CUMIPMT Functions
Problems
Chapter 10: Circular References
Problems
Chapter 11: IF Statements
Problems
Chapter 12: Time and Time Functions
Problems
Chapter 13: The Paste Special Command
Problems
Chapter 14: The Auditing Tool
Problems
Chapter 15: Sensitivity Analysis with Data Tables
Problems
Chapter 16: The Goal Seek Command
Problems
Chapter 17: Using the Scenario Manager for Sensitivity Analysis
Remarks
Problems
Chapter 18: The COUNTIF, COUNTIFS, COUNT, COUNTA, and COUNTBLANK Functions
Remarks
Problems
Chapter 19: The SUMIF, AVERAGEIF, SUMIFS, and AVERAGEIFS Functions
Problems
Chapter 20: The OFFSET Function
Remark
Problems
Chapter 21: The INDIRECT Function
Problems
Chapter 22: Conditional Formatting
Problems
Chapter 23: Sorting in Excel
Problems
Chapter 24: Tables
Problems
Chapter 25: Spin Buttons, Scroll Bars, Option Buttons, Check Boxes, Combo Boxes, and Group List Boxes
Spin Buttons and Scroll Bars
Problems
Chapter 26: An Introduction to Optimization with Excel Solver
Problems
Chapter 27: Using Solver to Determine the Optimal Product Mix
Problems
Chapter 28: Using Solver to Schedule Your Workforce
Problems
Chapter 29: Using Solver to Solve Transportation or Distribution Problems
Problems
Chapter 30: Using Solver for Capital Budgeting
Handling Other Constraints
Problems
Chapter 31: Using Solver for Financial Planning
Problems
Chapter 32: Using Solver to Rate Sports Teams
Problems
Chapter 33: Importing Data from a Text File or Document
Problems
Chapter 34: Importing Data from the Internet
Problems
Chapter 35: Validating Data
Remarks
Problems
Chapter 36: Summarizing Data by Using Histograms
Problems
Chapter 37: Summarizing Data by Using Descriptive Statistics
Problems
Chapter 38: Using PivotTables to Describe Data
Remarks About Grouping
Problems
Chapter 39: Summarizing Data with Database Statistical Functions
Problems
Chapter 40: Filtering Data and Removing Duplicates
Problems
Chapter 41: Consolidating Data
Problems
Chapter 42: Creating Subtotals
Problems
Chapter 43: Estimating Straight Line Relationships
Problems
Chapter 44: Modeling Exponential Growth
Problems
Chapter 45: The Power Curve
Problems
Chapter 46: Using Correlations to Summarize Relationships
Problems
Chapter 47: Introduction to Multiple Regression
Chapter 48: Incorporating Qualitative Factors into Multiple Regression
Chapter 49: Modeling Nonlinearities and Interactions
Problems for Chapters 47 Through 49
Chapter 50: Analysis of Variance: One-Way ANOVA
Problems
Chapter 51: Randomized Blocks and Two-Way ANOVA
Problems
Chapter 52: Using Moving Averages to Understand Time Series
Problem
Chapter 53: Winter s Method
Parameter Definitions
Initializing Winters Method
Estimating the Smoothing Constants
Remarks
Problems
Chapter 54: Forecasting in the Presence of Special Events
Problems
Chapter 55: An Introduction to Random Variables
Problems
Chapter 56: The Binomial, Hypergeometric, and Negative Binomial Random Variables
Problems
Chapter 57: The Poisson and Exponential Random Variable
Problems
Chapter 58: The Normal Random Variable
Problems
Chapter 59: Weibull and Beta Distributions: Modeling Machine Life and Duration of a Project
Problems
Chapter 60: Introduction to Monte Carlo Simulation
Problems
Chapter 61: Calculating an Optimal Bid
Problems
Chapter 62: Simulating Stock Prices and Asset Allocation Modeling
Problems
Chapter 63: Fun and Games: Simulating Gambling and Sporting Event Probabilities
Problems
Chapter 64: Using Resampling to Analyze Data
Problems
Chapter 65: Pricing Stock Options
Problems
Chapter 66: Determining Customer Value
Problems
Chapter 67: The Economic Order Quantity Inventory Model
Problems
Chapter 68: Inventory Modeling with Uncertain Demand
Problems
Chapter 69: Queuing Theory-The Mathematics of Waiting in Line
Problems
Chapter 70: Estimating a Demand Curve
Problems
Chapter 71: Pricing Products by Using Tie-Ins
Problems
Chapter 72: Pricing Products by Using Subjectively Determined Demand
Problems
Chapter 73: Nonlinear Pricing
Problems
Chapter 74: Array Formulas and Functions
Problems
Index
B
C
D
E
F
G
H
I
K
L
M
N
O
P
Q
R
S
T
U
V
W
X
Y
List of Figures
List of Tables
MicrosoftВ® Office ExcelВ® 2007: Data Analysis and Business Modeling (Bpg -- Other)
ISBN: 0735623961
EAN: 2147483647
Year: 2007
Pages: 200
Authors:
Wayne L. Winston
BUY ON AMAZON
CompTIA Project+ Study Guide: Exam PK0-003
Answers to Assessment Test
IT Project Management Overview
Schedule Planning
Other Planning Processes
Project Control
Microsoft WSH and VBScript Programming for the Absolute Beginner
Conditional Logic
Processing Collections of Data
Using Procedures to Organize Scripts
Using the Windows Registry to Configure Script Settings
Appendix B Built-In VBScript Functions
InDesign Type: Professional Typography with Adobe InDesign CS2
When to Kern
Manual Kerning
Object Styles
Up Next
Shaping Text Frames
802.11 Wireless Networks: The Definitive Guide, Second Edition
Data Frames
Orthogonal Frequency Division Multiplexing (OFDM)
ERP Physical Layer Convergence (PLCP)
11 on the Macintosh
11 Performance Tuning
Extending and Embedding PHP
Life Cycles
Building Statically
Implementing Classes
Speaking the Windows Dialect
Dealing with Errors
MPLS Configuration on Cisco IOS Software
MPLS Control and Data Plane Components
VPN Categories
Command Reference
Constraint-Based Routing and Operation in MPLS TE
Local Switching
flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net
Privacy policy
This website uses cookies. Click
here
to find out more.
Accept cookies