Sponsored
Ctrl+Shift+Enter Mastering Excel Array Formulas - by Mike E Girvin (Paperback)
$25.49 sale price when purchased online
$29.95 list price
Target Online store #3991
About this item
Highlights
- 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.
- About the Author: Mike Girvin is the author of Slaying Excel Dragons and has more than 800 Excel how-to videos on YouTube.
- 308 Pages
- Computers + Internet, Desktop Applications
Description
About the Book
"A book about building efficient formulas, advanced formulas, and array formulas for data analysis and calculating problems"--Cover.Book Synopsis
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.About the Author
Mike Girvin is the author of Slaying Excel Dragons and has more than 800 Excel how-to videos on YouTube. He teaches finance, accounting, and statistics using Excel at the community college level. He lives in Seattle.Dimensions (Overall): 10.4 Inches (H) x 8.2 Inches (W) x .8 Inches (D)
Weight: 1.65 Pounds
Suggested Age: 22 Years and Up
Number of Pages: 308
Genre: Computers + Internet
Sub-Genre: Desktop Applications
Publisher: Holy Macro! Books
Theme: Spreadsheets
Format: Paperback
Author: Mike E Girvin
Language: English
Street Date: July 21, 2013
TCIN: 1003345708
UPC: 9781615470075
Item Number (DPCI): 247-17-1453
Origin: Made in the USA or Imported
If the item details above aren’t accurate or complete, we want to know about it.
Shipping details
Estimated ship dimensions: 0.8 inches length x 8.2 inches width x 10.4 inches height
Estimated ship weight: 1.65 pounds
We regret that this item cannot be shipped to PO Boxes.
This item cannot be shipped to the following locations: American Samoa (see also separate entry under AS), Guam (see also separate entry under GU), Northern Mariana Islands, Puerto Rico (see also separate entry under PR), United States Minor Outlying Islands, Virgin Islands, U.S., APO/FPO
Return details
This item can be returned to any Target store or Target.com.
This item must be returned within 90 days of the date it was purchased in store, shipped, delivered by a Shipt shopper, or made ready for pickup.
See the return policy for complete information.