회원가입 공지사항
로그인
비밀번호
엑셀 자동화 서식
엑셀 자동화 기술 방법
엑셀 실무활용 팁
맞춤서식 제작
 회원 방문 수    801,913 명  
 접속 인원 수    687 명  
  홈 > 엑셀자동화기술 > 엑셀자동화 기술방법    

콘텐츠제목
경조금/휴가 신청서 만들기 (Hit: 10,332) 확대축소   인쇄  
다운로드
 경조금신청서(연습용).xls
 경조금신청서(완성).xls
결혼, 회갑, 조의 등 직원의 경사스러운 일을 축하하기 위해 또는 흉사를 조문하기 위해 회사가 지급하는 축하금이나 부의금 등을 경조금이라 합니다. 직원은 이러한 일이 발생했을 때 회사로부터 미리 정해진 경조금을 지급받기 위해 또 정해진 경조휴가를 허락받기 위해 신청서를 작성하여 제출합니다. 경조금과 휴가일수는 기업마다 약간씩 차이가 나기 때문에 여기서는 기준표에 경조금, 휴가일수, 증빙서류 등을 미리 구성해 두고, 신청서에서 참조하도록 작성합니다. 회사 사규에 따라 기준표만 수정하면 신청서는 자동으로 만들 수 있습니다. 업무에 바로 사용할 수 있는 완성 파일과 연습해 볼 수 있는 연습용 파일을 제공합니다.

연습용 파일과 완성 파일, 모든 내용은 [유료회원]에게 제공됩니다.

숫자 천 단위마다 쉼표를 삽입하고 괄호와 통화 기호 등을 함께 표시하기 위한 것이다.

    

   숫자의 표시 형식을 사용자 지정한다.
 

⑤ [F22]셀에 =V7을 입력해서 경조일자를 그대로 가져와 표시한다. [Q22]셀에는 경조금 지급일자를 직접 입력한다.

⑥ [X22]셀에 =O7&" "&I7을 입력해서 관계(O7)와 경조 구분(I7)을 연결하여 표시한다.

⑦ [I25]셀에 =O5를 입력해서 부서를 그대로 가져오고, [N25]셀에 =I5를 입력해서 성명을 그대로 가져와 표시한다.

    

   신청서에서 필요한 항목을 가져와 영수증을 구성한다.


리스트


d chanyuan
20180810 junda

stephen curry shoes


kate spade outlet


jack wolfskin


jeep shoes


air max 97


true religion outlet


dsquared2 jeans


canada goose jackets


tory burch outlet


lacoste polo shirts


longchamp pliage


yeezy boost


bcbg dresses


true religion outlet


mulberry handbags


polo ralph lauren


air huarache


air jordan 3


celine outlet


pandora jewelry


air force 1


canada goose outlet


canada goose jackets


ugg outlet


oakley sunglasses


bulgari jewelry


pelicans jerseys


coach factory outlet


celtics jerseys


fingerlings monkey


pandora charms


gucci outlet


canada goose outlet


christian louboutin outlet


oakley sunglasses


bally shoes


polo ralph lauren


tory burch outlet


nhl jerseys


prada shoes



2018-08-10 오전 11:06:08
d chanyuan
20180906xiaoke

moncler jackets


polo ralph lauren outlet online


guess factory


ugg outlet online


gentle monster sunglasses


jordan shoes


ugg outlet,ugg outlet stores


polo ralph lauren outlet


nhl jerseys for sale


supreme uk


pandora outlet


louboutin shoes


tory burch outlet store


canada goose outlet online


ray ban sunglasses sale


houston texans jersey


pandora jewelry


mbt outlet


cheap jordans


ugg boots clearance


uggs outlet


michael kors outlet


pandora outlet


coach factory outlet online


coach outlet online


coach outlet store online


kate spade handbags


red bottoms


coach outlet online


cheap ray ban sunglasses


christian louboutin sale


coach outlet online


ugg boots clearance


diesel jeans


north face


true religion jeans


canada goose jackets


oakley sunglasses wholesale


swarovski jewellery


canada goose


miu miu outlet


canada goose outlet


canada goose uk


ralph lauren outlet


nba jerseys wholesale


