Ctrl+shift+enter: mastering Excel array formulas
Gespeichert in:
| 1. Verfasser: | |
|---|---|
| Format: | Elektronisch E-Book |
| Sprache: | English |
| Veröffentlicht: |
Uniontown, OH
Holy Macro! Books
2013
|
| Schlagworte: | |
| Online-Zugang: | Volltext |
| Beschreibung: | Subtitle from cover. - Includes index Designed with Excel gurus in mind, this handbook outlines how to create formulas that can be used to solve everyday problems with a series of data values that standard Excel formulas cannot or would be too arduous to attempt. Beginning with an introduction to array formulas, this manual examines topics such as how they differ from ordinary formulas, the benefits and drawbacks of their use, functions that can and cannot handle array calculations, and array constants and functions. Among the practical applications surveyed include how to extract data from tables and unique lists, how to get results that match any criteria, and how to utilize various methods for unique counts. This book contains 529 screen shots |
| Beschreibung: | 1 Online-Ressource (viii, 344 pages :) |
| ISBN: | 9781615472093 1615472096 9781615473298 1615473297 9781615471096 161547109X |
Internformat
MARC
| LEADER | 00000nmm a2200000zc 4500 | ||
|---|---|---|---|
| 001 | BV042959036 | ||
| 003 | DE-604 | ||
| 005 | 00000000000000.0 | ||
| 007 | cr|uuu---uuuuu | ||
| 008 | 151030s2013 |||| o||u| ||||||eng d | ||
| 020 | |a 9781615472093 |c electronic bk. |9 978-1-61547-209-3 | ||
| 020 | |a 1615472096 |c electronic bk. |9 1-61547-209-6 | ||
| 020 | |a 9781615473298 |c electronic bk. |9 978-1-61547-329-8 | ||
| 020 | |a 1615473297 |c electronic bk. |9 1-61547-329-7 | ||
| 020 | |a 9781615471096 |c electronic bk. |9 978-1-61547-109-6 | ||
| 020 | |a 161547109X |c electronic bk. |9 1-61547-109-X | ||
| 035 | |a (OCoLC)859157827 | ||
| 035 | |a (DE-599)BVBBV042959036 | ||
| 040 | |a DE-604 |b ger |e aacr | ||
| 041 | 0 | |a eng | |
| 082 | 0 | |a 005.54 |2 23 | |
| 100 | 1 | |a Girvin, Mike |e Verfasser |4 aut | |
| 245 | 1 | 0 | |a Ctrl+shift+enter |b mastering Excel array formulas |c Mike Girvin |
| 246 | 1 | 3 | |a Ctrl shift enter |
| 246 | 1 | 3 | |a Control plus shift plus enter |
| 264 | 1 | |a Uniontown, OH |b Holy Macro! Books |c 2013 | |
| 300 | |a 1 Online-Ressource (viii, 344 pages :) | ||
| 336 | |b txt |2 rdacontent | ||
| 337 | |b c |2 rdamedia | ||
| 338 | |b cr |2 rdacarrier | ||
| 500 | |a Subtitle from cover. - Includes index | ||
| 500 | |a Designed with Excel gurus in mind, this handbook outlines how to create formulas that can be used to solve everyday problems with a series of data values that standard Excel formulas cannot or would be too arduous to attempt. Beginning with an introduction to array formulas, this manual examines topics such as how they differ from ordinary formulas, the benefits and drawbacks of their use, functions that can and cannot handle array calculations, and array constants and functions. Among the practical applications surveyed include how to extract data from tables and unique lists, how to get results that match any criteria, and how to utilize various methods for unique counts. This book contains 529 screen shots | ||
| 630 | 0 | 4 | |a Microsoft Excel (Computer file) |
| 650 | 7 | |a COMPUTERS / Desktop Applications / Spreadsheets |2 bisacsh | |
| 650 | 7 | |a Microsoft Excel (Computer file) |2 fast | |
| 650 | 7 | |a Electronic spreadsheets / Computer programs |2 fast | |
| 650 | 4 | |a Electronic spreadsheets |x Computer programs | |
| 776 | 0 | 8 | |i Erscheint auch als |n Druck-Ausgabe, Paperback |z 978-1-61547-007-5 |
| 776 | 0 | 8 | |i Erscheint auch als |n Druck-Ausgabe, Paperback |z 1-61547-007-7 |
| 856 | 4 | 0 | |u http://search.ebscohost.com/login.aspx?direct=true&scope=site&db=nlebk&db=nlabk&AN=630961 |x Aggregator |3 Volltext |
| 912 | |a ZDB-4-EBU | ||
| 940 | 1 | |q FLA_PDA_EBU | |
| 999 | |a oai:aleph.bib-bvb.de:BVB01-028384902 | ||
Datensatz im Suchindex
| _version_ | 1804175278381989888 |
|---|---|
| any_adam_object | |
| author | Girvin, Mike |
| author_facet | Girvin, Mike |
| author_role | aut |
| author_sort | Girvin, Mike |
| author_variant | m g mg |
| building | Verbundindex |
| bvnumber | BV042959036 |
| collection | ZDB-4-EBU |
| ctrlnum | (OCoLC)859157827 (DE-599)BVBBV042959036 |
| dewey-full | 005.54 |
| dewey-hundreds | 000 - Computer science, information, general works |
| dewey-ones | 005 - Computer programming, programs, data, security |
| dewey-raw | 005.54 |
| dewey-search | 005.54 |
| dewey-sort | 15.54 |
| dewey-tens | 000 - Computer science, information, general works |
| discipline | Informatik |
| format | Electronic eBook |
| fullrecord | <?xml version="1.0" encoding="UTF-8"?><collection xmlns="http://www.loc.gov/MARC21/slim"><record><leader>02583nmm a2200481zc 4500</leader><controlfield tag="001">BV042959036</controlfield><controlfield tag="003">DE-604</controlfield><controlfield tag="005">00000000000000.0</controlfield><controlfield tag="007">cr|uuu---uuuuu</controlfield><controlfield tag="008">151030s2013 |||| o||u| ||||||eng d</controlfield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">9781615472093</subfield><subfield code="c">electronic bk.</subfield><subfield code="9">978-1-61547-209-3</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">1615472096</subfield><subfield code="c">electronic bk.</subfield><subfield code="9">1-61547-209-6</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">9781615473298</subfield><subfield code="c">electronic bk.</subfield><subfield code="9">978-1-61547-329-8</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">1615473297</subfield><subfield code="c">electronic bk.</subfield><subfield code="9">1-61547-329-7</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">9781615471096</subfield><subfield code="c">electronic bk.</subfield><subfield code="9">978-1-61547-109-6</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">161547109X</subfield><subfield code="c">electronic bk.</subfield><subfield code="9">1-61547-109-X</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(OCoLC)859157827</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(DE-599)BVBBV042959036</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="082" ind1="0" ind2=" "><subfield code="a">005.54</subfield><subfield code="2">23</subfield></datafield><datafield tag="100" ind1="1" ind2=" "><subfield code="a">Girvin, Mike</subfield><subfield code="e">Verfasser</subfield><subfield code="4">aut</subfield></datafield><datafield tag="245" ind1="1" ind2="0"><subfield code="a">Ctrl+shift+enter</subfield><subfield code="b">mastering Excel array formulas</subfield><subfield code="c">Mike Girvin</subfield></datafield><datafield tag="246" ind1="1" ind2="3"><subfield code="a">Ctrl shift enter</subfield></datafield><datafield tag="246" ind1="1" ind2="3"><subfield code="a">Control plus shift plus enter</subfield></datafield><datafield tag="264" ind1=" " ind2="1"><subfield code="a">Uniontown, OH</subfield><subfield code="b">Holy Macro! Books</subfield><subfield code="c">2013</subfield></datafield><datafield tag="300" ind1=" " ind2=" "><subfield code="a">1 Online-Ressource (viii, 344 pages :)</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">c</subfield><subfield code="2">rdamedia</subfield></datafield><datafield tag="338" ind1=" " ind2=" "><subfield code="b">cr</subfield><subfield code="2">rdacarrier</subfield></datafield><datafield tag="500" ind1=" " ind2=" "><subfield code="a">Subtitle from cover. - Includes index</subfield></datafield><datafield tag="500" ind1=" " ind2=" "><subfield code="a">Designed with Excel gurus in mind, this handbook outlines how to create formulas that can be used to solve everyday problems with a series of data values that standard Excel formulas cannot or would be too arduous to attempt. Beginning with an introduction to array formulas, this manual examines topics such as how they differ from ordinary formulas, the benefits and drawbacks of their use, functions that can and cannot handle array calculations, and array constants and functions. Among the practical applications surveyed include how to extract data from tables and unique lists, how to get results that match any criteria, and how to utilize various methods for unique counts. This book contains 529 screen shots</subfield></datafield><datafield tag="630" ind1="0" ind2="4"><subfield code="a">Microsoft Excel (Computer file)</subfield></datafield><datafield tag="650" ind1=" " ind2="7"><subfield code="a">COMPUTERS / Desktop Applications / Spreadsheets</subfield><subfield code="2">bisacsh</subfield></datafield><datafield tag="650" ind1=" " ind2="7"><subfield code="a">Microsoft Excel (Computer file)</subfield><subfield code="2">fast</subfield></datafield><datafield tag="650" ind1=" " ind2="7"><subfield code="a">Electronic spreadsheets / Computer programs</subfield><subfield code="2">fast</subfield></datafield><datafield tag="650" ind1=" " ind2="4"><subfield code="a">Electronic spreadsheets</subfield><subfield code="x">Computer programs</subfield></datafield><datafield tag="776" ind1="0" ind2="8"><subfield code="i">Erscheint auch als</subfield><subfield code="n">Druck-Ausgabe, Paperback</subfield><subfield code="z">978-1-61547-007-5</subfield></datafield><datafield tag="776" ind1="0" ind2="8"><subfield code="i">Erscheint auch als</subfield><subfield code="n">Druck-Ausgabe, Paperback</subfield><subfield code="z">1-61547-007-7</subfield></datafield><datafield tag="856" ind1="4" ind2="0"><subfield code="u">http://search.ebscohost.com/login.aspx?direct=true&scope=site&db=nlebk&db=nlabk&AN=630961</subfield><subfield code="x">Aggregator</subfield><subfield code="3">Volltext</subfield></datafield><datafield tag="912" ind1=" " ind2=" "><subfield code="a">ZDB-4-EBU</subfield></datafield><datafield tag="940" ind1="1" ind2=" "><subfield code="q">FLA_PDA_EBU</subfield></datafield><datafield tag="999" ind1=" " ind2=" "><subfield code="a">oai:aleph.bib-bvb.de:BVB01-028384902</subfield></datafield></record></collection> |
| id | DE-604.BV042959036 |
| illustrated | Not Illustrated |
| indexdate | 2024-07-10T07:13:45Z |
| institution | BVB |
| isbn | 9781615472093 1615472096 9781615473298 1615473297 9781615471096 161547109X |
| language | English |
| oai_aleph_id | oai:aleph.bib-bvb.de:BVB01-028384902 |
| oclc_num | 859157827 |
| open_access_boolean | |
| physical | 1 Online-Ressource (viii, 344 pages :) |
| psigel | ZDB-4-EBU FLA_PDA_EBU |
| publishDate | 2013 |
| publishDateSearch | 2013 |
| publishDateSort | 2013 |
| publisher | Holy Macro! Books |
| record_format | marc |
| spelling | Girvin, Mike Verfasser aut Ctrl+shift+enter mastering Excel array formulas Mike Girvin Ctrl shift enter Control plus shift plus enter Uniontown, OH Holy Macro! Books 2013 1 Online-Ressource (viii, 344 pages :) txt rdacontent c rdamedia cr rdacarrier Subtitle from cover. - Includes index Designed with Excel gurus in mind, this handbook outlines how to create formulas that can be used to solve everyday problems with a series of data values that standard Excel formulas cannot or would be too arduous to attempt. Beginning with an introduction to array formulas, this manual examines topics such as how they differ from ordinary formulas, the benefits and drawbacks of their use, functions that can and cannot handle array calculations, and array constants and functions. Among the practical applications surveyed include how to extract data from tables and unique lists, how to get results that match any criteria, and how to utilize various methods for unique counts. This book contains 529 screen shots Microsoft Excel (Computer file) COMPUTERS / Desktop Applications / Spreadsheets bisacsh Microsoft Excel (Computer file) fast Electronic spreadsheets / Computer programs fast Electronic spreadsheets Computer programs Erscheint auch als Druck-Ausgabe, Paperback 978-1-61547-007-5 Erscheint auch als Druck-Ausgabe, Paperback 1-61547-007-7 http://search.ebscohost.com/login.aspx?direct=true&scope=site&db=nlebk&db=nlabk&AN=630961 Aggregator Volltext |
| spellingShingle | Girvin, Mike Ctrl+shift+enter mastering Excel array formulas Microsoft Excel (Computer file) COMPUTERS / Desktop Applications / Spreadsheets bisacsh Microsoft Excel (Computer file) fast Electronic spreadsheets / Computer programs fast Electronic spreadsheets Computer programs |
| title | Ctrl+shift+enter mastering Excel array formulas |
| title_alt | Ctrl shift enter Control plus shift plus enter |
| title_auth | Ctrl+shift+enter mastering Excel array formulas |
| title_exact_search | Ctrl+shift+enter mastering Excel array formulas |
| title_full | Ctrl+shift+enter mastering Excel array formulas Mike Girvin |
| title_fullStr | Ctrl+shift+enter mastering Excel array formulas Mike Girvin |
| title_full_unstemmed | Ctrl+shift+enter mastering Excel array formulas Mike Girvin |
| title_short | Ctrl+shift+enter |
| title_sort | ctrl shift enter mastering excel array formulas |
| title_sub | mastering Excel array formulas |
| topic | Microsoft Excel (Computer file) COMPUTERS / Desktop Applications / Spreadsheets bisacsh Microsoft Excel (Computer file) fast Electronic spreadsheets / Computer programs fast Electronic spreadsheets Computer programs |
| topic_facet | Microsoft Excel (Computer file) COMPUTERS / Desktop Applications / Spreadsheets Electronic spreadsheets / Computer programs Electronic spreadsheets Computer programs |
| url | http://search.ebscohost.com/login.aspx?direct=true&scope=site&db=nlebk&db=nlabk&AN=630961 |
| work_keys_str_mv | AT girvinmike ctrlshiftentermasteringexcelarrayformulas AT girvinmike ctrlshiftenter AT girvinmike controlplusshiftplusenter |