MARC details
| 000 -LEADER |
|---|
| fixed length control field |
04746nam a22003137a 4500 |
| 003 - CONTROL NUMBER IDENTIFIER |
|---|
| control field |
ZW-GwMSU |
| 005 - DATE AND TIME OF LATEST TRANSACTION |
|---|
| control field |
20240730124816.0 |
| 008 - FIXED-LENGTH DATA ELEMENTS--GENERAL INFORMATION |
|---|
| fixed length control field |
240726b |||||||| |||| 00| 0 eng d |
| 020 ## - INTERNATIONAL STANDARD BOOK NUMBER |
|---|
| International Standard Book Number |
9781509305889 (alk. paper) |
| 020 ## - INTERNATIONAL STANDARD BOOK NUMBER |
|---|
| International Standard Book Number |
9781509306077 |
| 020 ## - INTERNATIONAL STANDARD BOOK NUMBER |
|---|
| International Standard Book Number |
9781509306084 |
| 040 ## - CATALOGING SOURCE |
|---|
| Original cataloging agency |
rda |
| Language of cataloging |
English |
| Description conventions |
rda |
| Transcribing agency |
MSULIB |
| 050 ## - LIBRARY OF CONGRESS CALL NUMBER |
|---|
| Classification number |
HF5548.4.M523 WIN |
| 100 1# - MAIN ENTRY--PERSONAL NAME |
|---|
| Personal name |
Winston, Wayne. |
| Relator term |
author |
| 245 10 - TITLE STATEMENT |
|---|
| Title |
Microsoft excel 2019 data analysis and business modeling / |
| Statement of responsibility, etc |
created by Wayne Winston. |
| 250 ## - EDITION STATEMENT |
|---|
| Edition statement |
6th edition. |
| 264 #1 - PRODUCTION, PUBLICATION, DISTRIBUTION, MANUFACTURE, AND COPYRIGHT NOTICE |
|---|
| Name of producer, publisher, distributor, manufacturer |
Microsoft Press, |
| Date of production, publication, distribution, manufacture, or copyright notice |
2019. |
| 300 ## - PHYSICAL DESCRIPTION |
|---|
| Extent |
xvii, 850 pages: |
| Other physical details |
illustrations; |
| Dimensions |
26 cm |
| 336 ## - CONTENT TYPE |
|---|
| content type term |
text |
| Source |
rdacontent |
| 337 ## - MEDIA TYPE |
|---|
| media type term |
unmediated |
| media type code |
n |
| source |
rdamedia |
| 338 ## - CARRIER TYPE |
|---|
| carrier type term |
volume |
| carrier type code |
nc |
| source |
rdacarrier |
| 504 ## - BIBLIOGRAPHY, ETC. NOTE |
|---|
| Bibliography, etc |
Includes bibliography and index |
| 505 ## - FORMATTED CONTENTS NOTE |
|---|
| Formatted contents note |
Basic worksheet modeling Range names Lookup functions The INDEX function The MATCH function Text functions and Flash Fill Dates and date functions NPV and XNPV functions IRR, XIRR, and MIRR functions More Excel financial functions Circular references IF, IFERROR, IFS, CHOOSE, and SWITCH functions Time and time functions The Paste Special command Three-dimensional formulas and hyperlinks The auding tool and the Inquire add-in 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, AVERAGEIFS, MAXIFS, and MINIFS functions The OFFSET function The INDIRECT function Conditional formatting Sorting in Excel Excel Tables and table slicers Spin buttons, scrollbars, option buttons, check boxes, combo boxes, and group list boxes The analytics revolution 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 Warehouse location and the GRG Multistart and Evolutionary Solver engines Penalties and the Evolutionary Solver The traveling salesperson problem Importing data from a text file or document Get & Transform Geography and Stock data types Validating data Summarizing data by using histograms and Pareto charts Summarizing data by using descriptive statistics Using pivot tables and slicers to describe data The Data Model Power Pivot Filled and 3D Power Maps Sparklines Summarizing data with database statistical functions Filtering data and removing duplicates Consolidating data Creating subtotals Charting tricks Estimating straight-line relationships Modeling exponential growth The power curve using correlations to summarize relationships Introduction to multiple regression Incorprating 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 Winters method and the Forecast Sheet Ratio-to-moving-average forecast method Forecasting in the presence of special events An introduction to probability An introduction to random variables The binomial, hypergeometric, and negative binomial random variables The Poisson and exponential random variable The normal random variable and Z-scores Weibull and beta distributions: Modeling machine life and duration of a project Making probability statements from forecasts Using the lognormal random variaable to model stock prices Importing historical stock data into Excel 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 determinded demand Nonlinear pricing Array formulas and functions Recording macros Advanced sensitivity analysis |
| 520 ## - SUMMARY, ETC. |
|---|
| Summary, etc |
Master business modeling and analysis techniques with Microsoft Excel 2019, and transform data into bottom-line results. Written by award-winning educator Wayne Winston, this hands-on, scenario-focused guide shows you how to use the latest Excel tools to integrate data from multiple tables–and how to effectively build a relational data source inside an Excel workbook. |
| 650 #0 - SUBJECT ADDED ENTRY--TOPICAL TERM |
|---|
| Topical term or geographic name as entry element |
Business |
| General subdivision |
Computer programs |
| 650 #0 - SUBJECT ADDED ENTRY--TOPICAL TERM |
|---|
| Topical term or geographic name as entry element |
Decision making |
| General subdivision |
Computer programs |
| 650 #0 - SUBJECT ADDED ENTRY--TOPICAL TERM |
|---|
| Topical term or geographic name as entry element |
Electronic spreadsheets |
| 942 ## - ADDED ENTRY ELEMENTS (KOHA) |
|---|
| Source of classification or shelving scheme |
Library of Congress Classification |
| Koha item type |
Book |