brequet wathes


michael kors uk


ralph lauren polo outlet


canada goose jackets


christian louboutin



2018-09-06 오후 2:46:36
d zzyytt

pandora bracelet


michael kors outlet


rolex replica


michael kors purses


birkin bag


fila


lacoste polo shirts


yeezy boost


yeezy shoes


off white shoes


nike cortez


nike air max 90


off white hoodie


polo ralph lauren


100% real jordans for cheap


golden goose


michael kors outlet


bape hoodie


yeezy boost 350


jordan shoes


zzyytt
2018-09-25 오전 11:05:04
d chanyuan
2018927 leilei3915

ralph lauren


ugg outlet


cheap ugg boots


ralph lauren outlet


pandora jewelry


coach factory outlet


mulberry bags


canada goose sale


pandora outlet


moncler jackets


mbt shoes


kate spade outlet


pandora outlet


christian louboutin


ralph lauren


puma outlet


pandora jewelry outlet


coach factory outlet


nike outlet online


pandora charms outlet


michael kors outlet


christian louboutin sale


ray-ban sunglasses


michael kors outlet clearance


canada goose outlet


mulberry bags


christian louboutin outlet


superdry uk


canada goose jackets


cheap uggs


pandora outlet


tory burch outlet


canada goose jackets


christian louboutin


pandora jewelry


polo ralph lauren


canada goose jackets


yeezy boost 350 v2


coach outlet


manolo blahnik outlet


canada goose


ugg boots on sale


coach outlet online store


kate spade outlet


adidas yeezy boost


chaussures christian louboutin


kate spade sale


polo outlet


kate spade handbags


true religion



2018-09-27 오후 7:06:32
d chanyuan
2018.10.10chenlixiang

adidas


adidas outlet


moncler jackets


curry 4


nike air max


adidas superstar


kevin durant shoes


rolex watches


curry 2


adidas flip-flops


chrome hearts jewelry


air max


roshe run


yeezy shoes


arcteryx jackets


jordan retro


new balance


pandora jewelry


nike air max


air max 95


kate spade outlet


louboutin


carson wentz jersey


ray ban sunglasses


hollister outlet


pandora


adidas outlet store


instyler ionic styler


rolex


ralph lauren


wedding dresses


jordan 8


nike air max


designer sunglasses


cheap nfl jerseys


jordan 9


kenzo clothing


bose headphones


lululemon outlet


moncler outlet


kobe 9


ugg boots


new balance


nike factory


oakley


michael kors outlet


kids jordans


converse shoes


michael kors


oakley sunglasses


2018.10.10chenlixiang
2018-10-10 오후 2:46:38
d xiao
2018-10-16 xiaozhengzheng

ralph lauren uk


pandora charms


superdry


ralph lauren outlet


cheap oakley sunglasses


polo ralph lauren


pandora charms


michael kors outlet online


canada goose outlet online


true religion jeans


yeezy boost


michael kors outlet


canada goose


christian louboutin shoes


pandora jewelry


ray ban sunglasses


christian louboutin


christian louboutin shoes


coach outlet online


nfl jerseys wholesale


ralph lauren outlet


valentino shoes


ugg outlet online


coach outlet online


christian louboutin outlet


fred perry polo


michael kors outlet online


air max 90


ferragamo shoes sale


coach factory outlet


christian louboutin shoes


ugg boots


michael kors outlet


ralph lauren shirts


michael kors


cheap uggs


cheap oakley sunglasses


ralph lauren shirts


canada goose sale


uggs outlet


nike shoes outlet


michael kors outlet


oakley sunglasses


michael kors outlet


ugg boots



2018-10-16 오후 3:16:00
d chanyuan

jordan pas cher


air jordan 5


bcbg dresses


converse shoes


uggs


nfl jerseys


ugg sale


adidas outlet store


celine handbags


lebron 13


michael kors bags


michael kors outlet clearance


burberry sale


trikots günstig


womens ugg boots


ray ban sunglasses


ysl handbags


coach factory outlet


christian louboutin shoes


coach handbags


nike free run


miu miu shoes


vans shoes


fitflops


persol sunglasses


ugg for men


michael kors outlet clearance


