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ؤŷ 6
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%
                   - Ҥ͡ûСͺ, áҧѹ, Ӫ-
سҴǹŴѡٵŧ¹ / ͡͡Ẻҹҧŧ¹


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



ѡٵ÷Ѵ֡ͺ Public Training

22-23 Ҥ 2562...õǨԴкúäسҾ кèѴǴ : Internal Audit - ISO 9001:2015 & ISO 14001:2015
23 Ҥ 2562...Perfect English writing and effective e-mail writing skill : ѲѡҾ¹ѧ㹷ӧҹ ੾ E-mail
23 Ҥ 2562...Excel Advanced for Special Functions
23 Ҥ 2562...طèѴԹҵҧ
23 Ҥ 2562...þѲҺؤԡҾѡҹ ͤ稢ͧͧ
24 Ҥ 2562...ҧԵӹ֡ԡ÷СþѲҷѡ˹ҧҹ
24 Ҥ 2562...طԴẺѺѡ·֡ (Ѻѡ ͧѡз֡)
24 Ҥ 2562...Leadership : ӷԷҾ
25 Ҥ 2562...ѡҾŢҹءؤ Ҫվк͡äúǧ (Smart Secretary Towards Document Control System)
25 Ҥ 2562...ûԺѵԧҹ㹤ѧԹСúèѴԹ
25 Ҥ 2562...ѡⴹ١
27 Ҥ 2562...Project Feasibility Analysis : ͧç
27 Ҥ 2562...ҧѸշҧѾҧзѺͻªҧáԨ (-ѧ) (Win-Win by Smart THAI - ENGLISH Telephone Conversation as Profitable Business Tool)
28-29 Ҥ 2562...Smart ENGLISH Communications Skills Towards AEC (...ҧշѡ...ѧ)
29 Ҥ 2562...ҧçҹѹ͡úçҹͧ
30 Ҥ 2562...෤ԤҤѴ͡ Ք ҧҪվ
31 Ҥ 2562...ԹѺ÷ѡԹ Finance for Non-Finance
31 Ҥ 2562...úáüԵѺ˹ҧҹؤŴ鹷عԷҾ
31 Ҥ 2562...úä§ (Risk Management)
3 Զع¹ 2562...ǷҧâѺ͹ سҢͧҔ ҧջԷԼ (Effective Time Management)
5 Զع¹ 2562...͡ẺоѲкҹ HRIS حӤѭ㹡úäؤ 4.0
5 Զع¹ 2562...Update...¤ͧçҹѺ 2562 (¤ͧçҹѺ Сǹ¨ҧͧѺҧ..?)
5 Զع¹ 2562...èѴ COMPETENCY DICTIONARY MODELING ;Ѳͧ
5-6 Զع¹ 2562...úͧͧ ù-͡ : Ըաšҡ ¹ŧѡࡳ ...šҡ Ѻ
6 Զع¹ 2562...þѲҺؤԡҾС͡÷ӧҹ
6 Զع¹ 2562...Ѻ͹ͧҧ׹к OKRI (OKR + KPI)
6 Զع¹ 2562...ʹẺ Top Sales ѧؤ 4.0 (Impressive Increase Sales in Top Sales with Selling 4.0)
6 Զع¹ 2562...ҧἹСäǺüԵԧط (Strategic Production Planning & Controlling)
6 Զع¹ 2562...෤Ԥúѹ֡ѡ¹§ҹûЪ
7 Զع¹ 2562...֡...úçҹؤ - ֡ - ԧ - 任Ժѵԧ
7 Զع¹ 2562...෤Ԥâ͡Ҫվ෾ (Ѻѡҹ·ءдѺ)
7 Զع¹ 2562...ҧҭҴͤ稢ͧͧ
8 Զع¹ 2562...ѡҾŢҹءؤ Ҫվк͡äúǧ (Smart Secretary Towards Document Control System)
8 Զع¹ 2562...Ըա¹áԨѧẺҪվ (How to write business emails in English professionally)
8 Զع¹ 2562...úçҹèѴԹŴ鹷عԷҾ
10 Զع¹ 2562...èҵͧлԴâѺѡ Gen Y
11 Զع¹ 2562...ѡҾŢҹء 㨡áþٴѧ (Smart Secretary Towards Effective Speaking English Skill) article
11 Զع¹ 2562...෤Ԥè⺹ & ûѺԹ͹Шӻ
11 Զع¹ 2562...Microsoft Excel Pivot Table & Pivot Chart
12 Զع¹ 2562...Super Admin çҹáҧ㨾ѡҹ
12 Զع¹ 2562...ҹѺɳҹ
12 Զع¹ 2562...èѴûѭҧҪվ (Root Cause Analysis Management)
13 Զع¹ 2562...෤ԤèѴ Visual Control 㹡кǹüԵ ԷҾ
13 Զع¹ 2562...ѡСѧС÷ӧҹҾѡɳҧҪվ
14 Զع¹ 2562...èѴäѧԹ/ФǺʵ͡ؤ 4.0 (Warehousing/Stock Management and control for 4.0)
14 Զع¹ 2562...ط ¼Ô ؤҧջԷҾ
15 Զع¹ 2562...Speaking and listening with effective grammar ÿѧоٴ´෤Ԥ෾
15 Զع¹ 2562...ѭ١ҵСʹ (Customer Complaint & Upselling)
18 Զع¹ 2562...طèҵԴǧ˹ҧѾҧ
18 Զع¹ 2562...෤Ԥ ԸѡԹ (Withholding Tax) ѺèԹ 12 ó
18 Զع¹ 2562...˹ҧҹҪվ (The Supervisory HERO)
19 Զع¹ 2562...ҧ DCC Ҫվ෾ҧ ͧ
19 Զع¹ 2562...ҧἹ觫ѵشԺҧջԷҾ (Effective Raw Material Planning)
19 Զع¹ 2562...ûءкǪѴ KPI
20 Զع¹ 2562...ǷҧâѺ͹Ѳͧ 4.0 ҹ
20 Զع¹ 2562...ú÷ҹ͡еʹ
21 Զع¹ 2562...úä§ Risk Management кúäسҾ ISO 9001:2015
21 Զع¹ 2562...ҵͺ᷹ʴԡ״͡ѡШ٧㨤ؤ 4.0 (Remuneration Fixable Designing for Retain and Motivation)
21 Զع¹ 2562...֡ѡ Թ͹ Ҩҧʴԡþѡҹ HR
21 Զع¹ 2562...ҧἹФǺüԵҧջԷҾ : Production Planning & Control
21 Զع¹ 2562...͡§ٴпѧ§ѧҧջԷҾ (Pronunciation and Phonetics) (ѡٵѴ)
22 Զع¹ 2562...úŨʵԡСطŴ鹷عҧáԨ͡觢ѹ (Logistic Management 4.0)
22 Զع¹ 2562...ѡҾŢҹءؤҪվ кҹáÔ (Smart Secretary Towards Administrator)
24-25 Զع¹ 2562...Intermediate Excel for Database and Special Functions
25 Զع¹ 2562...ԵԷҡúСè٧١ͧ (The Powerful Psychological Excellency Skills for Management Leadership Competencies)
25 Զع¹ 2562...෤ԤâҧҪվʹ (Sales and Professional Technique to Increase Sales)
26 Զع¹ 2562...Դظҧѭ QMR
26 Զع¹ 2562...Incoterms ® 2010 ͺѧѺҧäҧ
26 Զع¹ 2562...KYT ͤʹ㹡÷ӧҹ
27 Զع¹ 2562...Ѻúçҹǫյк ISO 9001:2015
27 Զع¹ 2562...ػ繡ûѺا ... ͧçҹ Ѻ
27 Զع¹ 2562...¹ͻԺѵԧҹ
27-28 Զع¹ 2562...Basic & Advance International Material Data System : IMDS
28 Զع¹ 2562...طáâԹ˹ҹ
28 Զع¹ 2562...СèѴâͧ¹١ҧҪվ (Professional Service Communication & Complaint Management)
29 Զع¹ 2562...ѡҾŢҹءؤ Ҫվ...úáûЪ (Smart Secretary Towards Effective Meeting Management)
1 áҤ 2562...෤Ԥú article
3 áҤ 2562...͡˹äǺû͹㹼ԵѳѺصˡҹ¹ صˡ俿-硷͹ԡ (SOC, RoHS, REACH/SVHC, ELV, PFOS/PFOA, DMF)
4-5 áҤ 2562...෤ԤèѴçҧԹ͹СúäҨҧ (ҤԺѵ)
5 áҤ 2562...úáüԵҧջԷҾ
6 áҤ 2562...ѡҾŢҹءؤҪվ кҹáÔ (Smart Secretary Towards Administrator)
9 áҤ 2562...Ѻúçҹؤŵк ISO 9001:2015
10 áҤ 2562...ҧἹسҾԵѳǧ˹ APQP (Advanced Product Quality Planning)
11 áҤ 2562...͹ѵԪǹüԵ PPAP (Production Part Approval Process)
11 áҤ 2562...SALE FOR NON SALES ¢
12 áҤ 2562...෤Ԥ觻¤ѧѺӧҹԸա͹෾...鹰ҹ
13 áҤ 2562...ѡҾŢҹءؤ Ҫվ...úáûЪ (Smart Secretary Towards Effective Meeting Management)
19-20 áҤ 2562...èѴäѧԹ/ФǺʵ͡ ؤ 4.0 (Ѻ) (Warehousing/Inventory Management & Control for 4.0 (Intensive Edition))
20 áҤ 2562...ѡҾŢҹء 㨡áþٴѧ (Smart Secretary Towards Effective Speaking English Skill)
25 áҤ 2562...èѴǴСûͧѹžɷ׹ 3R
27 áҤ 2562...ѡҾŢҹءؤ Ҫվк͡äúǧ (Smart Secretary Towards Document Control System)
30 áҤ 2562...෤Ԥùʹͧҹ ѡͧ Сõդ (ѺѡҹءдѺ)
6 ԧҤ 2562...þѲҷѡС˹ҧҹԷҾͧ
9 ԧҤ 2562...Service mind ¡дѺúԡ˹ͪ
10 ԧҤ 2562...ѡҾŢҹءؤ Ҫվ...úáûЪ (Smart Secretary Towards Effective Meeting Management)
17 ԧҤ 2562...ѡҾŢҹءؤ Ҫվк͡äúǧ (Smart Secretary Towards Document Control System)
21 ԧҤ 2562...¡дѺûСѹسҾ㹼ԵѳСкǹüԵ QA Network
23 ԧҤ 2562...ҧἹФǺüԵҧջԷҾ : Production Planning & Control
26 ԧҤ 2562...෤Ԥâ·ҧѾҧջԷҾ (ѺἹЫѾ췡â·ͧ·ҧѾ)
30 ԧҤ 2562...ѲҡкؤԡҾ (ѺءἹ ء˹)
31 ԧҤ 2562...ѡҾŢҹء 㨡áþٴѧ (Smart Secretary Towards Effective Speaking English Skill)
4 ѹ¹ 2562...طҧἹФǺüԵ (Strategic for Production Management)
5 ѹ¹ 2562...ûԹҧҹͺäçҹ
5 ѹ¹ 2562...෤Ԥâ͡Ҫվ෾ (Ѻѡҹ·ءдѺ)
12 ѹ¹ 2562...úŨʵԡСطŴ鹷عҧáԨ͡觢ѹ (Logistic Management 4.0)
14 ѹ¹ 2562...ѡҾŢҹء 㨡áþٴѧ (Smart Secretary Towards Effective Speaking English Skill)
17 ѹ¹ 2562...ҹѺɳҹ
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



Copyright © 2013 All Rights Reserved.