關於事務所 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封裝完才想到)

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

--

All Comments

By Connor
at 2017-03-12T20:03

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

By Mia
at 2017-03-16T18:48

[email protected]

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

[email protected]

By Bethany
at 2017-03-23T19:18

[email protected]

By Ophelia
at 2017-03-26T22:33

[email protected]

By Freda
at 2017-03-28T21:17

[email protected]

By Necoo
at 2017-03-31T16:45

[email protected]

By Regina
at 2017-04-02T21:17

推板主用心

By William
at 2017-04-06T06:28

[email protected]

By Rosalind
at 2017-04-11T03:25

[email protected]

By Delia
at 2017-04-13T14:58

[email protected]

By Faithe
at 2017-04-13T19:48

[email protected]

By Hardy
at 2017-04-18T13:36

[email protected]

By Lily
at 2017-04-21T20:50

[email protected]

By Kelly
at 2017-04-24T18:59

[email protected]

By Anonymous
at 2017-04-26T22:18

[email protected]

By Hamiltion
at 2017-04-30T15:39

[email protected]

By Jessica
at 2017-05-05T13:34

[email protected]

By Edwina
at 2017-05-05T20:20

[email protected]

By Hamiltion
at 2017-05-07T13:21

[email protected]

By Rosalind
at 2017-05-12T12:11

[email protected]

By Robert
at 2017-05-13T02:30

[email protected] 謝謝！

By Gilbert
at 2017-05-13T18:35

[email protected] 謝謝

By Thomas
at 2017-05-18T07:12

[email protected]

By Callum
at 2017-05-20T13:02

[email protected] 感謝！

By Valerie
at 2017-05-20T22:06

[email protected]

By Charlie
at 2017-05-22T17:26

[email protected]

By Enid
at 2017-05-26T03:05

[email protected] 謝謝！

By Freda
at 2017-05-30T14:22

[email protected] 謝謝

By Jacob
at 2017-06-03T14:57

[email protected]

By Jessica
at 2017-06-07T22:16

[email protected]. 感謝大大

By Susan
at 2017-06-10T00:09

[email protected]

By Edith
at 2017-06-11T23:14

[email protected] 謝謝大大

By Faithe
at 2017-06-16T01:08

[email protected] 感謝大大

By Rae
at 2017-06-21T00:57

[email protected] 感謝！！！

By Gary
at 2017-06-25T16:44

[email protected]

By Elizabeth
at 2017-06-29T18:39

[email protected] 謝謝～

By Caroline
at 2017-07-03T10:38

[email protected]推好心,先跪了

By Oliver
at 2017-07-04T00:42

[email protected] 謝謝!

By Lauren
at 2017-07-04T16:43

[email protected] 感謝分享!!

By Joe
at 2017-07-09T07:01

[email protected] 謝謝！

By Quintina
at 2017-07-09T09:31

推好心，謝謝[email protected]

By Olivia
at 2017-07-10T10:31

[email protected] 謝謝

By Enid
at 2017-07-13T01:43

[email protected] 感謝

By Eden
at 2017-07-13T18:28

[email protected]

By Rebecca
at 2017-07-15T17:06

[email protected] 非常感謝

By Oscar
at 2017-07-17T13:13

[email protected]

By Hedda
at 2017-07-18T21:39

[email protected] 謝謝

By Emily
at 2017-07-20T08:24

[email protected] 感恩

By Isabella
at 2017-07-24T16:19

[email protected]

By Ina
at 2017-07-27T02:36

[email protected] 謝謝！

By Isabella
at 2017-07-29T12:46

[email protected]

By Hamiltion
at 2017-07-31T18:09

[email protected] 謝謝好心人！

By Olive
at 2017-08-05T17:42

[email protected] 謝謝

By David
at 2017-08-08T18:14

[email protected] 謝謝

By Robert
at 2017-08-13T03:36

[email protected] 謝謝！

By Yuri
at 2017-08-15T18:00

[email protected]，超懷念這個功能！！謝謝：）

By Vanessa
at 2017-08-20T04:00

[email protected] 謝謝

By Joe
at 2017-08-21T18:57

[email protected]

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

[email protected] 感謝

By Ursula
at 2017-08-27T05:49

[email protected]

By Sarah
at 2017-08-30T23:57

[email protected] 謝謝～～～

By Lauren
at 2017-09-03T00:32

[email protected] 謝謝

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

[email protected] 謝謝

By Necoo
at 2017-09-05T03:44

[email protected] 感謝大德

