excel函数Excel中高级讲义函数应用[汇编].pdfVIP

Excel 中高级讲义 目录 一 . 公式基础 ·············································································· 2 二 . 统计、文本基本函数 ······························································· 4 三 . 日期、信息基本函数 ······························································· 4 四. 逻辑函数 ·············································································· 4 五 . 数据查阅函数 ········································································ 4 六 . 常用快捷键 ··········································································· 5 七 . 常用编辑命令 ········································································ 5 八 . 格式 (format) ··················································错误 !未定义书签。 九 . 关于打印及其他 ·············································错误 !未定义书签。 十 . 财务函数 ······················································错误 !未定义书签。 十一 . 数据库操作 ···················································错误 !未定义书签。 十二 . 数据引用 ·············································································· 6 十三 . 选择性粘贴 (paste special) ························································ 7 十四 . 数据的有效性（ validation) ······················································· 8 十五 . 数据的保护（ protection ） ································错误 !未定义书签。 十六 . 图表基础 ······················································错误 !未定义书签。 十七 . 双轴图表 ······················································错误 !未定义书签。 十八 . 保存自定义图表类型 ( custom chart type) ············错误 !未定义书签。 十九 . 分类汇总与合并计算 ·······································错误 !未定义书签。 二十 . 数据透视表 ···················································错误 !未定义书签。 二十一 . 高级函数 ·····························