關於事務所 Excel的Tick Mark - 會計

By Kyle
at 2017-03-09T01:08

Table of Contents

小魯之前在某四大實習，公司電腦Excel有他們自己的增益集，
裡面是各種做底稿會用到的功能，不知道其他事務所的Excel有沒有這樣的工具？

準備會計師太無聊就把一些我記得的功能寫出來，

這張圖是我現在開發出來的功能，年代久遠只記得自己用過的
http://i.imgur.com/XpoRvsA.png

請教各位版上的前輩在工作上還需要用到哪些Excel的功能？
例如常用到的還是任何可以程式化的功能，我應該都可以試著coding
雖然還沒做UI美化，不過再加個50個功能應該不是問題，

如果有版友想試用看看可以推文留個信箱(截止到星期日24:00)，我再寄給你
(目前只有開發Excel2016 和 2013)
順便幫我看看有沒有Bug XD(目前這版有一個bug封裝完才想到)

(請不要寄站內信信箱已經爆了)

--

Tags: 會計

All Comments

By Connor
at 2017-03-12T20:03

推tick mark好用，出來外面偶爾做底稿也會用到

By Mia
at 2017-03-16T18:48

parfait1984@gmail.com

By Skylar DavisLinda
at 2017-03-19T16:30

rnbo@kimo.com

By Bethany
at 2017-03-23T19:18

accnpic94@gmail.conlm

By Ophelia
at 2017-03-26T22:33

alex19830510@gmail.com

By Freda
at 2017-03-28T21:17

windsonglove@gmail.com

By Necoo
at 2017-03-31T16:45

rachelchenacc@gmail.com

By Regina
at 2017-04-02T21:17

推板主用心

By William
at 2017-04-06T06:28

smart820811@gmail.com

By Rosalind
at 2017-04-11T03:25

zzzz00tw@yahoo.com.tw

By Delia
at 2017-04-13T14:58

jasonchung1028@gmail.com

By Faithe
at 2017-04-13T19:48

piot230@gmail.com

By Hardy
at 2017-04-18T13:36

minochilly@hotmail.com

By Lily
at 2017-04-21T20:50

funglinda0729@gmail.com

By Kelly
at 2017-04-24T18:59

meiice5589@gmail.com

By Anonymous
at 2017-04-26T22:18

lintengteng@gmail.com

By Hamiltion
at 2017-04-30T15:39

vzsa19234@yahoo.com.tw

By Jessica
at 2017-05-05T13:34

fdgv_2@hotmail.com

By Edwina
at 2017-05-05T20:20

naturekuro@gmail.com

By Hamiltion
at 2017-05-07T13:21

gin2517@gmail.com

By Rosalind
at 2017-05-12T12:11

z27616900@yahoo.com.tw

By Robert
at 2017-05-13T02:30

yiyi09p@gmail.com 謝謝！

By Gilbert
at 2017-05-13T18:35

allen007chen@gmail.com 謝謝

By Thomas
at 2017-05-18T07:12

prter0809@gmail.com

By Callum
at 2017-05-20T13:02

pozai2002@gmail.com 感謝！

By Valerie
at 2017-05-20T22:06

sjumeopit@gmail.com

By Charlie
at 2017-05-22T17:26

ms0527860@gmail.com

By Enid
at 2017-05-26T03:05

emdiath@hotmail.com 謝謝！

By Freda
at 2017-05-30T14:22

yangaya@gmail.com 謝謝

By Jacob
at 2017-06-03T14:57

sbt657134@gmail.com

By Jessica
at 2017-06-07T22:16

a6943kght@gmail.com. 感謝大大

By Susan
at 2017-06-10T00:09

bbyyy0804@hotmail.com

By Edith
at 2017-06-11T23:14

inskystar1412@gmail.com 謝謝大大

By Faithe
at 2017-06-16T01:08

cpq19831016@gmail.com 感謝大大

By Rae
at 2017-06-21T00:57

ken60816@gmail.com 感謝！！！

By Gary
at 2017-06-25T16:44

a1995727@gmail.com

By Elizabeth
at 2017-06-29T18:39

fufujackwu@yahoo.com.tw 謝謝～

By Caroline
at 2017-07-03T10:38

abc255381@yahoo.com.tw推好心,先跪了

By Oliver
at 2017-07-04T00:42

jawill.chang@gmail.com 謝謝!

By Lauren
at 2017-07-04T16:43

dq-r@hotmail.com 感謝分享!!

By Joe
at 2017-07-09T07:01

elanina615@hotmail.com 謝謝！