By Necoo
at 2017-09-07T19:06

[email protected] 謝謝!

By Zenobia
at 2017-09-12T11:20

[email protected] 謝謝

By Eden
at 2017-09-14T15:52

[email protected]

By Elizabeth
at 2017-09-18T07:23

[email protected] 太感謝了!!!!

By Ursula
at 2017-09-21T04:55

[email protected] 謝謝

By Margaret
at 2017-09-25T19:01

[email protected] 謝謝！

By Hazel
at 2017-09-28T05:55

[email protected] 謝謝

By Freda
at 2017-09-28T18:17

[email protected] 謝謝！

By Donna
at 2017-09-28T23:58

[email protected] 感謝~

By Noah
at 2017-10-02T00:07

[email protected]

By Kelly
at 2017-10-06T02:41

推+1, [email protected]

By Charlie
at 2017-10-09T19:06

[email protected]

By Ula
at 2017-10-12T03:10

[email protected] 謝謝：）

By Donna
at 2017-10-12T06:31

[email protected] 謝謝～

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

[email protected] 感謝

By Olga
at 2017-10-18T16:53

[email protected] 謝謝

By Madame
at 2017-10-21T14:11

[email protected] 感謝你！！

By Emily
at 2017-10-21T16:33

[email protected] 感謝

By Emily
at 2017-10-23T08:37

[email protected] 謝謝您！

By Candice
at 2017-10-27T21:12

[email protected]

By Yuri
at 2017-10-30T11:23

[email protected] 謝謝！

By Isla
at 2017-10-31T04:18

[email protected] 謝謝!

By Carol
at 2017-11-01T00:04

[email protected] thx!!!

By Jake
at 2017-11-02T02:25

[email protected] 謝謝~ :)

By Charlie
at 2017-11-03T01:29

[email protected]

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

[email protected] 謝謝!

By Rebecca
at 2017-11-09T15:00

[email protected]

By Aaliyah
at 2017-11-11T12:09

[email protected]

By Dinah
at 2017-11-13T07:35

[email protected]

By Sandy
at 2017-11-16T19:05

[email protected] 感謝分享！

By Franklin
at 2017-11-18T01:52

[email protected] 推好心！

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

[email protected] 推好心謝謝！

By Mary
at 2017-11-22T07:16

[email protected] 謝謝！

By Susan
at 2017-11-25T03:56

[email protected]

By Jacob
at 2017-11-29T03:06

[email protected] 推推推！

By Freda
at 2017-12-03T09:27

[email protected] 謝謝

By Daniel
at 2017-12-06T08:56

[email protected] 謝謝！

By Zora
at 2017-12-09T02:09

[email protected] 謝謝你

By Elvira
at 2017-12-11T12:50

謝謝 [email protected]

By Mary
at 2017-12-14T10:57

[email protected] 感謝你

By Faithe
at 2017-12-16T03:27

[email protected] 感謝！

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

[email protected]

By Dora
at 2017-12-23T03:41

[email protected] 謝謝!

By Susan
at 2017-12-24T15:11

[email protected]

By Charlotte
at 2017-12-29T09:48

[email protected] 謝謝

By Christine
at 2018-01-03T08:22

[email protected] 感謝！！！

By Carol
at 2018-01-04T00:43

[email protected]. 謝謝！

By William
at 2018-01-08T00:56

[email protected]

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

[email protected] 謝謝！

By Kristin
at 2018-01-12T08:23

[email protected]

By Sandy
at 2018-01-15T09:44

[email protected]

By Elma
at 2018-01-18T05:34

[email protected] 謝謝!!!

By Edwina
at 2018-01-22T11:54

[email protected] 感謝!

By Joe
at 2018-01-23T21:20

[email protected] 謝謝!

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

[email protected]

By Dorothy
at 2018-01-31T20:40

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

By Dorothy
at 2018-02-05T18:23

沒有我就再認真一點做XDD

By Ina
at 2018-02-07T18:07

[email protected]

By Caitlin
at 2018-02-09T10:08

[email protected] 謝謝

By Necoo
at 2018-02-12T03:34

[email protected] 推好心謝謝！

By Ida
at 2018-02-15T16:15

[email protected] 感謝!!!

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

[email protected]. 感謝！

By Annie
at 2018-02-19T21:44

Deloitte 有

By Christine
at 2018-02-23T07:16

[email protected] 感謝您：)

By Agatha
at 2018-02-26T10:03

[email protected] 謝謝: )

