Cargando…
Ctrl+shift+enter : mastering Excel array formulas /
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 top...
| Clasificación: | Libro Electrónico |
|---|---|
| Autor principal: | |
| Formato: | Electrónico eBook |
| Idioma: | Inglés |
| Publicado: |
Uniontown, OH :
Holy Macro! Books,
2013.
|
| Colección: | Office Essentials collection
|
| Temas: | |
| Acceso en línea: | Texto completo |
MARC
| LEADER | 00000cam a2200000Ma 4500 | ||
|---|---|---|---|
| 001 | EBOOKCENTRAL_ocn859157827 | ||
| 003 | OCoLC | ||
| 005 | 20240329122006.0 | ||
| 006 | m o d | ||
| 007 | cr cn||||||||| | ||
| 008 | 130228s2013 ohua o 001 0 eng d | ||
| 040 | |a E7B |b eng |e pn |c E7B |d OCLCO |d OCLCQ |d TEFOD |d OCLCQ |d VALIL |d OCLCF |d B24X7 |d N$T |d ZCU |d EBLCP |d IDEBK |d DEBSZ |d OCP |d YDXCP |d TEFOD |d OCLCQ |d COO |d FEM |d AGLDB |d MERUC |d OCLCQ |d K6U |d OCLCQ |d OCLCO |d U3W |d D6H |d STF |d WRM |d OCLCQ |d ICG |d VT2 |d OCLCQ |d OCLCO |d WYU |d A6Q |d DKC |d OCLCQ |d AU@ |d OCLCQ |d OCLCO |d UKCRE |d BRF |d OCLCO |d OCLCQ |d OCLCO |d OCLCL | ||
| 019 | |a 855969782 |a 864219896 |a 961665283 |a 962571732 |a 966357832 |a 968057113 |a 969050441 |a 974978810 |a 975040175 |a 981875675 |a 993655963 |a 1004685194 |a 1005638449 |a 1018061560 |a 1029490706 |a 1041892169 |a 1060196304 |a 1081218791 |a 1083556429 |a 1097131278 |a 1153512101 |a 1228620803 | ||
| 020 | |a 9781615472093 |q (electronic bk.) | ||
| 020 | |a 1615472096 |q (electronic bk.) | ||
| 020 | |a 9781615473298 |q (electronic bk.) | ||
| 020 | |a 1615473297 |q (electronic bk.) | ||
| 020 | |a 9781615471096 |q (electronic bk.) | ||
| 020 | |a 161547109X |q (electronic bk.) | ||
| 020 | |z 9781615470075 |q (pbk.) | ||
| 020 | |z 1615470077 |q (pbk.) | ||
| 029 | 1 | |a AU@ |b 000052905276 | |
| 029 | 1 | |a DEBBG |b BV042959036 | |
| 029 | 1 | |a DEBBG |b BV044177307 | |
| 029 | 1 | |a DEBSZ |b 397617186 | |
| 029 | 1 | |a DEBSZ |b 456344160 | |
| 035 | |a (OCoLC)859157827 |z (OCoLC)855969782 |z (OCoLC)864219896 |z (OCoLC)961665283 |z (OCoLC)962571732 |z (OCoLC)966357832 |z (OCoLC)968057113 |z (OCoLC)969050441 |z (OCoLC)974978810 |z (OCoLC)975040175 |z (OCoLC)981875675 |z (OCoLC)993655963 |z (OCoLC)1004685194 |z (OCoLC)1005638449 |z (OCoLC)1018061560 |z (OCoLC)1029490706 |z (OCoLC)1041892169 |z (OCoLC)1060196304 |z (OCoLC)1081218791 |z (OCoLC)1083556429 |z (OCoLC)1097131278 |z (OCoLC)1153512101 |z (OCoLC)1228620803 | ||
| 037 | |a EAA059E1-8E75-48B7-98CE-F9E6C957B749 |b OverDrive, Inc. |n http://www.overdrive.com | ||
| 050 | 4 | |a HF5548.4.M523 |b G57 2013eb | |
| 072 | 7 | |a COM |x 054000 |2 bisacsh | |
| 082 | 0 | 4 | |a 005.54 |2 23 |
| 049 | |a UAMI | ||
| 100 | 1 | |a Girvin, Mike. | |
| 245 | 1 | 0 | |a Ctrl+shift+enter : |b mastering Excel array formulas / |c Mike Girvin. |
| 246 | 3 | |a Ctrl shift enter | |
| 246 | 3 | |a Control plus shift plus enter | |
| 260 | |a Uniontown, OH : |b Holy Macro! Books, |c 2013. | ||
| 300 | |a 1 online resource (viii, 344 pages) : |b illustrations | ||
| 336 | |a text |b txt |2 rdacontent | ||
| 337 | |a computer |b c |2 rdamedia | ||
| 338 | |a online resource |b cr |2 rdacarrier | ||
| 347 | |a text file |2 rda | ||
| 490 | 0 | |a Office Essentials collection | |
| 500 | |a Subtitle from cover. | ||
| 500 | |a Includes index. | ||
| 520 | |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. | ||
| 505 | 0 | |a Front Cover; Title page; Copyright page; Contents; Dedications; About the Author; Acknowledgements; Introduction; Chapter 1: Formula Basics; Chapter 2: Introduction to Array Formulas; Chapter 3: Math Array Operations; Chapter 4: Comparative Array Operations and Aggregate Calculations with One or More Conditions; Chapter 5: Join Array Operations; Chapter 6: Function Argument Array Operations; Chapter 7: Array Constants; Chapter 8: Array Formulas That Deliver More Than One Value; Chapter 9: A First Look at Array Functions: TRANSPOSE, MODE. MULT, and TREND. | |
| 505 | 8 | |a Chapter 10: The Amazing SUMPRODUCT Function (and SUMIFS, Too)Chapter 11: Boolean Logic: AND Criteria and OR Criteria; Chapter 12: When Is an Array Formula Really Needed?; Chapter 13: Dynamic Ranges with the INDEX and OFFSET Functions; Chapter 14: Array Formula Efficiency Rules; Chapter 15: Extracting Data, Based on Criteria; Chapter 16: The FREQUENCY Array Function; Chapter 17: Unique Counting Formulas and the Power of the FREQUENCY Function; Chapter 18: The MMULT Array Function; Chapter 19: Extracting Unique Lists and Sorting Formulas; Chapter 20: Conditional Formatting with Array Formulas. | |
| 505 | 8 | |a Chapter 21: Data TablesChapter 22: The LINEST Array Function; Chapter 23: Can You Figure Out How the Huge Array Formula Works?; Conclusion; Index. | |
| 590 | |a ProQuest Ebook Central |b Ebook Central Academic Complete | ||
| 630 | 0 | 0 | |a Microsoft Excel (Computer file) |
| 630 | 0 | 7 | |a Microsoft Excel (Computer file) |2 fast |
| 650 | 0 | |a Electronic spreadsheets |x Computer programs. | |
| 650 | 6 | |a Tableurs |x Logiciels. | |
| 650 | 7 | |a COMPUTERS |x Desktop Applications |x Spreadsheets. |2 bisacsh | |
| 650 | 7 | |a Electronic spreadsheets |x Computer programs |2 fast | |
| 758 | |i has work: |a Ctrl+Shift+Enter Mastering Excel Array Formulas: A Book About Building Efficient Formulas, Advanced Formulas, and Array Formulas for Data Analysis an (Text) |1 https://id.oclc.org/worldcat/entity/E39PCXKrd3BC3dtF6CDB6hJVqP |4 https://id.oclc.org/worldcat/ontology/hasWork | ||
| 776 | 0 | 8 | |i Print version: |a Girvin, Mike. |t Ctrl+Shift+Enter Mastering Excel Array Formulas : A Book About Building Efficient Formulas, Advanced Formulas, and Array Formulas for Data Analysis an. |d Chicago : Holy Macro! Books, ©2013 |z 9781615470075 |
| 856 | 4 | 0 | |u https://ebookcentral.uam.elogim.com/lib/uam-ebooks/detail.action?docID=1340878 |z Texto completo |
| 938 | |a Books 24x7 |b B247 |n bko00057398 | ||
| 938 | |a EBL - Ebook Library |b EBLB |n EBL1340878 | ||
| 938 | |a ebrary |b EBRY |n ebr10745692 | ||
| 938 | |a EBSCOhost |b EBSC |n 630961 | ||
| 938 | |a ProQuest MyiLibrary Digital eBook Collection |b IDEB |n cis26448355 | ||
| 938 | |a YBP Library Services |b YANK |n 11074802 | ||
| 994 | |a 92 |b IZTAP | ||