Excel 㹧ҹ HR,ͺ,繫 ù
ReadyPlanet.com
dot dot
bulletIn-house Training
bulletԡèѴԨ Walk Rally
dot
Ǣ/ѡٵõҧ

dot
bulletԷҡ
ͺŴ͹ 200%
dot
Ѻ

dot
dot
ʶҹѴ
dot
bulletçૹ آԷ 26
bulletçë آԷ .26
bulletçԹԵ آԷ .23
bulletçù آԷ .4-6
bulletç آԷ .5
bulletçԻ .ط
bulletç ҫ
bulletἹçŴ Դ
bulletٹЪ Ф͹礪
dot
ѤҪԡ
ͼ :
ʼҹ :
кѵѵ :
bullet ʼҹ
bullet ѤҪԡ
dot
Ҫԡ
bulletNuetiie
Ҫԡ袳й 1
Ҫԡ Log in
ѧҪԡ͡Թ㹢й
bulletؤŷ 10
dot
˹ѧóŻ/Ե Ѫء
˹ѧͤ͢Դäӹ֧/Ե Ѫء
ѺѤԷҡ
bulletѡٵ Public Training


ԡèѴ Walk Rally, In-house Training ҤҾ
ԡ͡Ẻ觾
ҪԨҹມ

ٻẺͧ÷ӡԨ Outing  Training
ԭ٪
Դͺҡȡ ͧ 繫 ù
᡹͵Դ繫շҧ Line


18 Ҥ 2562...Excel 㹧ҹ HR

 

ѹ 18 Ҥ 2562   ʶҹ :  ç آԷ 26 

ѡ˵ؼ :

          ¹ MS Excel ֡֡ŧѡɳЧҹ 觷ԴþѲкҹѨغѹջԷҾ觢 ੾С͡Ẻкҹѵѵ ö任ءѺҡѡɳЧҹ ҹ÷Ѿҡ Human Resource Management : HR 繧ҹǢͧѺؤҡ ҧἹѧ ФѴ͡ ý֡ͺоѲѡҾ ûԹšûԺѵԧҹ úäҵͺ᷹ кʹȷѾҡ (HRIS) 觷 㹻Ѩغѹöͷá㹷ءкǹ Ҩ繡Ϳٻ੾Чҹ ͡ûء MS Excel

          ѡٵùͺ繵ҧͧûء MS Excel 㹧ҹ HR 繵ҧͧҧ͹䢡äӹdz Ѿѧѹͧҹ HR ¹¹ٵäӹdz ¹Ҩоٴ§ǡѹ “Excel ?” ֡ԺѵԨԧѺҧѡɳеҧ йӢͧԷҡзҹ


Ӷѡٵù դӵͺ

           ѷվѡҹ§褹 ҡԹٻ ֧ͧ Excel ͡èѴðҹžѡҹ ҺҨз? ҧ?

ͧ÷йʹ͢ẺػѺ ͹䢵Ţѡ¹ŧ Ը㴺ҧ Excel ػѵѵ ͹䢵Ţ¹ŧ

 §ʾѡҹŧ ǵͧ Excel ʴ´Ţͧѡҹ͡?

ͧʴاҹ ѹѨغѹѵѵ ءԴ?

зҧ? ҵͧ͡˹ѧѺͧԹ͹Ѻѡҹ

 Ẻҹ 繨ӹǹҡ 觵ͧҧء зҧôŴФҡç

 Һ Excel դö㹡äӹdzʹ ¹ѡٵäӹdz «˹ѧҹ յҧçѺҹͧ HR

 բӴ Excel 纪йʡŢͧѡҹ㹪ͧǡѹ ͧ÷¡͡ҡѹ繤Ф ª;ѡҹ¤ Ը˹ҧзǡҡҾФ

 ˹ҷ褹ӡ红žѡҹẺ¡´ҡ ʡ ҹŢ ѧѴ ͧ÷ѹ ͡Ѻʡ ҹŢѺ ͡ѺѧѴ ͻѴͷҾͧ¨зҧ

աҡ 觤Ӷҧ ҹ س龺ӵͺ 駵ҧԧ سöͧ йӡѺ㹡÷ӧҹͧس

Ǣ͡ͺ

           ¹öͧ Excel

¹ٵ Т;֧Ԩó㹡¹ٵäӹdz Excel

ӴѺӤѭ㹡äӹdzͧ Excel

ѧѹ鹰ҹѺ Excel 㹧ҹ HR

    o ѧѹҹѹ

 ѹ DATE, YEAR, MONTH, DAY, WEEKDAY, TODAY

TIME, HOUR, MINUTE, NOW

    o ѧѹҹͤеѡ

 ᷹ͤ FIND, SEARCH, SUBSTITUTE

֧ѡкҧǹ͡ҡͤ LEFT, RIGHT, MID

    o ѧѹҹԵʵФӹdz

 Ҽ SUM, SUMIF, SUMPRODUCT

ӹǹзȹ INT, CEILING, FLOOR, ROUND

    o ѧѹҹäҧԧ

 Ң VLOOKUP, INDEX, MATCH

