excel函数_Excel中高级讲义_函数应用

excel函数_Excel中高级讲义_函数应用

Excel中高级讲义

目录

一. 公式基础·········································································································2

二. 统计、文本基本函数·····················································································4

三. 日期、信息基本函数·····················································································4

四. 逻辑函数·········································································································4

五. 数据查阅函数·································································································4

六. 常用快捷键·····································································································5

七. 常用编辑命令·································································································5

八. 格式(format)································································ 错误！未定义书签。

九. 关于打印及其他·························································· 错误！未定义书签。

十. 财务函数······································································ 错误！未定义书签。 十一. 数据库操作·································································· 错误！未定义书签。 十二. 数据引用·········································································································6 十三. 选择性粘贴(paste special)···········································································7 十四. 数据的有效性（validation) ··········································································8 十五. 数据的保护（protection） ········································ 错误！未定义书签。 十六. 图表基础······································································ 错误！未定义书签。 十七. 双轴图表······································································ 错误！未定义书签。 十八. 保存自定义图表类型( custom chart type) ·············· 错误！未定义书签。 十九. 分类汇总与合并计算·················································· 错误！未定义书签。 二十. 数据透视表·································································· 错误！未定义书签。 二十一. 高级函数·········································································································8 二十二. 高级筛选与数据库函数·············································· 错误！未定义书签。 二十三. 自定义格式·································································· 错误！未定义书签。 二十四. 列表功能·········································································································9 二十五. 导入外部数据（import extenal data） ······················································9 二十六. 使用窗体控件（forms）············································ 错误！未定义书签。 二十七. 方案、单变量求解······················································ 错误！未定义书签。 二十八. 创建模拟运算表（table） ········································· 错误！未定义书签。 二十九. 使用规划求解（solver)·············································· 错误！未定义书签。 三十. 数据的统计分析·························································· 错误！未定义书签。 三十一. 宏代码的录制与学习·················································· 错误！未定义书签。

1