1 创建数据透视表
![](https://img.haomeiwen.com/i12079082/9117779e3a90a1f9.png)
2 创建数据透视表之后还可以相加
![](https://img.haomeiwen.com/i12079082/0aa8accfacd7029d.png)
3 可以指定数据透视表的汇总方式,比如按照max, min sum count 之类的汇总
![](https://img.haomeiwen.com/i12079082/442039e13bdfc20f.png)
4 这个方法相当于数据透视表按计数汇总
![](https://img.haomeiwen.com/i12079082/f789dc4219738300.png)
5 创建新的一列未成年人 然后统计未成年人获救情况
![](https://img.haomeiwen.com/i12079082/2c0ae820624c8b89.png)
6 时间序列
![](https://img.haomeiwen.com/i12079082/ba8ad73f86cc2cd4.png)
![](https://img.haomeiwen.com/i12079082/aabf20395634c044.png)
![](https://img.haomeiwen.com/i12079082/cfeacf925913ad4a.png)
![](https://img.haomeiwen.com/i12079082/424a0affed4254e9.png)
7 创建10个日期,每隔12个小时创建一次
![](https://img.haomeiwen.com/i12079082/6fa3b4dbb23c2903.png)
8 筛选出从某个日期到某个日期的值
![](https://img.haomeiwen.com/i12079082/63abfe18458130e2.png)
![](https://img.haomeiwen.com/i12079082/6d2afd5a3c5c0ba1.png)
9 最后10个数
![](https://img.haomeiwen.com/i12079082/21efdae243940415.png)
10 筛选出2013年的数值
![](https://img.haomeiwen.com/i12079082/38623dce5eb582f4.png)
11 筛选出2012年1月份到3月份的数据
![](https://img.haomeiwen.com/i12079082/eb3c71385555e037.png)
12 筛选出一月份的数据
![](https://img.haomeiwen.com/i12079082/ac0fdfc912dfc54b.png)
13 筛选出8点到12点的数据筛
![](https://img.haomeiwen.com/i12079082/0a08f1efed871bb1.png)
![](https://img.haomeiwen.com/i12079082/ff9ca297ac12f698.png)
14 进行数据重构,一个是一天为单位,展示每天最大的,一个是3天一次,求平均
![](https://img.haomeiwen.com/i12079082/303c83b72e8245d6.png)
![](https://img.haomeiwen.com/i12079082/270e6786d5acfbcf.png)
网友评论