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
Ҫԡ
Ҫԡ袳й
Ҫԡ Log in
ѧҪԡ͡Թ㹢й
bulletؤŷ 7
dot
˹ѧóŻ/Ե Ѫء
˹ѧͤ͢Դäӹ֧/Ե Ѫء
ѺѤԷҡ
bulletѡٵ Public Training


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

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


27 չҤ 2562...Excel 㹧ҹ HR

 

ѹ 27 չҤ 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

¡͹ 21 չҤ 2562

3,600

252

(108)

3,744

 

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


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



ѡٵ÷Ѵ֡ͺ Public Training

20 չҤ 2562...Ѻ úèѴ ؤ 4.0 Ҫվ (Secretness of Smart Organization By 4.0 Management Skills)
20 չҤ 2562...෤Ԥ ԸѡԹ (Withholding Tax) ѺèԹ 12 ó
20 չҤ 2562...ԷҾ÷ӧҹ Horenso ( ҹҹ §ҹ Сû֡)
20-21 չҤ 2562...͡˹ͧкúäسҾ ISO 9001 version 2015
21 չҤ 2562...طèѴԹҵҧ
21 չҤ 2562...͹ҹẺ On The Job Training
21 չҤ 2562...Train the Trainer ෤ԤԷҡҪվ
21-22 չҤ 2562...Project Management and Evaluation
22 չҤ 2562...֡ѡ Թ͹ Ҩҧʴԡþѡҹ HR
22 չҤ 2562...úä§Ẻóҡ (Enterprise Risk Management)
23 չҤ 2562...ú÷ͤ
25-26 չҤ 2562...úͧͧ ù-͡ : Ըաšҡ ¹ŧѡࡳ ...šҡ Ѻ
25-26 չҤ 2562...Intermediate Excel for Database and Special Functions
26 չҤ 2562...úüŧҹºçѧ OKRs : Objectives & Key Results
26 չҤ 2562...èҵͧлԴâѺѡ Gen Y
26 չҤ 2562...Ţҹء㹰ҹм¼ 4.0
27 չҤ 2562...෤Ԥâ͡Ҫվ෾ (Ѻѡҹ·ءдѺ)
27 չҤ 2562...觧ҹ ͺ§ҹ СõԴҹ (Directing, Delegation and Monitoring Skills)
27 չҤ 2562...෤ԤèѴСèҵͧѴ͓ѴҧسҾ 鹷ع ôՔ
28 չҤ 2562... µç
29 չҤ 2562...èҵͧҧҪվ (Professional Negotiation Skills) article
1 ¹ 2562...֡...ԧ Ѻ͡ẺǪѴŧҹ SMART KPIs
2 ¹ 2562...úçҹԷԼŴ鹷ع㹡÷ӧҹѡ 4M
3 ¹ 2562...ҧѵżԵ㹡÷ӧҹ (Innovation to increase productivity in your work)
4 ¹ 2562...СúԹҤѧ (Beer Game & Inventory Management)
4 ¹ 2562...෤Ԥúѹ֡ѡ¹§ҹûЪ article
5 ¹ 2562...¹ E-Mail ѧ article
5 ¹ 2562...SALE FOR NON SALES ¢
9 ¹ 2562...෤ԤâѺ͹ؤԡҾ ԧԺѵ 4.0
18 ¹ 2562...͡ẺкüŧҹҧóҡʹͧѺͧ (PERFORMANCE MANAGEMENT SYSTEM INTEGRATION DESIGN)
19 ¹ 2562...෤ԤõԴ˹Сú١˹
22 ¹ 2562...ԵԷҡúСè٧١ͧ (The Powerful Psychological Excellency Skills for Management Leadership Competencies)
23 ¹ 2562...úçҹúóؤ (Work Flow Management)
24 ¹ 2562...Ţҹء㹰ҹм¼ 4.0
24 ¹ 2562...෤Ԥúçҹ HR / ԡҧ / 骹Ф
24 ¹ 2562...èѴáâҧջԷҾ (Effective Transportation Management)
25 ¹ 2562...¡дѺúԡôҹ෤Ԥ (Uplifting Technical Service)
25 ¹ 2562...Ѻ ǹش...þҡ ѧҧἹǨͺ ᾷ ѺçҺŔ
26 ¹ 2562...෤ԤâҧҪվʹ (Sales and Professional Technique to Increase Sales)
26 ¹ 2562...èѴäѧԹ/ФǺʵ͡ (Modern Warehousing/Stock Management and control)
26 ¹ 2562...Incoterms ® 2010 СèѴ͡áäҧ
26 ¹ 2562...෤ԤФѴ͡ؤҡ
27 ¹ 2562...طþٴѧç (Strategies for English speaking business)
29 ¹ 2562...෤Ԥâ·ҧѾҧջԷҾ (ѺἹЫѾ췡â·ͧ·ҧѾ)
29 ¹ 2562...ҧѸշҧѾҧзѺͻªҧáԨ (-ѧ) (Win-Win by Smart THAI - ENGLISH Telephone Conversation as Profitable Business Tool) article
30 ¹ 2562...ؤԡҾ͡â Ẻ༪ԭ˹١ : An attractive personality for Face-to-Face Selling
3 Ҥ 2562...Service mind ¡дѺúԡ˹ͪ
7 Ҥ 2562...þѲҵͧлѺاкǹ÷ӧҹջԷҾ (Effective Self Development & Work Process Improvement)
8 Ҥ 2562...ѺúçҹѴҧҧ駼š+ش + ºҧøáԨкúäسҾ ISO 9001:2015
8 Ҥ 2562...ú˹ҧҹШѹѺ˹ҧҹ¼Ե (Production and Daily Management for Supervisor)
8 Ҥ 2562...ѡҾ Ţҹءú 4.0
9 Ҥ 2562...þѲҷѡСúԡѺѡҹѺöԹ
10 Ҥ 2562...ҧʵ͹ article
10 Ҥ 2562...ҧἹСäǺüԵԧط (Strategic Production Planning & Controlling)
11 Ҥ 2562...ѧҤԺѵѺӧҹ
13 Ҥ 2562...ѡҾҹáẺúǧ
14 Ҥ 2562...˹ҧҹ ҧԵӹ֡ҧ..? ѧѺѭѡͧѺͧҹ
14 Ҥ 2562...طúäҵͺ᷹ʴԡҧժԧ
15 Ҥ 2562...èѴ§ҹ HR ԧͼ (ٵ Excel) (HR Reporting For Managerial)
15 Ҥ2562...UpdateçҹѺ (HR Law Update : 2019)
15 Ҥ 2562...èҵͧâҧҪվ (Professional Sales Negotiation)
16 Ҥ 2562...л...èҧçҹҧҧ١
17 Ҥ 2562...෤ԤèҵͧѺҹ¢٧
17 Ҥ 2562...ŻСúä㹸áԨԡ (Service People Management)
18 Ҥ 2562...English for Sales : ѧ͹ѡҪվ
21 Ҥ 2562...Ѻ...áâ㹪ԵШѹ
22 Ҥ 2562...ǷҧâѺ͹ سҢͧҔ ҧջԷԼ (Effective Time Management)
22-23 Ҥ 2562...õǨԴкúäسҾ кèѴǴ : Internal Audit - ISO 9001:2015 & ISO 14001:2015
23 Ҥ 2562...Excel Advanced for Special Functions
23 Ҥ 2562...طèѴԹҵҧ
24 Ҥ 2562...ҧԵӹ֡ԡ÷СþѲҷѡ˹ҧҹ
24 Ҥ 2562...طԴẺѺѡ·֡ (Ѻѡ ͧѡз֡)
24 Ҥ 2562...Leadership : ӷԷҾ
25 Ҥ 2562...ûԺѵԧҹ㹤ѧԹСúèѴԹ
25 Ҥ 2562...ѡⴹ١
29 Ҥ 2562...ԹѺ÷ѡԹ Finance for Non-Finance
30 Ҥ 2562...෤ԤҤѴ͡ Ք ҧҪվ
31 Ҥ 2562...䢻ѭҴ WHY WHY ANALYSIS (FINDING TECHNIQUE AND SOLVING PROBLEM BY WHY WHY ANALYSIS)
31 Ҥ 2562...úä§ (Risk Management)
4 Զع¹ 2562...͡˹äǺû͹㹼ԵѳѺصˡҹ¹ صˡ俿-硷͹ԡС͹ѡѧҹçҹصˡ (SOC, RoHS, REACH/SVHC, ELV, PFOS/PFOA, DMF)
6 Զع¹ 2562...ѲҡкؤԡҾ (ѺءἹ ء˹)
7 Զع¹ 2562...֡...úçҹؤ - ֡ - ԧ - 任Ժѵԧ
7 Զع¹ 2562...෤Ԥâ͡Ҫվ෾ (Ѻѡҹ·ءдѺ)
10 Զع¹ 2562...èҵͧлԴâѺѡ Gen Y
18 Զع¹ 2562...˹ҧҹҪվ (The Supervisory HERO)
21 Զع¹ 2562...֡ѡ Թ͹ Ҩҧʴԡþѡҹ HR
21 Զع¹ 2562...ҧἹФǺüԵҧջԷҾ : Production Planning & Control
26 Զع¹ 2562...KYT ͤʹ㹡÷ӧҹ article
28 Զع¹ 2562...СèѴâͧ¹١ҧҪվ (Professional Service Communication & Complaint Management)
4-5 áҤ 2562...෤ԤèѴçҧԹ͹СúäҨҧ (ҤԺѵ)
5 áҤ 2562...úáüԵҧջԷҾ
11 áҤ 2562...SALE FOR NON SALES ¢
25 áҤ 2562...èѴǴСûͧѹžɷ׹ 3R
30 áҤ 2562...෤Ԥùʹͧҹ ѡͧ Сõդ (ѺѡҹءдѺ)
6 ԧҤ 2562...þѲҷѡС˹ҧҹԷҾͧ
9 ԧҤ 2562...Service mind ¡дѺúԡ˹ͪ
21 ԧҤ 2562...¡дѺûСѹسҾ㹼ԵѳСкǹüԵ QA Network
23 ԧҤ 2562...ҧἹФǺüԵҧջԷҾ : Production Planning & Control
26 ԧҤ 2562...෤Ԥâ·ҧѾҧջԷҾ (ѺἹЫѾ췡â·ͧ·ҧѾ)
30 ԧҤ 2562...ѲҡкؤԡҾ (ѺءἹ ء˹)
4 ѹ¹ 2562...طҧἹФǺüԵ (Strategic for Production Management)
5 ѹ¹ 2562...ûԹҧҹͺäçҹ
5 ѹ¹ 2562...෤Ԥâ͡Ҫվ෾ (Ѻѡҹ·ءдѺ)
12 ѹ¹ 2562...úŨʵԡСطŴ鹷عҧáԨ͡觢ѹ (Logistic Management 4.0)
17 ѹ¹ 2562...ҹѺɳҹ article
24 ѹ¹ 2562...طԴẺѺѡ·֡ (Ѻѡ ͧѡз֡)
27 ѹ¹ 2562...èҵͧлԴâѺѡ Gen Y
14-15 2562...ط ¼Ô ҧҪվ (Enhancing Your SMART Personal Assistant Professional Skills)
22 Ҥ 2562...ԷҾкǹüԵ DOJO Training System
29 Ҥ 2562...Ѻ úèѴ ؤ 4.0 Ҫվ (Secretness of Smart Organization By 4.0 Management Skills)
30 Ҥ 2562...СèѴâͧ¹١ҧҪվ (Professional Service Communication & Complaint Management)
31 Ҥ 2562....SALE FOR NON SALES ¢
4 Ȩԡ¹ 2562...Service mind ¡дѺúԡ˹ͪ
5 Ȩԡ¹ 2562...úáüԵѺ˹ҧҹؤŴ鹷عԷҾ (Production Management for Cost reduction and Efficiency improvement)
26 Ȩԡ¹ 2562...෤Ԥùʹͧҹ ѡͧ Сõդ (ѺѡҹءдѺ)
3 ѹҤ 2562...Ŵ鹷عͧ
20 ѹҤ 2562...èҵͧлԴâѺѡ Gen Y
20 ѹҤ 2562...شʹѡԧء (Super Proactive Sales)
16 չҤ 2562...ͧѵѹ С·Ǣͧ ෤ԤâѺöԧͧѹغѵ˵Сúاѡ
22 Ҿѹ 2562...úͧ ͧ "ù-͡"



Copyright © 2013 All Rights Reserved.