By Agnes
at 2018-02-28T09:49

[email protected] 感謝

By Iris
at 2018-03-04T20:29

[email protected] 感謝！

By Enid
at 2018-03-08T14:39

[email protected] 感謝

By Hardy
at 2018-03-12T21:41

[email protected]

By Lucy
at 2018-03-15T01:22

[email protected] 感謝分享

By Frederica
at 2018-03-16T01:19

[email protected] 謝謝！！

By Kumar
at 2018-03-18T22:53

[email protected] 感謝分享！！！

By Victoria
at 2018-03-19T03:33

[email protected] 謝謝:)

By Agatha
at 2018-03-19T22:35

[email protected] 謝謝分享 K所有

By Rachel
at 2018-03-23T09:13

[email protected] 麻煩了！謝謝

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

[email protected].

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

[email protected]

By Eden
at 2018-03-28T23:15

[email protected]

By Robert
at 2018-04-01T05:20

[email protected] 謝謝大大

By Callum
at 2018-04-03T13:14

[email protected] 感謝大大分享

By Steve
at 2018-04-05T14:38

難得爆

By Frederica
at 2018-04-08T21:46

[email protected]

By Wallis
at 2018-04-13T11:02

[email protected]

By Jessica
at 2018-04-15T04:31

[email protected] 感謝

By George
at 2018-04-19T12:33

[email protected]

By John
at 2018-04-21T18:22

[email protected] 謝

By Olivia
at 2018-04-21T20:27

[email protected]

By Isla
at 2018-04-25T05:56

[email protected]。謝謝！！

By Isla
at 2018-04-29T18:03

[email protected]

By Frederica
at 2018-05-03T01:24

[email protected]

By Thomas
at 2018-05-03T19:03

[email protected] 謝謝

By Franklin
at 2018-05-06T14:02

[email protected] 謝謝！

By Susan
at 2018-05-10T05:28

[email protected] 謝謝！

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

[email protected] 謝謝！

By Doris
at 2018-05-13T08:02

[email protected] 謝謝!!

By Hazel
at 2018-05-16T07:46

[email protected] 謝謝！

By Isla
at 2018-05-19T21:46

[email protected]

By Andy
at 2018-05-22T14:45

[email protected] 謝謝您

By Olivia
at 2018-05-24T21:38

[email protected] 感謝！

By Elvira
at 2018-05-25T16:37

[email protected]

By Daniel
at 2018-05-26T06:32

[email protected] 感謝!

By Genevieve
at 2018-05-28T05:35

[email protected]

By Yedda
at 2018-05-30T01:58

[email protected] 謝謝

By Linda
at 2018-06-03T20:11

[email protected] 感恩~*^_^*

By Doris
at 2018-06-04T05:29

[email protected]
感謝~

By Elma
at 2018-06-06T12:02

[email protected] 謝謝

By Tom
at 2018-06-10T18:30

[email protected] 謝謝！

By Blanche
at 2018-06-12T06:57

[email protected] 謝謝!!

By Genevieve
at 2018-06-14T13:00

[email protected] 謝謝~~

By George
at 2018-06-18T14:45

[email protected] 謝謝～

By Frederic
at 2018-06-19T08:18

[email protected]

By Kumar
at 2018-06-20T09:14

[email protected]

By Steve
at 2018-06-20T11:41

[email protected] 謝謝您

By Genevieve
at 2018-06-24T20:49

[email protected] 謝謝

By Sarah
at 2018-06-25T22:24

[email protected] 謝謝

By Lauren
at 2018-06-30T18:07

[email protected]

By Quanna
at 2018-07-04T09:09

謝謝><

By Elma
at 2018-07-07T19:16

[email protected]

By Odelette
at 2018-07-11T12:30

yhshiao@outlook
com 謝謝大大!!!

By Rebecca
at 2018-07-13T01:24

[email protected] 感謝大大

By Noah
at 2018-07-15T04:34

[email protected] 謝謝,加個每日英文名言也許不錯^^

By Vanessa
at 2018-07-18T15:48

[email protected]謝謝唷

By Leila
at 2018-07-21T20:17

[email protected]

By Zenobia
at 2018-07-26T10:19

[email protected]

By Megan
at 2018-07-29T18:30

[email protected]

By Hardy
at 2018-08-01T16:30

[email protected] 感恩

By Anthony
at 2018-08-03T21:38

[email protected]

By Elizabeth
at 2018-08-04T03:36

[email protected]感恩

By Kyle
at 2018-08-04T19:58

