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
Ҫԡ
bulletѷԫ ԫ١ ӡѴ
Ҫԡ袳й 1
Ҫԡ Log in
ѧҪԡ͡Թ㹢й
bulletؤŷ 37
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

18-19 Ҿѹ 2563...Basic & Advance International Material Data System : IMDS
19 Ҿѹ 2563...Supervisor IDOL ˹ҧҹ㹴ǧ
19 Ҿѹ 2563...40 çҹ HR ͧ
19 Ҿѹ 2563...ѡСôҹ¹ (ѧ)
20 Ҿѹ 2563...èѴкǺû͹ (ROHS) 㹼ԵѳѺüԵ ǹҹ¹ ǹ俿 硷͹ԡ
20 Ҿѹ 2563...Effective Presentation by PowerPoint
20 Ҿѹ 2563...ҧἹСäǺüԵԧط (Strategic Production Planning & Controlling)
20 Ҿѹ 2563...СèѴâͧ¹١ҧҪվ (Professional Service Communication & Complaint Management)
21 Ҿѹ 2563...ʴԡ- ŧ ԡҧ HR Ҵ !!!
21 Ҿѹ 2563...Service mind ¡дѺúԡ˹ͪ
21 Ҿѹ 2563...ûءͧѴ´ѺѴ鹧ҹࡳ GD&T (Application of Dimensional Precision Instruments for Principle of GD&T)
21 Ҿѹ 2563...Excel Advanced for PivotTable and Database Techniques
22 Ҿѹ 2563...ѧ㹡÷ӧҹ
24 Ҿѹ 2563...ʵŻ Ô ûЪ (Effective Meeting Towards Smart Communications)
24 Ҿѹ 2563...èѴԹҤѧ (Inventory Management) : 鹷عŴ
25 Ҿѹ 2563...෤Ԥúçҹ HR - ԡҧ - 骹Ф
26 Ҿѹ 2563...Incoterms @ 2020 ͵ŧҧäҧ
26 Ҿѹ 2563...ʵŻСúáûЪҧúǧ
27 Ҿѹ 2563...Update ¤ͧçҹѺ 2563 ¤ͧçҹѺ С...? ¨ҧͧѺҧ..?
27 Ҿѹ 2563...кǹù ͡ оԸաšҡ
29 Ҿѹ 2563...èѴäѧԹ/ФǺʵ͡ؤ 4.0 (Warehousing/Stock Management and control for 4.0)
29 Ҿѹ 2563...ԵԷ ÷ӧҹ繷 Фͧ Ẻ Win Win
2 չҤ 2563...෤Ԥͺǹ ŧɷҧԹ (Disciplinary Investigation & Interrogation)
3 չҤ 2563...äǺسҾ㹡÷ӧҹ (Quality Control @ Work)
3 չҤ 2563...෤Ԥ ҧἹҹСͺ§ҹ
4 չҤ 2563...෤ԤФѴ͡ؤҡ
5 չҤ 2563...úáüԵѺ˹ҧҹؤŴ鹷عԷҾ (Production Management for Cost reduction and Efficiency improvement)
6 չҤ 2563...þѲҺؤԡҾѡҹ ͤ稢ͧͧ
7 չҤ 2563...ط¹ѧ ͡ͺҧáԨ
9 չҤ 2563...ǷҧâѺ͹ؤԡҾԧԺѵ 4.0
10 չҤ 2563...Ŵ鹷عسҾ¡ûѺἹѡҧԵѳ AQL (MIL-STD-105E) : Quality cost reduction by Adjusting sampling plans article
10 չҤ 2563...طèѴҪվ к ISO 9001:2015
11 չҤ 2563...GMP : Good Manufacturing Practice ѡࡳԸա÷㹡üԵ
11 չҤ 2563...ҧἹѵҡѧͧѺѭçҹؤ 4.0
11 չҤ 2563...þѲ˹ҧҹ (Excellent Supervisors)
11 չҤ 2563...þѲҷѡСúԡѺѡҹѺöԹ
12 չҤ 2563...ҧἹ觫ѵشԺҧջԷҾ (Effective Raw Material Planning)
13 չҤ 2563...èѴӧҳСäǺҧջԷҾ
13 չҤ 2563...л繅èҧçҹҧҧ١ MOU
14 չҤ 2563...ǷҧâѺ͹Ѳͧ 4.0 ҹ
16 չҤ 2563...þѲ "Ҿѡɳؤ" "Դҧä" ҧ "ҹ"
17 չҤ 2563...ѡмӷ稢ͧͧ (дѺѴ)
17 չҤ 2563...طèѴŨʵԡŴ鹷ع (Logistics Strategy for Cost Reduction)
17 չҤ 2563...෤Ԥú
18 չҤ 2563...ͧǡѺԷԻªСѹѧ
19 չҤ 2563...ʹѧҧ䴷§ФѺ͹
19 չҤ 2563...ԹѺ÷ѡԹ Finance for Non-Finance
19-20 չҤ 2563...෤ԤèѴçҧԹ͹СúäҨҧ (ҤԺѵ Excel)
20 չҤ 2563...෤Ԥâ (Selling Techniques)
21 չҤ 2563...ѭ١ҵСʹ (Customer Complaint & Upselling)
24 չҤ 2563...ҧἹسҾԵѳǧ˹Скǹ͹ѵԪǹüԵ (APQP & PPAP)
25 չҤ 2563...ҭͧ (Japanese for Beginner)
25 չҤ 2563...Եӹ֡ʹСʹ 5 Why
25 չҤ 2563...Project Management Strategy : úçԧط
26 չҤ 2563...Դظҧѭ QMR article
26 չҤ 2563...෤ԤèҷǧѴ˹ҧջԷҾ (Effective Collection Call)
27 չҤ 2563...Ѻ DCC õк ISO 9001:2015
27 չҤ 2563...èѴäѧԹ/ФǺʵ͡ؤ 4.0 (Warehousing/Stock Management and control for 4.0)
27 չҤ 2563...ط¨ҧ ú 25 ʴԡÔ ѡҹ (ҤѧѺ/ҤѤ) ͡õѴ¨·ҧѭ/ͧѹѭçҹ/ѡԹ
27 չҤ 2563...ȷѡС¹§ҹ ()
28 չҤ 2563...ûԺѵԧҹ㹤ѧԹСäǺԹŴ鹷عлͧѹ÷بԵ
28 չҤ 2563...ѡҾŢҹء 㨡áþٴѧ (Smart Secretary Towards Effective Speaking English Skill)
30 չҤ 2563...úä§ : Risk Management кúäسҾ ISO 9001:2015 article
30 չҤ 2563...ôžѡҹС繾§ͧ (On Boarding & Mentoring Program)
31 չҤ 2563...شʹѡԧء (Super Proactive Sales)
1 ¹ 2563...෤Ԥѭҷ˹ҧҹ (Problem Solving and Data Analysis)
2 ¹ 2563...Ѻ稢ͧ EMR Ҫվ ѺкèѴǴ ISO 14001:2015 article
2 ¹ 2563...úçҹ HR article
3 ¹ 2563..ѺèѴ Objective & Target ǷҧԺѵԨԧؼ article
3 ¹ 2563...úкҹ͡Ẻúǧ
7 ¹ 2563...͡Ԩ͡żԵŴ鹷عѺ÷ӧҹ (Effectiveness of Productivity tools selection)
7 ¹ 2563...Basic Leader
7 ¹ 2563...SALE FOR NON SALES ¢
8 ¹ 2563...¹ѭҨҧ - ͡ºԺѵ - С ͡˹ѧ͵ҧ ¹ռŷҧµͧ¹ҧ..?
9 ¹ 2563...Integrated ISO 9001:2015 & ISO 14001:2015 : äǺкúäسҾкèѴǴҧջԷҾ article
9 ¹ 2563...෤ԤùʹͧҹҧջԷҾ : The Presenter
10 ¹ 2563...èѴкǺû͹㹼ԵѳѺüԵǹҹ¹ - ǹ俿-硷͹ԡ (SOC, RoHS, REACH, SVHC, ELV, PFOS/PFOA, DMF)
11 ¹ 2563...ѡС¹¸áԨҪ
17 ¹ 2563...úͧ ͧ "ù-͡" article
20 ¹ 2563...ѡС˹ҧҹ෾㨤ŧҹ (Development Managerial Skills for Effective Management)
21 ¹ 2563...ҵͺ᷹ʴԡ״͡ѡШ٧㨤ؤ 4.0 (Remuneration Fixable Designing for Retain and Motivation)
21 ¹ 2563...ԵԷҡúСè٧١ͧ (The Powerful Psychological Excellency Skills for Management Leadership Competencies)
22 ¹ 2563...ҧջԷҾ (Proficiency Communication)
22 ¹ 2563...ԷҾкǹüԵ DOJO Training System
23-24 ¹ 2563...Intermediate Excel for Database and Special Functions article
23 ¹ 2563...ҧç٧㹡÷ӧҹ
24 ¹ 2563...ʹ㹡âѺѡҹѺö article
25 ¹ 2563...èѴäѧԹ/ФǺʵ͡ؤ 4.0 (Warehousing/Stock Management and control for 4.0)
25 ¹ 2563...Ţҹء㹰ҹм¼ 4.0 article
27 ¹ 2563...෤Ԥúóҡäѹͧͤҧ׹ (Relationship Integration Technic in Organization for sustainable success)
27 ¹ 2563...Effective Presentation by PowerPoint
28 ¹ 2563...äǺ͡ ѺäǺкúäسҾ кèѴǴ (Document Control for Integrated of ISO 9001:2015 & ISO 14001:2015) article
28 ¹ 2563...෤Ԥ觻¤ѧѺӧҹԸա͹෾...鹰ҹ article
29 ¹ 2563...شʹѡѭ дՔ
29 ¹ 2563...úüŧҹºçѧ OKRs : Objectives & Key Results article
30 ¹ 2563...ʵŻ....ѡСùʹ (SMART Presentation Skills) article
7 Ҥ 2563...طҧἹФǺüԵջԷҾ (Strategic for Production Management)
15 Ҥ 2563...èѴäѧԹ/ФǺʵ͡ؤ 4.0 (Warehousing/Stock Management and control for 4.0)
12 Ҥ 2563...ѡСäԴҧäҧդسԧѵ (Thinking Skill for Innovation)
20 Ҥ 2563...ʹءѺҭջ Tanoshii Nihongo
22 Ҥ 2563...èѴ͡кФҧ 鹷ع
27 Ҥ 2563...Internal Auditor Training 繼ǨԴ Ѻк ISO 9001:2015
4 Զع¹ 2563...5. ӹѡҹ (5S and Kaizen in Office)
17 Զع¹ 2563...෤Ԥúѹ֡СèѴ§ҹûЪ
27 Զع¹ 2563...èѴäѧԹ/ФǺʵ͡ؤ 4.0 (Warehousing/Stock Management and control for 4.0)
2 áҤ 2563...˵ 䢻ѭлͧѹ PDCA 8Ds (PDCA & 8Ds with RCA for Long-Term problem solving and prevention)
14 áҤ 2563...þѲҺؤԡҾШԵӹ֡㹡ԡ
24 áҤ 2563...èѴäѧԹ/ФǺʵ͡ؤ 4.0 (Warehousing/Stock Management and control for 4.0)
6 ԧҤ 2563...طҧἹФǺüԵջԷҾ (Strategic for Production Management)
29 ԧҤ 2563..èѴäѧԹ/ФǺʵ͡ؤ 4.0 (Warehousing/Stock Management and control for 4.0)
3 ѹ¹ 2563...úáüԵѺ˹ҧҹؤŴ鹷عԷҾ (Production Management for Cost reduction and Efficiency improvement)
25 ѹ¹ 2563...èѴäѧԹ/ФǺʵ͡ؤ 4.0 (Warehousing/Stock Management and control for 4.0)
6 Ҥ 2563...5. ӹѡҹ (5S and Kaizen in Office)
31 Ҥ 2563...èѴäѧԹ/ФǺʵ͡ؤ 4.0 (Warehousing/Stock Management and control for 4.0)
5 Ȩԡ¹ 2563...͡Ԩ͡żԵŴ鹷عѺ÷ӧҹ (Effectiveness of Productivity tools selection)
27 Ȩԡ¹ 2563...èѴäѧԹ/ФǺʵ͡ؤ 4.0 (Warehousing/Stock Management and control for 4.0)
8 ѹҤ 2563...طҧἹФǺüԵջԷҾ (Strategic for Production Management)



Copyright © 2013 All Rights Reserved.