Microsoft excel 2019 data analysis and business modeling / (Record no. 465)
[ view plain ]
| 000 -LEADER | |
|---|---|
| fixed length control field | 04955nam a22003255i 4500 |
| 001 - CONTROL NUMBER | |
| control field | 20842589 |
| 003 - CONTROL NUMBER IDENTIFIER | |
| control field | Urbe University |
| 005 - DATE AND TIME OF LATEST TRANSACTION | |
| control field | 20220707161914.0 |
| 008 - FIXED-LENGTH DATA ELEMENTS--GENERAL INFORMATION | |
| fixed length control field | 190206s2019 cau 000 0 eng |
| 010 ## - LIBRARY OF CONGRESS CONTROL NUMBER | |
| LC control number | 2019933467 |
| 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 | DLC |
| Language of cataloging | eng |
| Description conventions | rda |
| Transcribing agency | DLC |
| 042 ## - AUTHENTICATION CODE | |
| Authentication code | pcc |
| 050 ## - LIBRARY OF CONGRESS CALL NUMBER | |
| Classification number | HF5548.4.M523 |
| Item number | W567 2019 |
| 100 1# - MAIN ENTRY--PERSONAL NAME | |
| Personal name | Winston, Wayne. |
| 245 10 - TITLE STATEMENT | |
| Title | Microsoft excel 2019 data analysis and business modeling / |
| Statement of responsibility, etc | Wayne Winston. |
| 250 ## - EDITION STATEMENT | |
| Edition statement | 6th edition. |
| 260 ## - PUBLICATION, DISTRIBUTION, ETC. (IMPRINT) | |
| Place of publication, distribution, etc | Canadá, |
| Name of publisher, distributor, etc | Pearson Education |
| Date of publication, distribution, etc | 2019 |
| 263 ## - PROJECTED PUBLICATION DATE | |
| Projected publication date | 1904 |
| 300 ## - PHYSICAL DESCRIPTION | |
| Extent | xxvii, 850 pages |
| Other physical details | : illustrations ; |
| 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 -- 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 -- 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 variable 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 determined 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.<br/><br/> |
| 650 #4 - SUBJECT ADDED ENTRY--TOPICAL TERM | |
| Topical term or geographic name as entry element | Microsoft Excel |
| 650 #4 - SUBJECT ADDED ENTRY--TOPICAL TERM | |
| Topical term or geographic name as entry element | Business - Computer Programs |
| 906 ## - LOCAL DATA ELEMENT F, LDF (RLIN) | |
| a | 0 |
| b | ibc |
| c | orignew |
| d | 2 |
| e | epcn |
| f | 20 |
| g | y-gencatlg |
| 942 ## - ADDED ENTRY ELEMENTS (KOHA) | |
| Source of classification or shelving scheme | Library of Congress Classification |
| Koha item type | Books |
| Withdrawn status | Lost status | Source of classification or shelving scheme | Damaged status | Not for loan | Collection code | Home library | Current library | Shelving location | Date acquired | Source of acquisition | Total Checkouts | Full call number | Barcode | Date last seen | Price effective from | Koha item type |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Library of Congress Classification | Non-fiction | URBE Library | URBE Library | General Stacks | 07/07/2022 | DONATION | HF5548.4.M523 W567 2019 | 0874 | 07/07/2022 | 07/07/2022 | Books |