[email protected] 謝謝！

By Isla
at 2018-08-09T05:55

[email protected] 謝謝!!!

By Odelette
at 2018-08-11T22:36

[email protected] 謝謝～！

By Annie
at 2018-08-14T19:28

[email protected]

By Jake
at 2018-08-19T04:35

[email protected] 謝謝！

By Madame
at 2018-08-23T08:39

[email protected]

By Xanthe
at 2018-08-25T15:34

[email protected]
感恩，不好意思我少打一個l

By Sarah
at 2018-08-27T00:15

[email protected]

By Delia
at 2018-08-31T17:51

[email protected]

By Donna
at 2018-09-02T11:10

[email protected] 感謝！

By Edwina
at 2018-09-03T00:43

[email protected] 感謝！

By George
at 2018-09-06T00:22

[email protected] 感恩

By Faithe
at 2018-09-10T04:14

[email protected] 謝謝！祝考試順利！

By Eartha
at 2018-09-14T14:16

[email protected] 謝謝

By Rosalind
at 2018-09-18T01:05

[email protected]

By Olivia
at 2018-09-20T10:23

[email protected]

By Hamiltion
at 2018-09-23T15:03

[email protected] 謝謝!

By Edwina
at 2018-09-24T13:10

[email protected]

By Wallis
at 2018-09-25T17:36

[email protected] 謝謝大大

By Hedda
at 2018-09-26T09:45

看一次推一次，拜託了！ [email protected]

By Charlie
at 2018-09-29T03:19

[email protected] 謝謝

By Madame
at 2018-10-03T11:17

[email protected] 感謝~

By Jessica
at 2018-10-06T01:35

[email protected] 謝謝~

By Ophelia
at 2018-10-10T03:48

[email protected]

By Callum
at 2018-10-12T14:19

[email protected]. 感謝！

By Caitlin
at 2018-10-16T02:29

[email protected] 謝謝你

By Charlotte
at 2018-10-20T03:43

[email protected] 謝謝~

By Dinah
at 2018-10-23T09:51

[email protected]
多謝

By Lydia
at 2018-10-28T04:57

[email protected] 感謝

By Isla
at 2018-10-31T11:06

[email protected]

By Olivia
at 2018-11-02T05:10

[email protected]

By Andrew
at 2018-11-04T13:10

[email protected] 樓主大大一生平安

By Queena
at 2018-11-05T03:16

[email protected] 感謝大大

By Dorothy
at 2018-11-09T02:20

[email protected]謝謝耶！

By Megan
at 2018-11-12T20:59

已收到，感謝

By Edwina
at 2018-11-14T03:13

收到了謝謝～

By Leila
at 2018-11-16T14:18

[email protected]謝謝！

By Daniel
at 2018-11-20T15:35

[email protected]，感謝

By Eartha
at 2018-11-23T18:28

[email protected] 謝謝！

By Victoria
at 2018-11-27T11:58

[email protected] 感謝大大~

By Mary
at 2018-11-28T01:07

[email protected] 謝謝你的分享

By Dora
at 2018-12-02T10:41

[email protected] 謝謝

By Daniel
at 2018-12-04T03:15

[email protected] 謝謝~

By Megan
at 2018-12-08T01:53

[email protected]

By Erin
at 2018-12-09T03:22

[email protected] 感謝大大!!

Related Posts

林蕙真中高會

By Noah
at 2017-03-08T18:40

徵林蕙真高等會計學新論上下冊及中等會計學新論上下冊煩請站內信報價台北市可面交謝謝 - ...

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

By Caitlin
at 2017-03-08T16:36

如題徵求目前北一會計師課程使用的中會課本及成會課本，欲出售請站內信報價，感謝 - ...

四大應屆外派上海

By Xanthe
at 2017-03-08T15:47

想請問版上有沒有大大有這樣的經驗某信義橘所提供了這樣的機會但都是由主要會計師分享很想瞭解實際狀況及心得以他開的條件基本上就是花錢買經驗因此想知道究竟值不值得謝謝各位大大了 - ...

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

By Ula
at 2017-03-08T10:46

收購審計準則公報合訂本 105/10版越新越好價格可以的話請私訊(低價尤佳) 可蝦皮交易更好 - ...

七八月美會夥伴

By Michael
at 2017-03-08T09:55

想要七八月去美國本土考，地點目前暫定舊金山(便宜且交通方便) 意者請私訊 ----- Sent from JPTT on my Asus ASUS_Z012DA. - ...