ҧԧ˹觢 ROW, ROWS, COLUMN, COLUMNS

    o ѧѹҹʶԵ

 ùѺӹǹ COUNT, COUNTA, COUNTIF

èѴӴѺ MAX, MIN, LARGE, SMALL, AVERAGE

Ҽ СùѺӹǹ Ẻ͹ (1 ͹ ҡ 1 ͹)

 Żѹ Excel СäӹdzǡѺѹ

 ҧҧҹžѡҹͧ

 ֡Ժѵ (Workshop) o ҧҧ͹ ͤú˹ͧҹ

    o اҹẺѵѵ ԷѹҾѡ͹Шӻյاҹ

    o äӹdzҷӧҹ Ѻ͹ Фǧ

    o ҧ͹㹡äӹdz (IF-Conditional)

    o ҧ¡͡ (List)

    o ÷ẺԻԹ͹ С§Ũҡҹ

    o ÷Өԭɳҹ, ˹ѧ͹ ˹ѧѺͧ Mail Merge

    o

 йӵҧ Excel 㹡úäҵͺ᷹ʴԡ

 йӵҧ ҧ§ҹػШ͹ (HRIS Monthly Report)

Էҡ : Ҩԧ 觶آ

          ʺó Ѵý¾ѲҸáԨ (Business Development Manager) ѷ Һš ҡѴ
          üѴúѷ -ͪ Թ ෤ ҡѴ
          üѴúѷ ͪ ê ҡѴ

 

ͺ/ҹ

Ҥҡ͹ Vat

Vat7%

ѡ
3
%

Ҥط

óժԹ˹ҧҹ

3,900

273

(117)

4,056

¡͹ 12 Ҥ 2562

3,600

252

(108)

3,744

 ˵     - ŧ¹öŴ͹ԹԵԺؤ  200%
                   - Ҥ͡ûСͺ, áҧѹ, Ӫ-
سҴǹŴѡٵŧ¹ / ͡͡Ẻҹҧŧ¹


/˹ :
Name/Surname :
ѾͶ :
/˹ :
Name/Surname :
ѾͶ :
/˹ :
Name/Surname :
ѾͶ :
/˹ :
Name/Surname :
ѾͶ :
/˹ :
Name/Surname :
ѾͶ :
ǹ/ѷ : 㹹ǹ
ѷ/ʶҹСͺ
ͺѷ/ʶҹСͺ :
ŢШӵǼ :
سк : ӹѡҹ˭
Ң
Ңҷ :
͡ :
áԨ :
ͧѡ : ͧ
ͧ
͡ҤѺ͹Թ : Ҥ¾ҳԪ ҢѧԵ Ţѭ 364-236239-5
Ҥáԡ Ңҿ ѧԵ 2 Ţѭ 022-3-65013-9
ҹҹ :  *
ŢѾͶ :  *
Ѿ :  *
:
ѭҷҹͧ÷Һ繾ͧ
Ѥ :
Ṻ͡á͹Թ :



ѡٵ÷Ѵ֡ͺ Public Training