By Quintina
at 2017-07-09T09:31

推好心，謝謝ch306@hotmail.com

By Olivia
at 2017-07-10T10:31

sdwfxoz@msn.com 謝謝

By Enid
at 2017-07-13T01:43

mengyanyu@gmail.com 感謝

By Eden
at 2017-07-13T18:28

yeshchen1@gmail.com

By Rebecca
at 2017-07-15T17:06

a22027220@yahoo.com.tw 非常感謝

By Oscar
at 2017-07-17T13:13

Outfinal@gmail.com

By Hedda
at 2017-07-18T21:39

b0937994222@gmail.com 謝謝

By Emily
at 2017-07-20T08:24

Zhenx20805@gmail.com 感恩

By Isabella
at 2017-07-24T16:19

jj40924@gmail.com

By Ina
at 2017-07-27T02:36

s8868861@gmail.com 謝謝！

By Isabella
at 2017-07-29T12:46

nason0806@gmail.com

By Hamiltion
at 2017-07-31T18:09

acy2567@gmail.com 謝謝好心人！

By Olive
at 2017-08-05T17:42

cindy770217@hotmail.com 謝謝

By David
at 2017-08-08T18:14

jing8923@gmail.com 謝謝

By Robert
at 2017-08-13T03:36

akiraloiter@gmail.com 謝謝！

By Yuri
at 2017-08-15T18:00

malin0704@gmail.com，超懷念這個功能！！謝謝：）

By Vanessa
at 2017-08-20T04:00

Kuanyiwu940@gmail.com 謝謝

By Joe
at 2017-08-21T18:57

milk15233@gmail.com

By Todd Johnson
at 2017-08-25T14:12

jason831127@gmail.com 感謝

By Ursula
at 2017-08-27T05:49

jht0426@gmail.com

By Sarah
at 2017-08-30T23:57

sheuyuanniq@gmail.com 謝謝～～～

By Lauren
at 2017-09-03T00:32

chichieng@gmail.com 謝謝

By Barb Cronin
at 2017-09-03T23:47

Yuwen7995@gmail.com 謝謝

By Necoo
at 2017-09-05T03:44

ji3g4h94ru8u4@gmail.com 感謝大德

By Necoo
at 2017-09-07T19:06

Fish523420@yahoo.com.tw 謝謝!

By Zenobia
at 2017-09-12T11:20

xiansmily@hotmail.com 謝謝

By Eden
at 2017-09-14T15:52

annayjudy@gmail.com

By Elizabeth
at 2017-09-18T07:23

sunshiany@gmail.com 太感謝了!!!!

By Ursula
at 2017-09-21T04:55

z00338972@gmail.com 謝謝

By Margaret
at 2017-09-25T19:01

sharon3510678@gmail.com 謝謝！

By Hazel
at 2017-09-28T05:55

cindy42124@gmail.com 謝謝

By Freda
at 2017-09-28T18:17

s914234@gmail.com 謝謝！

By Donna
at 2017-09-28T23:58

anguskent@gmail.com 感謝~

By Noah
at 2017-10-02T00:07

oxt2753721@gmail.com

By Kelly
at 2017-10-06T02:41

推+1, cornslife@hotmail.com

By Charlie
at 2017-10-09T19:06

karols086@hotmail.com

By Ula
at 2017-10-12T03:10

zhihan79@gmail.com 謝謝：）

By Donna
at 2017-10-12T06:31

f89514179@gmail.com 謝謝～

By Edward Lewis
at 2017-10-15T00:19

iamforsalela@gmail.com 感謝

By Olga
at 2017-10-18T16:53

sa046426@gmail.com 謝謝

By Madame
at 2017-10-21T14:11

x94u.4u4@gmail.com 感謝你！！

By Emily
at 2017-10-21T16:33

abc6551559@gmail.com 感謝

By Emily
at 2017-10-23T08:37

outset0@gmail.com 謝謝您！

By Candice
at 2017-10-27T21:12

lorichangc443@hotmail.com

By Yuri
at 2017-10-30T11:23

skystar0819@hotmail.com 謝謝！

By Isla
at 2017-10-31T04:18

khcjkhldh@gmail.com 謝謝!

By Carol
at 2017-11-01T00:04

ajosidan123@hotmail.com.tw thx!!!

By Jake
at 2017-11-02T02:25

jenny60930@yahoo.com.tw 謝謝~ :)

By Charlie
at 2017-11-03T01:29

judy821209@gmail.com

By Tristan Cohan
at 2017-11-05T21:21

