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

简介
目录

课程简介

课程说明： Excel函数有三四百个，是不是听到很头大？函数这么多，该从哪开始学起？ HR要用函数解决工作中的问题，需要掌握多少函数？其实学习5个必备函数就能解决工作中大部分问题。本课程带你学习HR必须掌握的5个函数，通过工作实例来讲解函数应用，脱离学习函数的烦恼。课程目录： 1、IF函数 2、SUMIF函数 3、COUNTIF函数 4、DATEDIF函数 5、VLOOKUP函数

课程目录

导师介绍

齐涛

高级人力资源管理师

基本文件流程错误 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' => '127400', )
[ 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":"127400"}', 'headers' => array ( 0 => 'Connection: keep-alive', 1 => 'Accept-Encoding: gzip, deflate', 2 => 'SYS: GUIZHOU,BIG_DATA,', 3 => 'Date: Wed 13 May 2026 19:40:16 GMT', 4 => 'Content-Type: application/json', 5 => 'Auth: Qkdz9LjyR2iBQ941 yl1001 : j3GojKLRPcE9DmMOWw01HKT64v4=', ), 'conn_timeout' => 5, 'timeout' => 3, )
[ EntySoap ] result: array ( 'report' => array ( '请求响应码' => 200, '请求响应类型' => 'application/json; charset=utf-8', '请求总耗时' => '0.100477', '域名解析' => '0.009276', 'TCP连接' => '0.000437', '传输前耗时(SSL?)' => '0.007642', '服务接收及处理' => '0.083058', '结果接收' => '0.000064', '本地端口' => 35802, '请求数据字节' => 33.0, '结果接收字节' => 2301.0, ), 'response' => '{"status":"OK","code":200,"status_desc":"","info":{"group_id":"127400","group_person_id":"21144489","group_name":"HR 必须掌握的5个函数","group_code":"594900","tradeid":"0","totalid":"0","group_pic":"http:\\/\\/img106.job1001.com\\/upload\\/group_pic\\/group\\/127400.jpg?1589860055","group_background":"http:\\/\\/img106.job1001.com\\/upload\\/adminnew\\/2017-07-14\\/1500024474-63C01LZ.jpg","group_intro":"课程说明：\\nExcel函数有三四百个，是不是听到很头大？\\n函数这么多，该从哪开始学起？\\nHR要用函数解决工作中的问题，需要掌握多少函数？\\n其实学习5个必备函数就能解决工作中大部分问题。\\n本课程带你学习HR必须掌握的5个函数，通过工作实例来讲解函数应用，脱离学习函数的烦恼。\\n\\n课程目录：\\n1、IF函数\\n2、SUMIF函数\\n3、COUNTIF函数\\n4、DATEDIF函数\\n5、VLOOKUP函数","group_audit_status":"5","sys_status":"0","group_open_status":"3","group_person_cnt":"9","group_article_cnt":"","group_member_cnt_limit":"1000","idatetime":"2017-07-14 15:15:16","updatetime":"2017-07-18 10:54:54","checktime":"2019-09-03 17:03:34","group_tag_names":"","zwid":"0","zwname":"","istj":"1","updatetime_act_last":"2020-05-19 11:47:21","group_show_grcode":"1","group_number":"594900","sysUpdatetime":"2020-05-19 11:47:34","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":"7071500016516969","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":"127400"}', 'headers' => array ( 0 => 'Connection: keep-alive', 1 => 'Accept-Encoding: gzip, deflate', 2 => 'SYS: GUIZHOU,BIG_DATA,', 3 => 'Date: Wed 13 May 2026 19:40:16 GMT', 4 => 'Content-Type: application/json', 5 => 'Auth: Qkdz9LjyR2iBQ941 yl1001 : 8WvL6MjylVE59hP8SF7msBoy1zY=', ), 'conn_timeout' => 5, 'timeout' => 3, )
[ EntySoap ] result: array ( 'report' => array ( '请求响应码' => 200, '请求响应类型' => 'application/json; charset=utf-8', '请求总耗时' => '0.186213', '域名解析' => '0.010995', 'TCP连接' => '0.000478', '传输前耗时(SSL?)' => '0.006360', '服务接收及处理' => '0.168246', '结果接收' => '0.000134', '本地端口' => 35806, '请求数据字节' => 33.0, '结果接收字节' => 789.0, ), 'response' => '{"status":"OK","code":200,"status_desc":"","info":[{"article_id":"7911500017269823","title":"HR必须掌握的5个函数","_media":[{"id":"5351500017269655","article_id":"7911500017269823","grpid":"0","type":"2","src":"https:\\/\\/yl1001-video.yl1001.com\\/live.yl1001.com\\/luzy\\/qitao\\/hr5hanshu.mp4?_upt=399d476e1778719222","tourl":"\'\'","title":"HR必须掌握的5个函数","info":"http:\\/\\/img106.job1001.com\\/upload\\/adminnew\\/2017-07-14\\/1500020226-49FNATW.jpg","udate":"1500017269","orderby":"0","stat":"1","file_swf":"","file_html":"","file_pages":"7102","file_pic_wh":"252775033","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.374339s

HR 必须掌握的5个函数

导师介绍

齐涛

报名

报名填写！