Microsoft Excel 2010: data analysis and business modeling
Saved in:
| Main Author: | |
|---|---|
| Format: | Book |
| Language: | English |
| Published: |
Redmond, Wash.
Microsoft Press
c2011
|
| Subjects: | |
| Online Access: | Inhaltsverzeichnis |
| Item Description: | Includes index. |
| Physical Description: | XV, 700 S. Ill. 23 cm |
| ISBN: | 9780735643369 |
Staff View
MARC
| LEADER | 00000nam a2200000zc 4500 | ||
|---|---|---|---|
| 001 | BV040294590 | ||
| 003 | DE-604 | ||
| 005 | 00000000000000.0 | ||
| 007 | t | ||
| 008 | 120705s2011 xxua||| |||| 00||| eng d | ||
| 010 | |a 2010934987 | ||
| 015 | |a GBB095385 |2 dnb | ||
| 020 | |a 9780735643369 |c pbk. |9 978-0-7356-4336-9 | ||
| 035 | |a (OCoLC)802571077 | ||
| 035 | |a (DE-599)BVBBV040294590 | ||
| 040 | |a DE-604 |b ger |e aacr | ||
| 041 | 0 | |a eng | |
| 044 | |a xxu |c US | ||
| 050 | 0 | |a HD30.215 | |
| 082 | 0 | |a 005.54 | |
| 082 | 0 | |a 658.40300285554 | |
| 084 | |a ST 371 |0 (DE-625)143672: |2 rvk | ||
| 100 | 1 | |a Winston, Wayne L. |d 1950- |e Verfasser |0 (DE-588)134241614 |4 aut | |
| 245 | 1 | 0 | |a Microsoft Excel 2010 |b data analysis and business modeling |c Wayne L. Winston |
| 264 | 1 | |a Redmond, Wash. |b Microsoft Press |c c2011 | |
| 300 | |a XV, 700 S. |b Ill. |c 23 cm | ||
| 336 | |b txt |2 rdacontent | ||
| 337 | |b n |2 rdamedia | ||
| 338 | |b nc |2 rdacarrier | ||
| 500 | |a Includes index. | ||
| 630 | 0 | 4 | |a Microsoft Excel (Computer file) |
| 650 | 4 | |a Industrial management |x Statistical methods |x Computer programs | |
| 650 | 4 | |a Decision making |x Computer programs | |
| 856 | 4 | 2 | |m LoC Fremddatenuebernahme |q application/pdf |u http://bvbr.bib-bvb.de:8991/F?func=service&doc_library=BVB01&local_base=BVB01&doc_number=025149708&sequence=000001&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA |3 Inhaltsverzeichnis |
| 999 | |a oai:aleph.bib-bvb.de:BVB01-025149708 | ||
Record in the Search Index
| _version_ | 1804149309629792256 |
|---|---|
| adam_text | MICROSOFT EXCEL 2010
/ WINSTON, WAYNE L.
: C2011
TABLE OF CONTENTS / INHALTSVERZEICHNIS
WHAT S NEW IN EXCEL 2010
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
THREE-DIMENSIONAL FORMULAS
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
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
IMPORTING DATA FROM THE INTERNET
VALIDATING DATA
SUMMARIZING DATA BY USING HISTOGRAMS
SUMMARIZING DATA BY USING DESCRIPTIVE STATISTICS
USING PIVOTTABLES AND SLICERS TO DESCRIBE DATA
SPARKLINES
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
WINTERS S METHOD
RATIO-TO-MOVING-AVERAGE FORECAST 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
MAKING PROBABILITY STATEMENTS FROM FORECASTS
USING THE LOGNORMAL RANDOM VARIABLE TO MODEL STOCK PRICES
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
POWERPIVOT.
DIESES SCHRIFTSTUECK WURDE MASCHINELL ERZEUGT.
|
| any_adam_object | 1 |
| author | Winston, Wayne L. 1950- |
| author_GND | (DE-588)134241614 |
| author_facet | Winston, Wayne L. 1950- |
| author_role | aut |
| author_sort | Winston, Wayne L. 1950- |
| author_variant | w l w wl wlw |
| building | Verbundindex |
| bvnumber | BV040294590 |
| callnumber-first | H - Social Science |
| callnumber-label | HD30 |
| callnumber-raw | HD30.215 |
| callnumber-search | HD30.215 |
| callnumber-sort | HD 230.215 |
| callnumber-subject | HD - Industries, Land Use, Labor |
| classification_rvk | ST 371 |
| ctrlnum | (OCoLC)802571077 (DE-599)BVBBV040294590 |
| dewey-full | 005.54 658.40300285554 |
| dewey-hundreds | 000 - Computer science, information, general works 600 - Technology (Applied sciences) |
| dewey-ones | 005 - Computer programming, programs, data, security 658 - General management |
| dewey-raw | 005.54 658.40300285554 |
| dewey-search | 005.54 658.40300285554 |
| dewey-sort | 15.54 |
| dewey-tens | 000 - Computer science, information, general works 650 - Management and auxiliary services |
| discipline | Informatik Wirtschaftswissenschaften |
| format | Book |
| fullrecord | <?xml version="1.0" encoding="UTF-8"?><collection xmlns="http://www.loc.gov/MARC21/slim"><record><leader>01420nam a2200385zc 4500</leader><controlfield tag="001">BV040294590</controlfield><controlfield tag="003">DE-604</controlfield><controlfield tag="005">00000000000000.0</controlfield><controlfield tag="007">t</controlfield><controlfield tag="008">120705s2011 xxua||| |||| 00||| eng d</controlfield><datafield tag="010" ind1=" " ind2=" "><subfield code="a">2010934987</subfield></datafield><datafield tag="015" ind1=" " ind2=" "><subfield code="a">GBB095385</subfield><subfield code="2">dnb</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">9780735643369</subfield><subfield code="c">pbk.</subfield><subfield code="9">978-0-7356-4336-9</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(OCoLC)802571077</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(DE-599)BVBBV040294590</subfield></datafield><datafield tag="040" ind1=" " ind2=" "><subfield code="a">DE-604</subfield><subfield code="b">ger</subfield><subfield code="e">aacr</subfield></datafield><datafield tag="041" ind1="0" ind2=" "><subfield code="a">eng</subfield></datafield><datafield tag="044" ind1=" " ind2=" "><subfield code="a">xxu</subfield><subfield code="c">US</subfield></datafield><datafield tag="050" ind1=" " ind2="0"><subfield code="a">HD30.215</subfield></datafield><datafield tag="082" ind1="0" ind2=" "><subfield code="a">005.54</subfield></datafield><datafield tag="082" ind1="0" ind2=" "><subfield code="a">658.40300285554</subfield></datafield><datafield tag="084" ind1=" " ind2=" "><subfield code="a">ST 371</subfield><subfield code="0">(DE-625)143672:</subfield><subfield code="2">rvk</subfield></datafield><datafield tag="100" ind1="1" ind2=" "><subfield code="a">Winston, Wayne L.</subfield><subfield code="d">1950-</subfield><subfield code="e">Verfasser</subfield><subfield code="0">(DE-588)134241614</subfield><subfield code="4">aut</subfield></datafield><datafield tag="245" ind1="1" ind2="0"><subfield code="a">Microsoft Excel 2010</subfield><subfield code="b">data analysis and business modeling</subfield><subfield code="c">Wayne L. Winston</subfield></datafield><datafield tag="264" ind1=" " ind2="1"><subfield code="a">Redmond, Wash.</subfield><subfield code="b">Microsoft Press</subfield><subfield code="c">c2011</subfield></datafield><datafield tag="300" ind1=" " ind2=" "><subfield code="a">XV, 700 S.</subfield><subfield code="b">Ill.</subfield><subfield code="c">23 cm</subfield></datafield><datafield tag="336" ind1=" " ind2=" "><subfield code="b">txt</subfield><subfield code="2">rdacontent</subfield></datafield><datafield tag="337" ind1=" " ind2=" "><subfield code="b">n</subfield><subfield code="2">rdamedia</subfield></datafield><datafield tag="338" ind1=" " ind2=" "><subfield code="b">nc</subfield><subfield code="2">rdacarrier</subfield></datafield><datafield tag="500" ind1=" " ind2=" "><subfield code="a">Includes index.</subfield></datafield><datafield tag="630" ind1="0" ind2="4"><subfield code="a">Microsoft Excel (Computer file)</subfield></datafield><datafield tag="650" ind1=" " ind2="4"><subfield code="a">Industrial management</subfield><subfield code="x">Statistical methods</subfield><subfield code="x">Computer programs</subfield></datafield><datafield tag="650" ind1=" " ind2="4"><subfield code="a">Decision making</subfield><subfield code="x">Computer programs</subfield></datafield><datafield tag="856" ind1="4" ind2="2"><subfield code="m">LoC Fremddatenuebernahme</subfield><subfield code="q">application/pdf</subfield><subfield code="u">http://bvbr.bib-bvb.de:8991/F?func=service&doc_library=BVB01&local_base=BVB01&doc_number=025149708&sequence=000001&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA</subfield><subfield code="3">Inhaltsverzeichnis</subfield></datafield><datafield tag="999" ind1=" " ind2=" "><subfield code="a">oai:aleph.bib-bvb.de:BVB01-025149708</subfield></datafield></record></collection> |
| id | DE-604.BV040294590 |
| illustrated | Illustrated |
| indexdate | 2024-07-10T00:20:59Z |
| institution | BVB |
| isbn | 9780735643369 |
| language | English |
| lccn | 2010934987 |
| oai_aleph_id | oai:aleph.bib-bvb.de:BVB01-025149708 |
| oclc_num | 802571077 |
| open_access_boolean | |
| physical | XV, 700 S. Ill. 23 cm |
| publishDate | 2011 |
| publishDateSearch | 2011 |
| publishDateSort | 2011 |
| publisher | Microsoft Press |
| record_format | marc |
| spelling | Winston, Wayne L. 1950- Verfasser (DE-588)134241614 aut Microsoft Excel 2010 data analysis and business modeling Wayne L. Winston Redmond, Wash. Microsoft Press c2011 XV, 700 S. Ill. 23 cm txt rdacontent n rdamedia nc rdacarrier Includes index. Microsoft Excel (Computer file) Industrial management Statistical methods Computer programs Decision making Computer programs LoC Fremddatenuebernahme application/pdf http://bvbr.bib-bvb.de:8991/F?func=service&doc_library=BVB01&local_base=BVB01&doc_number=025149708&sequence=000001&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA Inhaltsverzeichnis |
| spellingShingle | Winston, Wayne L. 1950- Microsoft Excel 2010 data analysis and business modeling Microsoft Excel (Computer file) Industrial management Statistical methods Computer programs Decision making Computer programs |
| title | Microsoft Excel 2010 data analysis and business modeling |
| title_auth | Microsoft Excel 2010 data analysis and business modeling |
| title_exact_search | Microsoft Excel 2010 data analysis and business modeling |
| title_full | Microsoft Excel 2010 data analysis and business modeling Wayne L. Winston |
| title_fullStr | Microsoft Excel 2010 data analysis and business modeling Wayne L. Winston |
| title_full_unstemmed | Microsoft Excel 2010 data analysis and business modeling Wayne L. Winston |
| title_short | Microsoft Excel 2010 |
| title_sort | microsoft excel 2010 data analysis and business modeling |
| title_sub | data analysis and business modeling |
| topic | Microsoft Excel (Computer file) Industrial management Statistical methods Computer programs Decision making Computer programs |
| topic_facet | Microsoft Excel (Computer file) Industrial management Statistical methods Computer programs Decision making Computer programs |
| url | http://bvbr.bib-bvb.de:8991/F?func=service&doc_library=BVB01&local_base=BVB01&doc_number=025149708&sequence=000001&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA |
| work_keys_str_mv | AT winstonwaynel microsoftexcel2010dataanalysisandbusinessmodeling |