aabbabc1989@hotmail.com 謝謝!

By Rebecca
at 2017-11-09T15:00

joe780802@gmail.com

By Aaliyah
at 2017-11-11T12:09

warrenauction@yahoo.com.tw

By Dinah
at 2017-11-13T07:35

Korver0327@gmail.com

By Sandy
at 2017-11-16T19:05

jmh1111@hotmail.com.tw 感謝分享！

By Franklin
at 2017-11-18T01:52

chaolianghwang@gmail.com 推好心！

By Suhail Hany
at 2017-11-19T04:59

a0910639615@gmail.com 推好心謝謝！

By Mary
at 2017-11-22T07:16

daviedya@gmail.com 謝謝！

By Susan
at 2017-11-25T03:56

home79198@gmail.com

By Jacob
at 2017-11-29T03:06

ryder22024817@gmail.com 推推推！

By Freda
at 2017-12-03T09:27

blueken1025@gmail.com 謝謝

By Daniel
at 2017-12-06T08:56

vikarechronos@gmail.com 謝謝！

By Zora
at 2017-12-09T02:09

sodomyhahaha@gmail.com 謝謝你

By Elvira
at 2017-12-11T12:50

謝謝 orchid302@gmail.com

By Mary
at 2017-12-14T10:57

tear0033@yahoo.com.tw 感謝你

By Faithe
at 2017-12-16T03:27

love204953@hotmail.com 感謝！

By Sierra Rose
at 2017-12-20T10:03

eschen139@gmail.com

By Dora
at 2017-12-23T03:41

pacific9329@gmail.com 謝謝!

By Susan
at 2017-12-24T15:11

hinicepoint@gmail.com

By Charlotte
at 2017-12-29T09:48

kuku702@gmail.com 謝謝

By Christine
at 2018-01-03T08:22

sunchiehssh@gmail.com 感謝！！！

By Carol
at 2018-01-04T00:43

hary9231@gmail.com. 謝謝！

By William
at 2018-01-08T00:56

a0910393647@gmail.com

By Skylar Davis
at 2018-01-08T02:24

hspss896329@gmail.com 謝謝！

By Kristin
at 2018-01-12T08:23

s10106852@gmail.com

By Sandy
at 2018-01-15T09:44

pk66295532@gmail.com

By Elma
at 2018-01-18T05:34

yukidai1995@gmail.com 謝謝!!!

By Edwina
at 2018-01-22T11:54

conan10978@gmail.com 感謝!

By Joe
at 2018-01-23T21:20

earl0528@hotmail.com 謝謝!

By Barb Cronin
at 2018-01-28T01:47

tyui1213@hotmail.com

By Dorothy
at 2018-01-31T20:40

所以其他四大有沒有這個工具呢？如果我要去的那家

By Dorothy
at 2018-02-05T18:23

沒有我就再認真一點做XDD

By Ina
at 2018-02-07T18:07

jhihting@gmail.com

By Caitlin
at 2018-02-09T10:08

yulienonly@gmail.com 謝謝

By Necoo
at 2018-02-12T03:34

f1012808@gmail.com 推好心謝謝！

By Ida
at 2018-02-15T16:15

holove318@hotmail.com 感謝!!!

By Daph Bay
at 2018-02-18T17:16

cqr97000@gmail.com. 感謝！

By Annie
at 2018-02-19T21:44

Deloitte 有

By Christine
at 2018-02-23T07:16

specialdeck@gmail.com 感謝您：)

By Agatha
at 2018-02-26T10:03

forchien4@gmail.com 謝謝: )

By Agnes
at 2018-02-28T09:49

tmrsm_chan@hotmail.com 感謝

By Iris
at 2018-03-04T20:29

dg56655@gmail.com 感謝！

By Enid
at 2018-03-08T14:39

orange88210@yahoo.com.tw 感謝

By Hardy
at 2018-03-12T21:41

ben60030@gmail.com

By Lucy
at 2018-03-15T01:22

h37195@gmail.com 感謝分享

By Frederica
at 2018-03-16T01:19

g2041291@gmail.com 謝謝！！

By Kumar
at 2018-03-18T22:53

cindy90802870416@gmail.com 感謝分享！！！

By Victoria
at 2018-03-19T03:33

ting4528s@gmail.com 謝謝:)

By Agatha
at 2018-03-19T22:35

hiroki310617@hotmail.com 謝謝分享 K所有

By Rachel
at 2018-03-23T09:13

wowwowwu123@gmail.com 麻煩了！謝謝

By Edward Lewis
at 2018-03-23T11:26

