2364 29

# [其他] Ctrl+Shift+Enter: Mastering Excel Array Formulas [分享]

1%

-

9

2406622 个

17351.8348

2668 点

3384 点

2489 点

443277 点

5212

52

2874 小时

2007-8-6

2019-12-6

igs816   发表于 2015-6-4 09:58:27 |显示全部楼层

Ctrl+Shift+Enter: A Book About Building Efficient Formulas, Advanced Formulas, and Array Formulas for Data Analysis and Calculating Problems by Mike Excelisfun Girvin
English | July 21, 2013 | ISBN: 1615470077 | 338 Pages | pdf | 58 MB

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.

#### 本帖隐藏的内容

Ctrl Shift Enter - Mastering Excel Array Formulas.pdf (28.11 MB, 售价: 10 个论坛币)

lasgpope + 50 + 50 + 1 + 1 + 1 精彩帖子
fantuanxiaot + 50 + 50 精彩帖子

### 本帖被以下文库推荐

gyqznufe 发表于 2015-6-4 10:07:07 |显示全部楼层

 RE:Ctrl+Shift+Enter: Mastering Excel Array Formulas

vplusplus 发表于 2015-6-4 10:47:24 |显示全部楼层
 Starting Out with Python Global Edition, 3rd Edition 2015

knight48 发表于 2015-6-4 11:33:31 |显示全部楼层
 需要看看

lasgpope   发表于 2015-6-4 12:12:17 |显示全部楼层
 thx for sharing

mike68097 发表于 2015-6-4 12:17:21 |显示全部楼层

voodoo 发表于 2015-6-4 13:35:37 |显示全部楼层
 Ctrl+Shift+Enter: Mastering Excel Array Formulas，

condmn 发表于 2015-6-4 13:48:48 |显示全部楼层

elmo 发表于 2015-6-4 17:10:15 |显示全部楼层
 thanks for sharing

 您需要登录后才可以回帖 登录 | 我要注册 回帖后跳转到最后一页