Main Title |
Ctrl+shift+enter : [mastering Excel array formulas] / |
Author |
Girvin, Mike.
|
Publisher |
Holy Macro! Books, |
Year Published |
2013 |
OCLC Number |
830353181 |
ISBN |
9781615470075; 1615470077 |
Subjects |
Electronic spreadsheets--Computer programs
|
Internet Access |
|
Holdings |
Library |
Call Number |
Additional Info |
Location |
Last Modified |
Checkout Status |
ELBM |
HF5548.4.M523G57 2013 |
|
AWBERC Library/Cincinnati,OH |
01/24/2023 |
|
Collation |
vii, 344 pages : illustrations ; 27 cm |
Notes |
Subtitle from cover. Includes index. |
Contents Notes |
"A book about building efficient formulas, advanced formulas, and array formulas for data analysis and calculating problems"--Cover. Formula basics -- Introduction to array formulas -- Math array operations -- Comparative array operations and aggregate calculations with one or more conditions -- Join array operations -- Function argument array operations -- Array constants -- Array formulas that deliver more than one value -- A first look at array functions: TRANSPOSE, MODE. MULT, and TREND -- The amazing SUMPRODUCT function (and SUMIFS, too) -- Boolean logic: AND criteria and OR criteria -- When is an array formula really needed? -- Dynamic ranges with the INDEX and OFFSET functions -- Array formula efficiency rules -- Extracting data, based on criteria -- The FREQUENCY array function -- Unique counting formulas and the power of the FREQUENCY function -- The MMULT array function -- Extracting unique lists and sorting formulas -- Conditional formatting with array formulas -- Data tables -- The LINEST array function -- Can you figure out how the huge array formula works? |
Place Published |
Uniontown, Ohio |
Alternate Title |
Control plus shift plus enter |
PUB Date Free Form |
©2013 |
BIB Level |
m |
Medium |
unmediated |
Content |
text |
Carrier |
volume |
Cataloging Source |
OCLC/T |
Merged OCLC records |
818318405; 1287179795 |
OCLC Time Stamp |
20230119213018 |
Language |
eng |
Origin |
OCLC |
Type |
CAT |
OCLC Rec Leader |
02841cam 2200469Ia 45010 |