夜雨聆风 > > 办公文件 > Excel手搓数据看板与AI生成数据报告你选谁?
当前时间: 2026-06-22 13:37:57
分类:办公文件
评论(0)
Excel手搓数据看板与AI生成数据报告你选谁?前两篇文章的本意是告诉大家,AI的工作速度太快了,并且结果非常好。并无制造焦虑的意思。相反,本人却非常焦虑,因为我们公司用AI最多的人是我们老板,被倒逼着紧跟步伐学习各种新技术。最近也确实不再写VBA代码了,都是生成的效果非常好。上篇文章中视频代码贴入执行效果。后又花了几个小时,手搓了一份数据看板,效果比较简单,就这么简单的看板也花了我不少时间啊。给我的AI小龙虾一句指令,5-6分钟生成了一份数据分析报告,又花了几分钟改了下(也是AI改的),效果如下:各位看官,如果你是老板,你要哪份报告呢?1.Excel手搓数据看板;2.AI生成数据分析报告。请告诉我你的选择。有同学问如何输入指令,我觉得就是说话,你怎么跟同事讲,就怎么跟他讲,当然尽可能简洁、清晰。前两篇文章的生成VBA指令忘了在合并和增加一列,来源的表格,我是这么通知AI修改的:生成后的代码,如本文的第一个视频所示,复制粘贴到VBA编辑窗口,即可。重要的是执行!重要的是执行!重要的是执行!(重要的事情说三遍)
基本
文件
流程
错误
SQL
调试
- 请求信息 : 2026-07-05 02:46:15 HTTP/1.1 GET : https://www.yeyulingfeng.com/a/534014.html
- 运行时间 : 0.221508s [ 吞吐率:4.51req/s ] 内存消耗:4,683.63kb 文件加载:145
- 缓存信息 : 0 reads,0 writes
- 会话信息 : SESSION_ID=2643011ebe9f4c9b4fbcc6a7200e57da
- CONNECT:[ UseTime:0.000939s ] mysql:host=127.0.0.1;port=3306;dbname=wenku;charset=utf8mb4
- SHOW FULL COLUMNS FROM `fenlei` [ RunTime:0.001434s ]
- SELECT * FROM `fenlei` WHERE `fid` = 0 [ RunTime:0.000609s ]
- SELECT * FROM `fenlei` WHERE `fid` = 63 [ RunTime:0.000589s ]
- SHOW FULL COLUMNS FROM `set` [ RunTime:0.001190s ]
- SELECT * FROM `set` [ RunTime:0.000462s ]
- SHOW FULL COLUMNS FROM `article` [ RunTime:0.001307s ]
- SELECT * FROM `article` WHERE `id` = 534014 LIMIT 1 [ RunTime:0.000746s ]
- UPDATE `article` SET `lasttime` = 1783190775 WHERE `id` = 534014 [ RunTime:0.046409s ]
- SELECT * FROM `fenlei` WHERE `id` = 64 LIMIT 1 [ RunTime:0.000713s ]
- SELECT * FROM `article` WHERE `id` < 534014 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001212s ]
- SELECT * FROM `article` WHERE `id` > 534014 ORDER BY `id` ASC LIMIT 1 [ RunTime:0.001448s ]
- SELECT * FROM `article` WHERE `id` < 534014 ORDER BY `id` DESC LIMIT 10 [ RunTime:0.009142s ]
- SELECT * FROM `article` WHERE `id` < 534014 ORDER BY `id` DESC LIMIT 10,10 [ RunTime:0.001889s ]
- SELECT * FROM `article` WHERE `id` < 534014 ORDER BY `id` DESC LIMIT 20,10 [ RunTime:0.002370s ]
0.224874s