EXCEL把月份转换成季度的具体操作步骤如下:
1、首先在电脑上打开要进行操作的EXCEL工作表,然后在此页面中点击上方的“插入”选项卡,然后在其下方点击“数据透视表”,接着再次点击“数据透视表”。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/a8014c086e061d95e735278075f40ad162d9ca13?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
2、然后在此页面中用鼠标选中要进行操作的数据,然后在弹出来的对话框内点击“确定”。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/1f178a82b9014a90274d5605a7773912b31bee13?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
3、然后此时文件页面的右侧就会弹出一个操作框。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/bf096b63f6246b601978a2cce5f81a4c510fa217?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
4、在此框内点击勾选“日期”。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/1ad5ad6eddc451da249e1c53b8fd5266d0163219?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
5、接着再使用鼠标右键点击日期,然后在弹出的选项框内点击“组合”。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/00e93901213fb80e30a7716f38d12f2eb9389417?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
6、然后在此对话框内点击下方的“季度”,接着点击“确定”选项。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/6f061d950a7b020894862f596cd9f2d3572cc83f?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
7、然后此时返回文件的页面就会发现日月份变成季度显示出来了。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/4034970a304e251f1064f540a986c9177e3e53f2?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)