Excel
1. 能做什么
- 数据存储
- 数据处理
- 数据分析
- 数据呈现
2. 小工具
- ctrl+:可以在单元格中显示当天时间
- 在单元格左侧有个格子可以填2:20,然后就会自动选中2-20行的所有数据
- 冻结窗格:选中一个单元格就会冻结该单元格的上部分和左部分
- 填充柄:选中单元格然后鼠标放单元格右下角会有实心十字,下拉会复制,ctrl然后摁鼠标左键下拉会按序列显示,点右键下拉还会有一些选项,也可以自定义这些序列
3. 单元格格式工具美化表格
- 合并单元格
- 边框,以及在一个单元格中画斜线
- 格式刷,双击格式刷可以刷多次,按esc取消
4. 单元格数字格式
5. 使用分列工具
6. 查找、替换、定位
- 模糊查找 * 所有 ?一个字符 ~* 去掉*的特殊含义
When nothing seems to help, I go look at a stonecutter hammering away at his rock, perhaps a hundred times without as much as a crack showing in it. Yet at the hundred and first blow it will split in two, and I know it was not that blow that did it, but all that had gone before. -- Jacob Riis