sandy35422000@gmail.com.

By Tristan Cohan
at 2018-03-26T15:00

ankialz@gmail.com

By Eden
at 2018-03-28T23:15

JOHNCHIHSHENG2635@GMAIL.COM

By Robert
at 2018-04-01T05:20

stu87192@gmail.com 謝謝大大

By Callum
at 2018-04-03T13:14

wakui.chiang@gmail.com 感謝大大分享

By Steve
at 2018-04-05T14:38

難得爆

By Frederica
at 2018-04-08T21:46

orzxx1994@yahoo.com.tw

By Wallis
at 2018-04-13T11:02

peilin1001@gmail.com

By Jessica
at 2018-04-15T04:31

Ken8089@gmail.com 感謝

By George
at 2018-04-19T12:33

Gerald.1993@gmail.com

By John
at 2018-04-21T18:22

ooppxxzz2010@gmail.com 謝

By Olivia
at 2018-04-21T20:27

bnmbnmbnm3@gmail.com

By Isla
at 2018-04-25T05:56

a2856853@gmail.com。謝謝！！

By Isla
at 2018-04-29T18:03

lisa19940303@gmail.com

By Frederica
at 2018-05-03T01:24

cheerup1723@gmail.com

By Thomas
at 2018-05-03T19:03

lindahou128@gmail.com 謝謝

By Franklin
at 2018-05-06T14:02

cup3880@gmail.com 謝謝！

By Susan
at 2018-05-10T05:28

alissa8292@gmail.com 謝謝！

By Suhail Hany
at 2018-05-12T14:01

yun922823@gmail.com 謝謝！

By Doris
at 2018-05-13T08:02

littleamas@hotmail.com 謝謝!!

By Hazel
at 2018-05-16T07:46

wowopu@gmail.com 謝謝！

By Isla
at 2018-05-19T21:46

coke123tw@yahoo.com.tw

By Andy
at 2018-05-22T14:45

wayne654852@hotmail.com 謝謝您

By Olivia
at 2018-05-24T21:38

peiyutw1019@gmail.com 感謝！

By Elvira
at 2018-05-25T16:37

qwe9570123@gmail.com

By Daniel
at 2018-05-26T06:32

lanjai806@gmail.com 感謝!

By Genevieve
at 2018-05-28T05:35

Jane19900104@hotmail.com

By Yedda
at 2018-05-30T01:58

cha78621@gmail.com 謝謝

By Linda
at 2018-06-03T20:11

aaagr2002@yahoo.com.tw 感恩~*^_^*

By Doris
at 2018-06-04T05:29

ploki2726@gmail.com
感謝~

By Elma
at 2018-06-06T12:02

A0121118@g2.usc.edu.tw 謝謝

By Tom
at 2018-06-10T18:30

amy91669@gmail.com 謝謝！

By Blanche
at 2018-06-12T06:57

b99702102@ntu.edu.tw 謝謝!!

By Genevieve
at 2018-06-14T13:00

milu9455@g.ncu.edu.tw 謝謝~~

By George
at 2018-06-18T14:45

b1nm336@yahoo.com.tw 謝謝～

By Frederic
at 2018-06-19T08:18

lu781228@yahoo.com.tw

By Kumar
at 2018-06-20T09:14

joannechen0929@gmail.com

By Steve
at 2018-06-20T11:41

karrow10@yahoo.com.tw 謝謝您

By Genevieve
at 2018-06-24T20:49

scott071781@gmail.com 謝謝

By Sarah
at 2018-06-25T22:24

tp6m3cl6@hotmail.com 謝謝

By Lauren
at 2018-06-30T18:07

wangnosewangnose@gmail.com

By Quanna
at 2018-07-04T09:09

謝謝><

By Elma
at 2018-07-07T19:16

donna900622@gmail.com

By Odelette
at 2018-07-11T12:30

yhshiao@outlook
com 謝謝大大!!!

By Rebecca
at 2018-07-13T01:24

asd5asdroylin@gmail.com 感謝大大

By Noah
at 2018-07-15T04:34

a014320@gmail.com 謝謝,加個每日英文名言也許不錯^^

By Vanessa
at 2018-07-18T15:48

siaoling73@gmail.com謝謝唷

By Leila
at 2018-07-21T20:17

katherine0805@gmail.com

By Zenobia
at 2018-07-26T10:19

jay6011994@gmail.com

By Megan
at 2018-07-29T18:30

honeydew237@hotmail.com

By Hardy
at 2018-08-01T16:30

ss89279@gmail.com 感恩

