天气预报15天查询> 生活> 统计员常用excel技巧

统计员常用excel技巧

更新时间: 2021-04-27 00:05:22     

1、为重复值添加颜色。首先我们需要全选数据,然后点击菜单栏【开始】,找到【样式】点击【条件格式】,在里面再点击【突出显示单元格】——【重复值】即可!

2、快速筛选部门。我们需要点击赛选单元格,右击鼠标选择【筛选】找到【按所选单元格的值筛选】,即可完成表格部门筛选!

3、取消合并单元格,并填充。首先我们全选合并的单元格,取消合并单元格,再按住快捷键F5定位到空值,输入:=A2,并按住快捷键Ctrl+Enter即可!

4、快速制作工资条。首先要将右边的序列复制,然后将表头往下复制,全选右边序列,鼠标点击【数据】——【排序和序列】——选择【降序】,选择扩展选定区域,点击排序即可完成工资表制作!

关键词: 统计员 常用 excel 技巧

如有意见、反馈、侵权或投诉等情况,请联系:

电话:
邮箱:

我们将会在48小时内给与处理!

版权所有 Copyright ? 2009-2020 tianqiyubao3.com

页面:/news/view-591669/ | 耗时:0.2091 s | 内存:1.89 MB | 查询:4 | 缓存读取:4 写入:0 | 加载文件:23
select * from tbl_Articles WHERE ArticleID=591669 LIMIT 0,1
select * from tbl_Articles_data WHERE ArticleID=591669 LIMIT 0,1
select * from tbl_Articles_sphinx where id=591669 LIMIT 0,1
SELECT ArticleID,Title FROM tbl_Articles WHERE ArticleID IN(478300,505759,550461,547391,485289,398153,443859,515760,382630,408312,422352,513597,408560,89102,566555,576277,377757,456801,577031,516642,520615,534089,371079,534906,552331,418169,380477,408198,558093,436628) ORDER BY field (ArticleID,478300,505759,550461,547391,485289,398153,443859,515760,382630,408312,422352,513597,408560,89102,566555,576277,377757,456801,577031,516642,520615,534089,371079,534906,552331,418169,380477,408198,558093,436628)