_线上培训_呈贡人才云服务平台

简介
目录

课程简介

课程说明：不少HR在操作EXCEL过程中，总会去追求效率的方法，但一些情况下效率的方法反而是不效率或者错误的，原因在于HR对EXCEL的知识没有深入了解或者对工作没有完全掌握。本课程带给大家HR工作中常见EXCEL错误应用及解决办法，让HR掌握效率准确的数据统计方法。课程目录： 1、分什么也不要分表 2、人事数据不能这样统计 3、辅助列和条件格式不能滥用 4、平均值不能这么计算

课程目录

导师介绍

齐涛

高级人力资源管理师

基本文件流程错误 SQL 调试

/usr/www/democg.job1001.com/index.php ( 0.79 KB )
/usr/www/democg.job1001.com/public/sysconfig.php ( 54.19 KB )
/usr/www/democg.job1001.com/thinkphp/start.php ( 0.74 KB )
/usr/www/democg.job1001.com/thinkphp/base.php ( 2.66 KB )
/usr/www/democg.job1001.com/thinkphp/library/think/Loader.php ( 21.73 KB )
/usr/www/democg.job1001.com/thinkphp/library/think/Error.php ( 3.88 KB )
/usr/www/democg.job1001.com/thinkphp/library/think/Config.php ( 6.58 KB )
/usr/www/democg.job1001.com/thinkphp/convention.php ( 10.66 KB )
/usr/www/democg.job1001.com/thinkphp/library/think/App.php ( 22.17 KB )
/usr/www/democg.job1001.com/thinkphp/library/think/Request.php ( 51.43 KB )
/usr/www/democg.job1001.com/application/config.php ( 10.86 KB )
/usr/www/democg.job1001.com/application/database.php ( 1.88 KB )
/usr/www/democg.job1001.com/application/extra/Auth.php ( 5.69 KB )
/usr/www/democg.job1001.com/application/extra/Email.php ( 0.22 KB )
/usr/www/democg.job1001.com/application/extra/General.php ( 5.66 KB )
/usr/www/democg.job1001.com/application/extra/Generate.php ( 20.17 KB )
/usr/www/democg.job1001.com/application/extra/H.php ( 30.89 KB )
/usr/www/democg.job1001.com/application/extra/Oss.php ( 3.16 KB )
/usr/www/democg.job1001.com/application/extra/Sql.php ( 5.83 KB )
/usr/www/democg.job1001.com/application/extra/String.php ( 44.86 KB )
/usr/www/democg.job1001.com/application/extra/function.php ( 22.07 KB )
/usr/www/democg.job1001.com/application/extra/queue.php ( 0.62 KB )
/usr/www/democg.job1001.com/application/extra/site_config.php ( 2.96 KB )
/usr/www/democg.job1001.com/thinkphp/library/think/Hook.php ( 4.86 KB )
/usr/www/democg.job1001.com/application/tags.php ( 0.96 KB )
/usr/www/democg.job1001.com/application/common.php ( 8.29 KB )
/usr/www/democg.job1001.com/thinkphp/library/think/Env.php ( 1.25 KB )
/usr/www/democg.job1001.com/thinkphp/helper.php ( 23.97 KB )
/usr/www/democg.job1001.com/thinkphp/library/think/Lang.php ( 7.49 KB )
/usr/www/democg.job1001.com/thinkphp/library/think/Log.php ( 6.28 KB )
/usr/www/democg.job1001.com/thinkphp/lang/zh-cn.php ( 11.94 KB )
/usr/www/democg.job1001.com/application/route.php ( 0.81 KB )
/usr/www/democg.job1001.com/thinkphp/library/think/Route.php ( 61.83 KB )
/usr/www/democg.job1001.com/application/study/config.php ( 1.46 KB )
/usr/www/democg.job1001.com/application/study/controller/Index.php ( 17.67 KB )
/usr/www/democg.job1001.com/application/study/controller/Common.php ( 1.44 KB )
/usr/www/democg.job1001.com/thinkphp/library/think/Controller.php ( 6.29 KB )
/usr/www/democg.job1001.com/thinkphp/library/traits/controller/Jump.php ( 5.06 KB )
/usr/www/democg.job1001.com/thinkphp/library/think/View.php ( 7.01 KB )
/usr/www/democg.job1001.com/thinkphp/library/think/view/driver/Think.php ( 5.80 KB )
/usr/www/democg.job1001.com/thinkphp/library/think/Template.php ( 46.02 KB )
/usr/www/democg.job1001.com/thinkphp/library/think/template/driver/File.php ( 2.31 KB )
/usr/www/democg.job1001.com/thinkphp/library/think/Session.php ( 11.22 KB )
/usr/www/democg.job1001.com/extend/job1001/rpc/EntySoap.php ( 16.72 KB )
/usr/www/democg.job1001.com/thinkphp/library/think/exception/ErrorException.php ( 1.89 KB )
/usr/www/democg.job1001.com/thinkphp/library/think/Exception.php ( 1.66 KB )
/usr/www/democg.job1001.com/thinkphp/library/think/exception/Handle.php ( 8.72 KB )
/usr/www/democg.job1001.com/runtime/temp/4943da9f7ff8a7e6f6e0f2a0e744d105.php ( 13.17 KB )
/usr/www/democg.job1001.com/thinkphp/library/think/Url.php ( 13.04 KB )
/usr/www/democg.job1001.com/thinkphp/library/think/Response.php ( 8.61 KB )
/usr/www/democg.job1001.com/thinkphp/library/think/Debug.php ( 7.37 KB )
/usr/www/democg.job1001.com/thinkphp/library/think/debug/Html.php ( 4.28 KB )
/usr/www/democg.job1001.com/thinkphp/library/think/Db.php ( 6.85 KB )
/usr/www/democg.job1001.com/thinkphp/library/think/Cache.php ( 6.34 KB )