By Anthony
at 2018-08-03T21:38

qaz506640@yahoo.com.tw

By Elizabeth
at 2018-08-04T03:36

georgechen1990@gmail.com感恩

By Kyle
at 2018-08-04T19:58

Jhouyisyuan@gmail.com 謝謝！

By Isla
at 2018-08-09T05:55

shihying1990@gmail.com 謝謝!!!

By Odelette
at 2018-08-11T22:36

a0963397916@hotmail.com 謝謝～！

By Annie
at 2018-08-14T19:28

vul35a86@yahoo.com.tw

By Jake
at 2018-08-19T04:35

tychenhung@gmail.com 謝謝！

By Madame
at 2018-08-23T08:39

13ccww@gmai.com

By Xanthe
at 2018-08-25T15:34

13ccww@gmail.com
感恩，不好意思我少打一個l

By Sarah
at 2018-08-27T00:15

a81y251@gmail.com

By Delia
at 2018-08-31T17:51

dawn01994@yahoo.com.tw

By Donna
at 2018-09-02T11:10

qaz24518999@hotmail.com 感謝！

By Edwina
at 2018-09-03T00:43

ahong88105@gmail.com 感謝！

By George
at 2018-09-06T00:22

q983085036@yahoo.com.tw 感恩

By Faithe
at 2018-09-10T04:14

kimkimlol22@gmail.com 謝謝！祝考試順利！

By Eartha
at 2018-09-14T14:16

zxc590613@gmail.com 謝謝

By Rosalind
at 2018-09-18T01:05

santainfinland2014@gmail.com

By Olivia
at 2018-09-20T10:23

dragonflying01@gmail.com

By Hamiltion
at 2018-09-23T15:03

sakura21201@gmail.com 謝謝!

By Edwina
at 2018-09-24T13:10

feather4012@gmail.com

By Wallis
at 2018-09-25T17:36

jermauer@gmail.com 謝謝大大

By Hedda
at 2018-09-26T09:45

看一次推一次，拜託了！ wayne654852@hotmail.com

By Charlie
at 2018-09-29T03:19

boy.kmnridq@gmail.com 謝謝

By Madame
at 2018-10-03T11:17

yenscofield@hotmail.com 感謝~

By Jessica
at 2018-10-06T01:35

g04440008@thu.edu.tw 謝謝~

By Ophelia
at 2018-10-10T03:48

axilla5011@gmail.com

By Callum
at 2018-10-12T14:19

motley2002602@hotmail.com. 感謝！

By Caitlin
at 2018-10-16T02:29

cabulala38@yahoo.com.tw 謝謝你

By Charlotte
at 2018-10-20T03:43

phoenix770714@gmail.com 謝謝~

By Dinah
at 2018-10-23T09:51

jimmydaiv@hotmail.com
多謝

By Lydia
at 2018-10-28T04:57

aa2267006@gmail.com 感謝

By Isla
at 2018-10-31T11:06

sandy35422000@gmail.com

By Olivia
at 2018-11-02T05:10

au4a83su3h9c8@gmail.com

By Andrew
at 2018-11-04T13:10

kk.chen147@gmail.com 樓主大大一生平安

By Queena
at 2018-11-05T03:16

raquel821225@gmail.com 感謝大大

By Dorothy
at 2018-11-09T02:20

ruru4390@gmail.com謝謝耶！

By Megan
at 2018-11-12T20:59

已收到，感謝

By Edwina
at 2018-11-14T03:13

收到了謝謝～

By Leila
at 2018-11-16T14:18

s9755086@gmail.com.tw謝謝！

By Daniel
at 2018-11-20T15:35

allenhwu112@gmail.com，感謝

By Eartha
at 2018-11-23T18:28

employ0522@msn.con 謝謝！

By Victoria
at 2018-11-27T11:58

jrsion@hotmail.com 感謝大大~

By Mary
at 2018-11-28T01:07

yibear72@yahoo.com.tw 謝謝你的分享

By Dora
at 2018-12-02T10:41

grace551199@gmail.com 謝謝

By Daniel
at 2018-12-04T03:15

sunshine263014@gmail.com 謝謝~

By Megan
at 2018-12-08T01:53

jane252229@gmail.com

By Erin
at 2018-12-09T03:22

oliver780225@gmail.com 感謝大大!!

關於事務所 Excel的Tick Mark - 會計

All Comments

Related Posts

林蕙真中高會

2017年北一會計師中成會課本

四大應屆外派上海

收購審計準則公報合訂本 105/10版

七八月美會夥伴