Next generation excel: modeling in excel for analysts and MBAs
Gespeichert in:
| 1. Verfasser: | |
|---|---|
| Format: | Buch |
| Sprache: | English |
| Veröffentlicht: |
Singapore
Wiley
2010
|
| Schlagworte: | |
| Online-Zugang: | Inhaltsverzeichnis |
| Beschreibung: | XVI, 294 S. Ill., graph. Darst. 1 CD-ROM (12 cm) |
| ISBN: | 9780470824733 |
Internformat
MARC
| LEADER | 00000nam a2200000 c 4500 | ||
|---|---|---|---|
| 001 | BV036555065 | ||
| 003 | DE-604 | ||
| 005 | 20100727 | ||
| 007 | t | ||
| 008 | 100708s2010 ad|| |||| 00||| eng d | ||
| 020 | |a 9780470824733 |9 978-0-470-82473-3 | ||
| 035 | |a (OCoLC)700522502 | ||
| 035 | |a (DE-599)HBZHT016378496 | ||
| 040 | |a DE-604 |b ger |e rakwb | ||
| 041 | 0 | |a eng | |
| 049 | |a DE-945 | ||
| 084 | |a ST 371 |0 (DE-625)143672: |2 rvk | ||
| 100 | 1 | |a Gottlieb, Isaac |e Verfasser |4 aut | |
| 245 | 1 | 0 | |a Next generation excel |b modeling in excel for analysts and MBAs |c Isaac Gottlieb |
| 264 | 1 | |a Singapore |b Wiley |c 2010 | |
| 300 | |a XVI, 294 S. |b Ill., graph. Darst. |e 1 CD-ROM (12 cm) | ||
| 336 | |b txt |2 rdacontent | ||
| 337 | |b n |2 rdamedia | ||
| 338 | |b nc |2 rdacarrier | ||
| 650 | 0 | 7 | |a Finanzanalyse |0 (DE-588)4133000-6 |2 gnd |9 rswk-swf |
| 650 | 0 | 7 | |a EXCEL |0 (DE-588)4138932-3 |2 gnd |9 rswk-swf |
| 689 | 0 | 0 | |a Finanzanalyse |0 (DE-588)4133000-6 |D s |
| 689 | 0 | 1 | |a EXCEL |0 (DE-588)4138932-3 |D s |
| 689 | 0 | |C b |5 DE-604 | |
| 856 | 4 | 2 | |m HBZ Datenaustausch |q application/pdf |u http://bvbr.bib-bvb.de:8991/F?func=service&doc_library=BVB01&local_base=BVB01&doc_number=020476523&sequence=000002&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA |3 Inhaltsverzeichnis |
| 999 | |a oai:aleph.bib-bvb.de:BVB01-020476523 | ||
Datensatz im Suchindex
| _version_ | 1804143129307119616 |
|---|---|
| adam_text | Titel: Next generation excel
Autor: Gottlieb, Isaac
Jahr: 2010
Contents
A Word from the Author xi
Acknowledgments xiii
Introduction and Overview xv
PART ONE
Using Excel Efficiently 1
CHAPTER 1
AutoFill 3
CHAPTER 2
Selecting Efficiently In Excel 14
CHAPTER 3
Formulas, Functions, Relative and Absolute Addressing 19
CHAPTER 4
Naming Cells and Ranges 28
CHAPTER 5
Excel Charts 38
PART TWO
IF Functions and Text Manipulations 63
CHAPTER 6
IF Functions 65
CHAPTER 7
Text Manipulation 72
VII
yjjj______________________________________________________________________ Contents
PART TWEE
Statistical Tools 83
CHAPTER 8
Descriptive Statistics 85
CHAPTER 9
Frequency Distributions 90
CHAPTER 10
Statistical Regression 100
CHAPTER 11
Data Analysis?The Excel Easy to Use Statistics Add-in 109
PART FOUR
What-if Analysis 113
CHAPTER 12
Naming Ceis?for Meaningful Decision Making and Modeling 121
CHAPTER 13
What-rt Analysis and Goal Seek 129
CHAPTER 14
Sensitivity Analysis?One- and Two-way Data Tables 138
CHAPTER 15
Using Scroll Bars for Sensitivity Analysis 149
PART FIVE
Multi-Page Systems and Lookups 159
CHAPTER 16
Multi-Page Budgets?-Gohig to the Third Dimension 161
CHAPTER 17
Lookup Tables 170
Contents______________________________________________________________________________________jx
PART SIX
The Data Menu and Ribbon 179
CHAPTER 18
Sorting Data 181
CHAPTER 19
AntoHlter 190
CHAPTER 20
Data Forms and Features Eliminated hi Excel 2007 198
CHAPTER 21
Group and Outline Data 204
CHAPTER 22
Subtotals 209
CHAPTER 23
Pivot Tables 219
CHAPTER 24
Data Mining Using Pivot Tables 229
PABTSEVflB
Excel Financial Tools 241
CHAPTER 25
NPV and HUt?Evaluating Capital Divestments 243
CHAPTER 28
Unconventional Financial Functions: XNPV and XRR 249
CHAPTER 27
Frequently Used Financial Functions 253
CHAPTER 28
Amortization Tables 258
CHAPTER 29
Accounting Depreciation Functions 288
X_______________________________________________________________________________Contents
PARTBGHT
Using the Solver Add-In 271
CHAPTffi 30
Beyond the Goal Seek?Atone than One Changing Cell?
Use the Solver 273
CHAPIOl 31
The Solver Add-In?Optimizer 282
Index 291
|
| any_adam_object | 1 |
| author | Gottlieb, Isaac |
| author_facet | Gottlieb, Isaac |
| author_role | aut |
| author_sort | Gottlieb, Isaac |
| author_variant | i g ig |
| building | Verbundindex |
| bvnumber | BV036555065 |
| classification_rvk | ST 371 |
| ctrlnum | (OCoLC)700522502 (DE-599)HBZHT016378496 |
| discipline | Informatik |
| format | Book |
| fullrecord | <?xml version="1.0" encoding="UTF-8"?><collection xmlns="http://www.loc.gov/MARC21/slim"><record><leader>01289nam a2200337 c 4500</leader><controlfield tag="001">BV036555065</controlfield><controlfield tag="003">DE-604</controlfield><controlfield tag="005">20100727 </controlfield><controlfield tag="007">t</controlfield><controlfield tag="008">100708s2010 ad|| |||| 00||| eng d</controlfield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">9780470824733</subfield><subfield code="9">978-0-470-82473-3</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(OCoLC)700522502</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(DE-599)HBZHT016378496</subfield></datafield><datafield tag="040" ind1=" " ind2=" "><subfield code="a">DE-604</subfield><subfield code="b">ger</subfield><subfield code="e">rakwb</subfield></datafield><datafield tag="041" ind1="0" ind2=" "><subfield code="a">eng</subfield></datafield><datafield tag="049" ind1=" " ind2=" "><subfield code="a">DE-945</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">Gottlieb, Isaac</subfield><subfield code="e">Verfasser</subfield><subfield code="4">aut</subfield></datafield><datafield tag="245" ind1="1" ind2="0"><subfield code="a">Next generation excel</subfield><subfield code="b">modeling in excel for analysts and MBAs</subfield><subfield code="c">Isaac Gottlieb</subfield></datafield><datafield tag="264" ind1=" " ind2="1"><subfield code="a">Singapore</subfield><subfield code="b">Wiley</subfield><subfield code="c">2010</subfield></datafield><datafield tag="300" ind1=" " ind2=" "><subfield code="a">XVI, 294 S.</subfield><subfield code="b">Ill., graph. Darst.</subfield><subfield code="e">1 CD-ROM (12 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="650" ind1="0" ind2="7"><subfield code="a">Finanzanalyse</subfield><subfield code="0">(DE-588)4133000-6</subfield><subfield code="2">gnd</subfield><subfield code="9">rswk-swf</subfield></datafield><datafield tag="650" ind1="0" ind2="7"><subfield code="a">EXCEL</subfield><subfield code="0">(DE-588)4138932-3</subfield><subfield code="2">gnd</subfield><subfield code="9">rswk-swf</subfield></datafield><datafield tag="689" ind1="0" ind2="0"><subfield code="a">Finanzanalyse</subfield><subfield code="0">(DE-588)4133000-6</subfield><subfield code="D">s</subfield></datafield><datafield tag="689" ind1="0" ind2="1"><subfield code="a">EXCEL</subfield><subfield code="0">(DE-588)4138932-3</subfield><subfield code="D">s</subfield></datafield><datafield tag="689" ind1="0" ind2=" "><subfield code="C">b</subfield><subfield code="5">DE-604</subfield></datafield><datafield tag="856" ind1="4" ind2="2"><subfield code="m">HBZ Datenaustausch</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=020476523&sequence=000002&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-020476523</subfield></datafield></record></collection> |
| id | DE-604.BV036555065 |
| illustrated | Illustrated |
| indexdate | 2024-07-09T22:42:45Z |
| institution | BVB |
| isbn | 9780470824733 |
| language | English |
| oai_aleph_id | oai:aleph.bib-bvb.de:BVB01-020476523 |
| oclc_num | 700522502 |
| open_access_boolean | |
| owner | DE-945 |
| owner_facet | DE-945 |
| physical | XVI, 294 S. Ill., graph. Darst. 1 CD-ROM (12 cm) |
| publishDate | 2010 |
| publishDateSearch | 2010 |
| publishDateSort | 2010 |
| publisher | Wiley |
| record_format | marc |
| spelling | Gottlieb, Isaac Verfasser aut Next generation excel modeling in excel for analysts and MBAs Isaac Gottlieb Singapore Wiley 2010 XVI, 294 S. Ill., graph. Darst. 1 CD-ROM (12 cm) txt rdacontent n rdamedia nc rdacarrier Finanzanalyse (DE-588)4133000-6 gnd rswk-swf EXCEL (DE-588)4138932-3 gnd rswk-swf Finanzanalyse (DE-588)4133000-6 s EXCEL (DE-588)4138932-3 s b DE-604 HBZ Datenaustausch application/pdf http://bvbr.bib-bvb.de:8991/F?func=service&doc_library=BVB01&local_base=BVB01&doc_number=020476523&sequence=000002&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA Inhaltsverzeichnis |
| spellingShingle | Gottlieb, Isaac Next generation excel modeling in excel for analysts and MBAs Finanzanalyse (DE-588)4133000-6 gnd EXCEL (DE-588)4138932-3 gnd |
| subject_GND | (DE-588)4133000-6 (DE-588)4138932-3 |
| title | Next generation excel modeling in excel for analysts and MBAs |
| title_auth | Next generation excel modeling in excel for analysts and MBAs |
| title_exact_search | Next generation excel modeling in excel for analysts and MBAs |
| title_full | Next generation excel modeling in excel for analysts and MBAs Isaac Gottlieb |
| title_fullStr | Next generation excel modeling in excel for analysts and MBAs Isaac Gottlieb |
| title_full_unstemmed | Next generation excel modeling in excel for analysts and MBAs Isaac Gottlieb |
| title_short | Next generation excel |
| title_sort | next generation excel modeling in excel for analysts and mbas |
| title_sub | modeling in excel for analysts and MBAs |
| topic | Finanzanalyse (DE-588)4133000-6 gnd EXCEL (DE-588)4138932-3 gnd |
| topic_facet | Finanzanalyse EXCEL |
| url | http://bvbr.bib-bvb.de:8991/F?func=service&doc_library=BVB01&local_base=BVB01&doc_number=020476523&sequence=000002&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA |
| work_keys_str_mv | AT gottliebisaac nextgenerationexcelmodelinginexcelforanalystsandmbas |