MS Excel MVP的作品集(特供大头网站)

本文汇总了多位专家提供的 Excel VBA 编程技巧和教程资源链接,包括 Aaron Blood、Dave Hawley、Frank Isaacs 等人的贡献,覆盖了从基础知识到高级应用的多个方面。

摘要生成于 C知道 ,由 DeepSeek-R1 满血版支持, 前往体验 >

下载地址(需注册):http://office.9zp.com/dispbbs.asp?boardID=17&ID=149&page=2

Aaron_Blood
Chip Pearson

Dave Hawley
David McRitchie

Frank Isaacs
ilyap'a excel
John F. Larcher
John Walkenbach
Monika Weber
Rob Bovey Apps Pro

Rob's Excel VBA Tips & Tricks

Rodney Carr's
Rodney Powell

Teacher's Friend© Excel Easy Marker

Tushar Mehta Main Page
VBUsers.com
www. barasch.com

www.prodomosua.it

目录 一. 函数应用基础 ................................................................................................................ 1 1. 函数和公式 ................................................................................................................ 1 [1]. 什么是函数 ..................................................................................................... 1 [2]. 什么是公式 ..................................................................................................... 1 2. 函数参数 .................................................................................................................... 1 [1]. 常量 ................................................................................................................ 1 [2]. 逻辑值 ............................................................................................................ 2 [3]. 数组 ................................................................................................................ 2 [4]. 错误值 ............................................................................................................ 2 [5]. 单元格引用 ..................................................................................................... 2 [6]. 嵌套函数 ......................................................................................................... 3 [7]. 名称和标志 ..................................................................................................... 3 3. 函数输入方法 ............................................................................................................ 3 [1]. “插入函数”对话框 ....................................................................................... 3 [2]. 编辑栏输入 ..................................................................................................... 4 二. 函数速查一览 ................................................................................................................ 4 1. 数据库函数 ................................................................................................................ 4 [1]. DAVERAGE ................................................................................................... 4 [2]. DCOUNT ........................................................................................................ 4 [3]. DCOUNTA ..................................................................................................... 5 [4]. DGET .............................................................................................................. 5 [5]. DMAX ............................................................................................................ 5 [6]. DMIN .............................................................................................................. 5 [7]. DPRODUCT .................................................................................................... 5 [8]. DSTDEV .......................................................................................................... 5 [9]. DSTDEVP) ....................................................................................................... 5 [10]. DSUM ...................................................................................................... 6 [11]. DVAR ...................................................................................................... 6 [12]. DVARP .................................................................................................... 6 [13]. GETPIVOTDATA...................................................................................... 6 2. 日期与时间函数 ......................................................................................................... 6 [1]. DATE............................................................................................................... 6 [2]. DATEVALUE ................................................................................................... 7 [3]. DAY ................................................................................................................ 7 [4]. DAYS360 ........................................................................................................ 7 [5]. EDATE ............................................................................................................. 8 [6]. EOMONTH ..................................................................................................... 8 [7]. HOUR ............................................................................................................. 8 [8]. MINUTE ........................................................................................................... 8 [9]. MONTH
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值