当前时间： 2026-06-08 10:34:21
分类：办公文件
评论(0)
女生自力更生丨擅用Excel实用技巧excel 作为职场必备技能，熟练使用它，对工作提效发挥90%的作用，一套高阶excel使用能力更是可以助力达到数据分析高水平，可以运用在管理财务、时间、任务、汇总数据报表中。
特别是搭配女生细腻的心，女生一旦上手，适应能力极快，那种飞速出结果的感觉，用数据来说话的爽感，真的很有成就感！
下面分别从常用的快捷键、数据处理、高效实用技巧简单梳理，直接存下！
一、常用快捷键
二、数据处理
基本
文件
流程
错误
SQL
调试
- 请求信息 : 2026-06-08 11:30:32 HTTP/1.1 GET : https://www.yeyulingfeng.com/a/724874.html
- 运行时间 : 0.134409s [ 吞吐率：7.44req/s ] 内存消耗：4,681.35kb 文件加载：145
- 缓存信息 : 0 reads,0 writes
- 会话信息 : SESSION_ID=aac35d7b4f6b6f8289385aa1588393a5
- CONNECT:[ UseTime:0.000863s ] mysql:host=127.0.0.1;port=3306;dbname=wenku;charset=utf8mb4
- SHOW FULL COLUMNS FROM `fenlei` [ RunTime:0.001426s ]
- SELECT * FROM `fenlei` WHERE `fid` = 0 [ RunTime:0.000645s ]
- SELECT * FROM `fenlei` WHERE `fid` = 63 [ RunTime:0.000632s ]
- SHOW FULL COLUMNS FROM `set` [ RunTime:0.001365s ]
- SELECT * FROM `set` [ RunTime:0.000539s ]
- SHOW FULL COLUMNS FROM `article` [ RunTime:0.001518s ]
- SELECT * FROM `article` WHERE `id` = 724874 LIMIT 1 [ RunTime:0.001165s ]
- UPDATE `article` SET `lasttime` = 1780889432 WHERE `id` = 724874 [ RunTime:0.014352s ]
- SELECT * FROM `fenlei` WHERE `id` = 64 LIMIT 1 [ RunTime:0.000392s ]
- SELECT * FROM `article` WHERE `id` < 724874 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000583s ]
- SELECT * FROM `article` WHERE `id` > 724874 ORDER BY `id` ASC LIMIT 1 [ RunTime:0.000447s ]
- SELECT * FROM `article` WHERE `id` < 724874 ORDER BY `id` DESC LIMIT 10 [ RunTime:0.002118s ]
- SELECT * FROM `article` WHERE `id` < 724874 ORDER BY `id` DESC LIMIT 10,10 [ RunTime:0.000772s ]
- SELECT * FROM `article` WHERE `id` < 724874 ORDER BY `id` DESC LIMIT 20,10 [ RunTime:0.001565s ]
0.138409s
夜雨聆风