marcelo burlon


manolo blahnik


nike air max plus


tiffany jewelry


police sunglasses


versace handbags


nike outlet


prada outlet


vendita maglie calcio


kyrie 3


moncler outlet

vans old skool


basketball shoes


prada bags


lebron 15


kobe shoes


nike huarache


cheap mlb jerseys


ralph lauren outlet


cheap supra shoes


hermes birkin bag


ray ban sunglasses outlet


supreme hoodie


chenlina20181106
2018-11-06 오전 11:56:58
d chanyuan
2018-11-19 xiaozhengzheng

coach outlet online


pandora jewelry


michael kors outlet clearance


michael kors outlet online


ugg outlet


air max shoes


fred perry shirts


michael kors outlet online


hermes birkin


true religion


christian louboutin outlet


polo outlet


supreme shirts


ray ban sunglasses outlet


ugg outlet


nike shoes


kobe bryant shoes


giuseppe zanotti outlet


coach handbags


mbt shoes clearance


ugg outlet online


ugg boots clearance


ray-ban sunglasses


coach factory outlet


canada goose


coach outlet online


tory burch outlet online


michael kors outlet online


mont blanc


canada goose outlet store


polo ralph lauren


ferragamo outlet store


tory burch outlet


ralph lauren outlet


ugg outlet online


fitflop sandals


michael kors handbags


true religion


kate spade purses


michael kors outlet online


coach outlet



2018-11-19 오후 6:26:00
d qzyfffff

michael kors handbags


moncler jackets


moncler jacket


yeezy boost 350 v2


cheap jordans


kobe 11


pure boost


kyrie irving shoes


coach outlet sale


yeezys


nike air max


off white


off white


supreme clothing


nike jordans


kobe basketball shoes


coach outlet online


jordan 13


coach handbags


lacoste


yeezy shoes


curry 4 shoes


lebron shoes


louboutin shoes uk


jordan 4


nike air max 2019


goyard bag


adidas nmd r1


golden goose


hermes belt


valentino


vapormax


air jordan 4


curry 5


valentino shoes


kd shoes


hogan outlet online


michael kors outlet online


adidas tubular shadow


cheap jordans


golden goose outlet


nike hyperdunk


fake rolex


pandora jewelry


hermes handbags bag


basketball shoes


coach outlet online


timberland outlet


michael kors purses


kobe shoes


qzyfffff

2018-12-28 오후 5:48:10
d yanmaneee

moncler coat


adidas stan smith men


curry shoes


kd shoes


nike huarache


christian louboutin shoes


adidas yeezy


kd shoes


adidas nmd r1


michael kors handbags


supreme clothing


kyrie shoes


nike kyrie 5


canada goose


coach outlet store


nike basketball shoes


louboutin shoes


jordans


air jordan


adidas superstar shoes


coach factory outlet


golden goose


adidas nmd


adidas nmd r1


balenciaga sneakers


coach outlet online


michael kors


moncler


jordan 13


ultra boost 3.0


louboutin shoes


jordan 12


balenciaga speed trainer


supreme clothing


jordan 11


adidas gazelle sale


hermes birkin


vapormax


fila shoes


jordan shoes


yanmaneee

2019-04-29 오후 7:08:44
※ 이 게시물에 대한 의견을 입력해 주세요(4,000자 이내).
엑셀연말정산자동계산
엑셀 2007 교육
워드프로세서 기출문제
컴퓨터활용 기출문제
2013년 급여 자동계산
단원별 기출문제 검색
엑셀자동화 서식
엑셀자동화 방법
엑셀실무 팁
두드림 통합 검색
엑셀자동화서식제작요청
상호 : 두드림기획 | 사업자등록번호 : 105-20-55088 | 통신판매업신고번호 : 마포통신 제5343호 | 대표 : 이형범 |
고객정보관리책임자 : 이소연 | 주소 : 서울특별시 마포구 월드컵로16길 47 201호(서교동) | 전화: 02)323-7705 |
Fax: 02)6918-4545 | 입금계좌 : 국민은행(543001-01-213514) | E-Mail :
Copyright 2006 두드림기획(www.edodream.com) All Rights Reseved.