Record Display for the EPA National Library Catalog

RECORD NUMBER: 9 OF 45

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
Description Access URL
https://ebookcentral.proquest.com/lib/soton-ebooks/detail.action?docID=1340878
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?