[ LANG ] /usr/www/democg.job1001.com/thinkphp/lang/zh-cn.php
[ ROUTE ] array ( 'type' => 'module', 'module' => array ( 0 => 'study', 1 => 'index', 2 => 'lesson_detail', ), )
[ HEADER ] array ( 'connection' => 'keep-alive', 'cache-control' => 'max-age=259200', 'x-forwarded-for' => '10.1.216.147', 'via' => '1.1 squid-proxy-7c6b6f947b-jg4nm (squid/6.13)', 'host' => 'democg.job1001.com', 'accept-encoding' => 'gzip, br, zstd, deflate', 'user-agent' => 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)', 'accept' => '*/*', 'content-type' => '', 'content-length' => '', )
[ PARAM ] array ( 'id' => '127401', )
[ SESSION ] INIT array ( 'id' => '', 'var_session_id' => '', 'prefix' => 'think', 'type' => '', 'auto_start' => true, )
[ RUN ] app\study\controller\Index->lesson_detail[ /usr/www/democg.job1001.com/application/study/controller/Index.php ]
[ EntySoap ] before request: array ( 'url' => 'https://openapi.job1001.com/video/courseDetail', 'data' => '{"job1001_param_auto_0":"127401"}', 'headers' => array ( 0 => 'Connection: keep-alive', 1 => 'Accept-Encoding: gzip, deflate', 2 => 'SYS: GUIZHOU,BIG_DATA,', 3 => 'Date: Wed 13 May 2026 19:39:39 GMT', 4 => 'Content-Type: application/json', 5 => 'Auth: Qkdz9LjyR2iBQ941 yl1001 : QzDCfD/tBNX8eCbAPpyTb0ARop4=', ), 'conn_timeout' => 5, 'timeout' => 3, )
[ EntySoap ] result: array ( 'report' => array ( '请求响应码' => 200, '请求响应类型' => 'application/json; charset=utf-8', '请求总耗时' => '0.102495', '域名解析' => '0.007825', 'TCP连接' => '0.000429', '传输前耗时(SSL?)' => '0.008011', '服务接收及处理' => '0.086192', '结果接收' => '0.000038', '本地端口' => 35736, '请求数据字节' => 33.0, '结果接收字节' => 2351.0, ), 'response' => '{"status":"OK","code":200,"status_desc":"","info":{"group_id":"127401","group_person_id":"21144489","group_name":"HR工作常见Excel错误应用及解决办法","group_code":"557492","tradeid":"0","totalid":"0","group_pic":"http:\\/\\/img106.job1001.com\\/upload\\/group_pic\\/group\\/127401.jpg?1500017456","group_background":"http:\\/\\/img106.job1001.com\\/upload\\/adminnew\\/2017-07-14\\/1500024491-C9MHFIL.jpg","group_intro":"课程说明：\\n不少HR在操作EXCEL过程中，总会去追求效率的方法，但一些情况下效率的方法反而是不效率或者错误的，原因在于HR对EXCEL的知识没有深入了解或者对工作没有完全掌握。\\n本课程带给大家HR工作中常见EXCEL错误应用及解决办法，让HR掌握效率准确的数据统计方法。\\n\\n课程目录：\\n1、分什么也不要分表\\n2、人事数据不能这样统计\\n3、辅助列和条件格式不能滥用\\n4、平均值不能这么计算","group_audit_status":"5","sys_status":"0","group_open_status":"3","group_person_cnt":"5","group_article_cnt":"","group_member_cnt_limit":"1000","idatetime":"2017-07-14 15:16:45","updatetime":"2017-07-18 10:55:49","checktime":"2019-09-03 17:03:34","group_tag_names":"","zwid":"0","zwname":"","istj":"1","updatetime_act_last":"2019-10-21 19:05:30","group_show_grcode":"1","group_number":"557492","sysUpdatetime":"2019-10-21 19:05:30","sys_source":"APPS_ANDROID_PHONE","sys_product":"YL1001_GROUP","sys_source_version":"v5.9.23","group_source":"1","fromtype":"","groups_communicate_mode":"10","charge":"2","group_type":"20","cat_id":"0","is_open":"0","trade_desc":"","auto_article_id":"3201500016605274","group_person_detail":{"personId":"21144489","person_iname":"齐涛","person_rctype":"0","person_sex":"男","person_email":"windyqt@163.com","person_mobile_quhao":"0086","person_mobile":"","totalid":"0","tradeid":"1000","person_job_now":"人力资源总裁\\/副总裁\\/总监","person_user_type":"1001","person_reg_url":"http:\\/\\/www.job1001.com\\/","person_idate":"2017-07-14 04:28:07","ip":"27.184.169.160","person_reg_type":"3","person_zw":"高级人力资源管理师","person_gznum":"11.0","person_company":"","person_pic":"http:\\/\\/img106.job1001.com\\/upload\\/faceimg\\/20170714\\/62b323ac2ed292a76897ed3c22fb0e97_1500002265.jpeg","person_pic_personality":"","person_nickname":"","person_signature":""}}}', )
[ EntySoap ] before request: array ( 'url' => 'https://openapi.job1001.com/video/courseCatelog', 'data' => '{"job1001_param_auto_0":"127401"}', 'headers' => array ( 0 => 'Connection: keep-alive', 1 => 'Accept-Encoding: gzip, deflate', 2 => 'SYS: GUIZHOU,BIG_DATA,', 3 => 'Date: Wed 13 May 2026 19:39:39 GMT', 4 => 'Content-Type: application/json', 5 => 'Auth: Qkdz9LjyR2iBQ941 yl1001 : /MXZBp2BJYvk+RxuyedEesqoUJs=', ), 'conn_timeout' => 5, 'timeout' => 3, )
[ EntySoap ] result: array ( 'report' => array ( '请求响应码' => 200, '请求响应类型' => 'application/json; charset=utf-8', '请求总耗时' => '0.182504', '域名解析' => '0.006894', 'TCP连接' => '0.000362', '传输前耗时(SSL?)' => '0.008190', '服务接收及处理' => '0.167002', '结果接收' => '0.000056', '本地端口' => 35742, '请求数据字节' => 33.0, '结果接收字节' => 836.0, ), 'response' => '{"status":"OK","code":200,"status_desc":"","info":[{"article_id":"3301500017330830","title":"HR工作中常见EXCEL错误应用及解决办法","_media":[{"id":"6521500017330403","article_id":"3301500017330830","grpid":"0","type":"2","src":"https:\\/\\/yl1001-video.yl1001.com\\/live.yl1001.com\\/luzy\\/qitao\\/hrexcelcuowu.mp4?_upt=6bea08781778719185","tourl":"\'\'","title":"HR工作中常见EXCEL错误应用及解决办法","info":"http:\\/\\/img106.job1001.com\\/upload\\/adminnew\\/2017-07-14\\/1500020185-8FI30GD.jpg","udate":"1500017330","orderby":"0","stat":"1","file_swf":"","file_html":"","file_pages":"3972","file_pic_wh":"225704723","can_show":"0","can_down":"0","transcode_status":"0","is_media_chang":"0","tencent_src":""}],"media_type":"2","homeworkArr":null,"play_time":0}],"pageparam":{"page":0,"pages":0,"page_size":300,"sums":1}}', )
[ VIEW ] /usr/www/democg.job1001.com/application//study/view/default/index/lesson_detail.html [ array ( 0 => 'module', 1 => 'controller', 2 => 'action', 3 => 'webTitle', 4 => 'islogin', 5 => 'personTopArr', 6 => 'lessonInfo', 7 => 'lecturerInfo', 8 => 'lessonList', 9 => 'title', 10 => 'keywords', 11 => 'description', ) ]

0.357480s

HR工作常见Excel错误应用及解决办法

导师介绍

齐涛

报名

报名填写！