16 Ҥ 2562...ѡйѡҪվ
16 Ҥ 2562...èѴáâҧջԷҾ (Effective Transportation Management)
17 Ҥ 2562...Update¤ͧçҹ Ѻ 2562 : ¤ͧçҹѺС..¨ҧͧѺҧ..?
17 Ҥ 2562...Դظҧѭ QMR
17-18 Ҥ 2562...Basic & Advance International Material Data System : IMDS
17 Ҥ 2562...෤Ԥú
18 Ҥ 2562...Finance for Non-Finance Managers
18 Ҥ 2562...ԵԷ ÷ӧҹ繷 Фͧ Ẻ Win Win
18 Ҥ 2562...úçҹؤŷ˹ҧҹ (HR FOR NON HR)
19 Ҥ 2562...෤ԤèҵͧѺҹ
22 Ҥ 2562...ԷҾкǹüԵ DOJO Training System
24 Ҥ 2562...Ţҹءü¼ 4.0
24 Ҥ 2562...Microsoft Excel Pivot Table & Pivot Chart
25 Ҥ 2562...л...èҧçҹҧҧ١ MOU
25 Ҥ 2562...ҧἹФǺüԵҧջԷҾ : Production Planning & Control
25 Ҥ 2562...ѺúçҹѴ к ISO 9001:2015
25 Ҥ 2562...úüŧҹºçѧ OKRs : Objectives & Key Results
28 Ҥ 2562...طèѴԹҵҧ article
28-29 Ҥ 2562...Advanced Excel for Special Macro & VBA
29 Ҥ 2562...40 çҹ HR ͧ
29 Ҥ 2562...кǹ͡ ù оԸաšҡ
29 Ҥ 2562...෤Ԥҹ짺ԹѺ÷ ѡѭՔ
29 Ҥ 2562...Ѻ úèѴ ؤ 4.0 Ҫվ (Secretness of Smart Organization By 4.0 Management Skills)
30 Ҥ 2562...Ѻúçҹǫյк ISO 9001:2015
30 Ҥ 2562...СèѴâͧ¹١ҧҪվ (Professional Service Communication & Complaint Management)
30 Ҥ 2562...ûԺѵԧҹ㹤ѧԹСúèѴԹ
30 Ҥ 2562...෤ԤâҧҪվʹ (Sales and Professional Technique to Increase Sales)
31 Ҥ 2562...Incoterms ® 2010 СèѴ͡áäҧ
31 Ҥ 2562....SALE FOR NON SALES ¢
1 Ȩԡ¹ 2562...úçҹèѴԹŴ鹷عԷҾ
4 Ȩԡ¹ 2562...͡Ԩ ͡żԵŴ鹷ع Ѻ÷ӧҹ (Effectiveness of Productivity tools selection)
4 Ȩԡ¹ 2562...طôҹ¹(ѧ) ѹ֡Ш¸áԨ Դ (Effective English Writing Communications for Memo and Business Letter and E-mail)
4 Ȩԡ¹ 2562...Service mind ¡дѺúԡ˹ͪ
5 Ȩԡ¹ 2562...ѡСҹ١ͧ͡ͺ§ҹ
5 Ȩԡ¹ 2562...çҹ˹ҧҹ (HR Law Update : 2019)
5 Ȩԡ¹ 2562...෤Ԥè⺹ & ûѺԹ͹ Шӻ 2019/20
6 Ȩԡ¹ 2562...Ѻ DCC õк ISO 9001:2015
6 Ȩԡ¹ 2562...ѡҾҹáẺúǧ
6 Ȩԡ¹ 2562...úáüԵѺ˹ҧҹؤŴ鹷عԷҾ (Production Management for Cost reduction and Efficiency improvement)
6 Ȩԡ¹ 2562...Basic Leader
8 Ȩԡ¹ 2562...ҧἹسҾԵѳǧ˹Скǹ͹ѵԪǹüԵ (APQP & PPAP)
13 Ȩԡ¹ 2562...ѺäǺ͡ Document Control к ISO 9001:2015
13 Ȩԡ¹ 2562...෤Ԥúçҹ HR / ԡҧ / 骹Ф
14 Ȩԡ¹ 2562...ѡйѡҪվ
15 Ȩԡ¹ 2562...෤ԤõǨԴ к ISO 9001:2015
16 Ȩԡ¹ 2562...èѴäѧԹ/ФǺʵ͡ؤ 4.0 (Warehousing/Stock Management and control for 4.0)
18 Ȩԡ¹ 2562...Excel Advanced for Special Functions
19 Ȩԡ¹ 2562...ѺèѴ Objective & Target ǷҧԺѵԨԧؼ
19 Ȩԡ¹ 2562... ѡС¹§ҹ ()
19 Ȩԡ¹ 2562...˹ҧҹҪվ (The Supervisory HERO)
20 Ȩԡ¹ 2562...ҹ㨼Ѥçҹ (Read one's mind)
20-21 Ȩԡ¹ 2562... ù-͡ коԸաšҡ顮šҡéѺ
20-21 Ȩԡ¹ 2562...෤ԤèѴçҧԹ͹СúäҨҧ (ҤԺѵ)
21 Ȩԡ¹ 2562...úкҹ͡Ẻúǧ
21 Ȩԡ¹ 2562...èҵͧâҧҪվ (Professional Sales Negotiation)
22 Ȩԡ¹ 2562...ǻԺѵ Incoterms ® 2010 Payment Terms ѺèѴ͵ҧ
22 Ȩԡ¹ 2562...¹áԨѧẺҪվ
26 Ȩԡ¹ 2562...úͧ..ͧ..ISO 9001:2015 ҡ͡˹.. ǷҧԺѵԨԧ..繼
26 Ȩԡ¹ 2562...෤Ԥùʹͧҹ ѡͧ Сõդ (ѺѡҹءдѺ)
26 Ȩԡ¹ 2562...ԵԷҡúСè٧١ͧ (The Powerful Psychological Excellency Skills for Management Leadership Competencies)
27 Ȩԡ¹ 2562...KYT ͤʹ㹡÷ӧҹ
28 Ȩԡ¹ 2562...෤ԤèҷǧѴ˹ҧջԷҾ (Effective Collection Call)
3 ѹҤ 2562...Ŵ鹷عͧ
3 ѹҤ 2562...෤ԤõǨѺԹԷҾ
11 ѹҤ 2562...Ѻúçҹǫյк ISO 9001:2015
13 ѹҤ 2562...úä§ Risk Management кúäسҾ ISO 9001:2015
18 ѹҤ 2562...Ѻúçҹؤŵк ISO 9001:2015
20 ѹҤ 2562...Դظҧѭ QMR
20 ѹҤ 2562...èҵͧлԴâѺѡ Gen Y
20 ѹҤ 2562...شʹѡԧء (Super Proactive Sales)



Copyright © 2013 All Rights Reserved.