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

Eden avatar
By Eden
at 2017-03-12T01:13

Table of Contents

經過測試,Excel 2010也可以使用(我沒有2007可以測..)
如果因為一開始文章說只有Excel 2016和2013而沒有留信箱的人,
如果有需要請再留mail,很抱歉一樣截止到今天晚上12點

※ 引述《noworneverev (小朋友)》之銘言:
: 小魯之前在某四大實習,公司電腦Excel有他們自己的增益集,
: 裡面是各種做底稿會用到的功能,不知道其他事務所的Excel有沒有這樣的工具?
: 準備會計師太無聊就把一些我記得的功能寫出來,
: 這張圖是我現在開發出來的功能,年代久遠只記得自己用過的
: http://i.imgur.com/XpoRvsA.png
: 請教各位版上的前輩在工作上還需要用到哪些Excel的功能?
: 例如常用到的還是任何可以程式化的功能,我應該都可以試著coding
: 雖然還沒做UI美化,不過再加個50個功能應該不是問題,
: 如果有版友想試用看看可以推文留個信箱(截止到星期日24:00),我再寄給你
: (目前只有開發Excel2016 和 2013)
: 順便幫我看看有沒有Bug XD(目前這版有一個bug封裝完才想到)
: (請不要寄站內信 信箱已經爆了)

--
Tags: 會計

All Comments

James avatar
By James
at 2017-03-13T08:28
[email protected]
Hedwig avatar
By Hedwig
at 2017-03-18T06:28
[email protected]
Jake avatar
By Jake
at 2017-03-21T16:34
[email protected]
Oliver avatar
By Oliver
at 2017-03-25T15:09
[email protected]
Anonymous avatar
By Anonymous
at 2017-03-28T11:21
請問上次留過信箱的話,需要再留一次嗎?
Robert avatar
By Robert
at 2017-03-31T14:54
[email protected]
Michael avatar
By Michael
at 2017-04-02T11:27
[email protected] 謝謝
Emma avatar
By Emma
at 2017-04-05T18:18
[email protected]
Donna avatar
By Donna
at 2017-04-09T09:39
[email protected] 謝謝~
Ethan avatar
By Ethan
at 2017-04-11T09:48
[email protected]
Jessica avatar
By Jessica
at 2017-04-12T05:23
[email protected] 謝謝您
Anthony avatar
By Anthony
at 2017-04-14T13:55
[email protected] 謝謝
Belly avatar
By Belly
at 2017-04-16T14:10
[email protected]
Belly avatar
By Belly
at 2017-04-20T19:33
aaatooo@gmail
com. thx
Belly avatar
By Belly
at 2017-04-24T05:42
[email protected]
Enid avatar
By Enid
at 2017-04-25T03:14
[email protected] 謝謝
Megan avatar
By Megan
at 2017-04-28T03:20
[email protected] 謝謝
Franklin avatar
By Franklin
at 2017-04-30T04:52
[email protected]
Hedy avatar
By Hedy
at 2017-05-02T22:37
[email protected] 謝謝
Ophelia avatar
By Ophelia
at 2017-05-07T08:31
[email protected]
Eartha avatar
By Eartha
at 2017-05-11T03:50
[email protected] 謝謝!
Yedda avatar
By Yedda
at 2017-05-12T14:29
[email protected] 感謝
Annie avatar
By Annie
at 2017-05-17T02:48
[email protected] 感恩
Xanthe avatar
By Xanthe
at 2017-05-19T23:47
[email protected]
Connor avatar
By Connor
at 2017-05-20T08:52
[email protected]
Andy avatar
By Andy
at 2017-05-20T10:48
[email protected]
Lucy avatar
By Lucy
at 2017-05-22T23:07
[email protected]
Daniel avatar
By Daniel
at 2017-05-25T12:40
[email protected] 謝謝
Zanna avatar
By Zanna
at 2017-05-26T18:12
[email protected]
Sierra Rose avatar
By Sierra Rose
at 2017-05-31T14:30
[email protected] 感恩
Faithe avatar
By Faithe
at 2017-06-03T03:59
[email protected] 謝謝
Sierra Rose avatar
By Sierra Rose
at 2017-06-05T21:30
[email protected] 謝謝了!
Emma avatar
By Emma
at 2017-06-10T07:48
[email protected] 謝謝
Erin avatar
By Erin
at 2017-06-11T13:23
[email protected] 謝謝
Caroline avatar
By Caroline
at 2017-06-13T00:16
[email protected] 感恩
Jake avatar
By Jake
at 2017-06-14T20:05
[email protected]
Regina avatar
By Regina
at 2017-06-15T02:59
[email protected] 謝謝
Lauren avatar
By Lauren
at 2017-06-16T09:03
[email protected]感恩
Lily avatar
By Lily
at 2017-06-17T03:37
[email protected] 謝謝!
Odelette avatar
By Odelette
at 2017-06-18T16:17
[email protected] 謝謝
Anthony avatar
By Anthony
at 2017-06-23T07:06
[email protected] 謝謝您
Erin avatar
By Erin
at 2017-06-25T15:34
[email protected] 謝謝~
Margaret avatar
By Margaret
at 2017-06-28T19:42
[email protected]
Anthony avatar
By Anthony
at 2017-06-29T07:16
[email protected] 謝謝您
Ursula avatar
By Ursula
at 2017-06-30T15:16
[email protected] 感謝
Margaret avatar
By Margaret
at 2017-07-01T20:53
[email protected]
Margaret avatar
By Margaret
at 2017-07-04T01:16
[email protected] 謝謝
Necoo avatar
By Necoo
at 2017-07-04T18:30
[email protected] 謝謝
Adele avatar
By Adele
at 2017-07-09T16:09
[email protected] 謝謝
Gilbert avatar
By Gilbert
at 2017-07-11T01:07
[email protected] 謝謝
Ivy avatar
By Ivy
at 2017-07-11T21:25
[email protected] 謝謝
Daniel avatar
By Daniel
at 2017-07-12T04:45
[email protected] 謝謝!
Liam avatar
By Liam
at 2017-07-12T07:25
[email protected] 謝謝
Liam avatar
By Liam
at 2017-07-14T21:33
[email protected] 謝謝!
Hedwig avatar
By Hedwig
at 2017-07-16T00:23
[email protected]
Bennie avatar
By Bennie
at 2017-07-16T17:24
[email protected] 謝謝
Mary avatar
By Mary
at 2017-07-18T09:58
[email protected] 推推!
Olga avatar
By Olga
at 2017-07-20T10:57
[email protected] 謝謝!
Jack avatar
By Jack
at 2017-07-24T01:12
[email protected]謝謝
Olga avatar
By Olga
at 2017-07-25T14:46
[email protected]謝謝
Andy avatar
By Andy
at 2017-07-26T11:00
[email protected] 謝謝~
John avatar
By John
at 2017-07-29T16:55
[email protected] 謝謝
Carol avatar
By Carol
at 2017-08-01T01:42
[email protected]
Daniel avatar
By Daniel
at 2017-08-04T20:27
[email protected] TKS
Mason avatar
By Mason
at 2017-08-07T09:25
[email protected]
James avatar
By James
at 2017-08-09T22:03
[email protected] 謝謝
Freda avatar
By Freda
at 2017-08-10T23:54
[email protected]
Elvira avatar
By Elvira
at 2017-08-15T23:53
[email protected] 謝謝~
Selena avatar
By Selena
at 2017-08-17T08:37
[email protected] 謝謝
Kelly avatar
By Kelly
at 2017-08-19T07:55
[email protected]. 謝謝ㄝ
Candice avatar
By Candice
at 2017-08-23T08:56
[email protected] 謝謝
Jacob avatar
By Jacob
at 2017-08-26T21:35
[email protected] 感謝!
Belly avatar
By Belly
at 2017-08-27T03:08
[email protected]
Vanessa avatar
By Vanessa
at 2017-08-28T18:45
[email protected] 謝謝
Franklin avatar
By Franklin
at 2017-08-30T11:13
[email protected]
Mia avatar
By Mia
at 2017-09-03T09:21
[email protected]
Belly avatar
By Belly
at 2017-09-05T02:21
[email protected] TKS!
Belly avatar
By Belly
at 2017-09-05T07:10
[email protected]
Candice avatar
By Candice
at 2017-09-09T21:19
[email protected]
Oliver avatar
By Oliver
at 2017-09-14T11:24
[email protected] 謝謝
David avatar
By David
at 2017-09-19T09:22
[email protected] 謝謝您
Andrew avatar
By Andrew
at 2017-09-21T19:18
[email protected] 謝謝您
Elvira avatar
By Elvira
at 2017-09-26T18:28
[email protected] 謝謝
Steve avatar
By Steve
at 2017-09-30T06:14
[email protected]
Rae avatar
By Rae
at 2017-10-04T11:27
[email protected]
Andrew avatar
By Andrew
at 2017-10-09T08:34
[email protected] 謝謝
Irma avatar
By Irma
at 2017-10-09T21:58
[email protected]
謝謝您
Bennie avatar
By Bennie
at 2017-10-09T23:41
[email protected]
Thx
Oscar avatar
By Oscar
at 2017-10-11T02:56
[email protected] 謝謝
Heather avatar
By Heather
at 2017-10-12T10:14
[email protected]
Victoria avatar
By Victoria
at 2017-10-16T13:42
[email protected] 謝謝
Linda avatar
By Linda
at 2017-10-16T23:26
[email protected] 謝謝
Hedda avatar
By Hedda
at 2017-10-17T02:41
[email protected] 謝薛你
Joseph avatar
By Joseph
at 2017-10-18T20:57
哈哈沒有.tw
Necoo avatar
By Necoo
at 2017-10-23T17:29
[email protected]
Skylar Davis avatar
By Skylar Davis
at 2017-10-24T03:50
[email protected]. 感謝
Regina avatar
By Regina
at 2017-10-24T07:43
[email protected] 感謝
Emma avatar
By Emma
at 2017-10-27T23:42
[email protected] 感謝
Joseph avatar
By Joseph
at 2017-10-30T22:59
[email protected] 謝謝大大
David avatar
By David
at 2017-11-03T12:38
[email protected] 非常感謝!
Hardy avatar
By Hardy
at 2017-11-06T19:26
[email protected] 謝謝~~~
Daph Bay avatar
By Daph Bay
at 2017-11-10T13:37
[email protected]
謝謝
Joseph avatar
By Joseph
at 2017-11-13T19:27
[email protected]
謝謝您
Anthony avatar
By Anthony
at 2017-11-15T17:45
[email protected]
Jacky avatar
By Jacky
at 2017-11-19T16:57
[email protected]
Zenobia avatar
By Zenobia
at 2017-11-20T12:42
[email protected] 謝謝
Christine avatar
By Christine
at 2017-11-21T19:43
[email protected] 感恩!!
Belly avatar
By Belly
at 2017-11-26T14:53
[email protected]. 謝謝 辛苦了~
Connor avatar
By Connor
at 2017-11-29T03:14
[email protected]
謝謝!
Ursula avatar
By Ursula
at 2017-11-29T12:20
[email protected] thank you.
Jack avatar
By Jack
at 2017-12-01T20:32
[email protected]
感謝!
Ivy avatar
By Ivy
at 2017-12-06T00:10
[email protected]
Hedy avatar
By Hedy
at 2017-12-08T05:32
[email protected] 謝謝
Poppy avatar
By Poppy
at 2017-12-11T03:38
[email protected] 謝謝
Hedwig avatar
By Hedwig
at 2017-12-15T07:11
[email protected],謝謝!
Una avatar
By Una
at 2017-12-18T07:15
[email protected] 謝謝!
Selena avatar
By Selena
at 2017-12-18T15:26
[email protected]
Andy avatar
By Andy
at 2017-12-19T16:46
[email protected] 謝謝
Victoria avatar
By Victoria
at 2017-12-21T13:11
[email protected],謝謝您
Liam avatar
By Liam
at 2017-12-22T05:08
[email protected] 謝謝!
Genevieve avatar
By Genevieve
at 2017-12-24T10:27
[email protected] 謝謝
Mary avatar
By Mary
at 2017-12-25T06:48
[email protected] 謝謝您
Olga avatar
By Olga
at 2017-12-29T15:50
[email protected] 感謝
John avatar
By John
at 2017-12-31T07:24
[email protected] 謝謝
Isla avatar
By Isla
at 2018-01-05T01:25
[email protected] 謝謝
Olga avatar
By Olga
at 2018-01-07T05:18
[email protected] 感恩
John avatar
By John
at 2018-01-10T10:54
[email protected] 謝謝
Quanna avatar
By Quanna
at 2018-01-10T14:28
[email protected] 謝謝你
Susan avatar
By Susan
at 2018-01-12T06:48
[email protected] 謝謝
Dorothy avatar
By Dorothy
at 2018-01-16T15:33
[email protected] 謝謝
Kelly avatar
By Kelly
at 2018-01-21T05:32
[email protected] 感恩
Isla avatar
By Isla
at 2018-01-22T15:31
[email protected] 謝謝您~
Aaliyah avatar
By Aaliyah
at 2018-01-24T22:01
[email protected] 謝謝!!
Hazel avatar
By Hazel
at 2018-01-25T09:07
[email protected] 謝謝您
Belly avatar
By Belly
at 2018-01-29T13:34
[email protected] 謝謝!
Quintina avatar
By Quintina
at 2018-02-01T01:54
[email protected] 謝謝
Thomas avatar
By Thomas
at 2018-02-02T17:37
[email protected] 謝謝
Ivy avatar
By Ivy
at 2018-02-06T16:01
[email protected]
Jake avatar
By Jake
at 2018-02-11T11:57
[email protected]
Sierra Rose avatar
By Sierra Rose
at 2018-02-12T15:37
感謝您~
Oliver avatar
By Oliver
at 2018-02-13T20:07
[email protected]
謝謝你的熱心!
Caitlin avatar
By Caitlin
at 2018-02-18T08:53
[email protected] 謝謝您
Tristan Cohan avatar
By Tristan Cohan
at 2018-02-20T12:43
[email protected]
Irma avatar
By Irma
at 2018-02-21T12:45
[email protected] 謝謝您
Victoria avatar
By Victoria
at 2018-02-23T02:56
[email protected]謝謝
Eartha avatar
By Eartha
at 2018-02-26T18:18
[email protected] 感激!
Ingrid avatar
By Ingrid
at 2018-02-27T13:34
[email protected] 謝謝
Genevieve avatar
By Genevieve
at 2018-03-02T08:18
[email protected],謝謝N大
David avatar
By David
at 2018-03-05T03:26
[email protected]
謝謝:)
Jessica avatar
By Jessica
at 2018-03-06T15:21
[email protected] 謝謝
Margaret avatar
By Margaret
at 2018-03-06T20:24
[email protected] 謝謝!
Catherine avatar
By Catherine
at 2018-03-10T04:02
[email protected] 謝謝您:)
Blanche avatar
By Blanche
at 2018-03-11T22:38
[email protected] 非常謝謝你
Oliver avatar
By Oliver
at 2018-03-16T21:46
[email protected] 太感謝您,好人有福報!!
Regina avatar
By Regina
at 2018-03-18T16:25
[email protected]
Anonymous avatar
By Anonymous
at 2018-03-20T21:48
[email protected] 感謝您的無私分享
Annie avatar
By Annie
at 2018-03-25T09:20
[email protected] 不好意思剛才key錯 這個才
對 謝謝
Isla avatar
By Isla
at 2018-03-28T09:33
[email protected] 謝謝!!!
Zanna avatar
By Zanna
at 2018-04-02T08:15
[email protected] 謝謝!
Heather avatar
By Heather
at 2018-04-04T01:03
[email protected]
Anthony avatar
By Anthony
at 2018-04-08T16:58
[email protected] 謝謝!
Dinah avatar
By Dinah
at 2018-04-12T00:45
[email protected]
Quanna avatar
By Quanna
at 2018-04-13T16:49
[email protected]
Elma avatar
By Elma
at 2018-04-16T23:39
[email protected] 謝謝分享~
Tracy avatar
By Tracy
at 2018-04-19T09:24
[email protected] 謝謝~
Robert avatar
By Robert
at 2018-04-23T17:48
[email protected],麻煩您了。
Candice avatar
By Candice
at 2018-04-27T08:49
[email protected] 感謝您了 !
Hedwig avatar
By Hedwig
at 2018-04-28T03:39
[email protected] 謝謝您
Madame avatar
By Madame
at 2018-05-02T09:13
[email protected]
Queena avatar
By Queena
at 2018-05-03T20:24
[email protected] 謝謝您
Charlotte avatar
By Charlotte
at 2018-05-07T21:33
[email protected] 謝謝您
Jacky avatar
By Jacky
at 2018-05-10T09:46
[email protected] 謝謝你~
Madame avatar
By Madame
at 2018-05-11T14:33
[email protected] 謝謝你(上個錯了
Olga avatar
By Olga
at 2018-05-12T07:37
[email protected]
感恩
Isla avatar
By Isla
at 2018-05-15T06:31
[email protected] 感謝~
Hedy avatar
By Hedy
at 2018-05-16T02:05
[email protected] 感恩
Tom avatar
By Tom
at 2018-05-19T09:46
[email protected] 謝謝
James avatar
By James
at 2018-05-21T20:39
[email protected]
Donna avatar
By Donna
at 2018-05-21T22:58
謝謝~
Edith avatar
By Edith
at 2018-05-22T14:31
[email protected]謝謝!
Eartha avatar
By Eartha
at 2018-05-24T12:31
[email protected]
謝謝!!!
Jack avatar
By Jack
at 2018-05-29T04:47
[email protected] 感謝您~
Olga avatar
By Olga
at 2018-05-30T05:32
[email protected] 謝謝~
Lydia avatar
By Lydia
at 2018-06-01T07:02
[email protected] 謝謝
Dinah avatar
By Dinah
at 2018-06-01T20:00
[email protected]
謝謝!!
Bethany avatar
By Bethany
at 2018-06-03T22:07
[email protected] 麻煩了,謝謝你。
Isabella avatar
By Isabella
at 2018-06-04T17:23
[email protected] 謝謝!
Frederica avatar
By Frederica
at 2018-06-04T21:59
[email protected] 謝謝您><
John avatar
By John
at 2018-06-08T17:14
[email protected] 還可跟嗎 謝謝
Dinah avatar
By Dinah
at 2018-06-13T15:57
謝謝泥
Lily avatar
By Lily
at 2018-06-15T22:24
已收到,感謝
Liam avatar
By Liam
at 2018-06-18T06:28
[email protected] 還可以加一嗎..謝謝~~
Barb Cronin avatar
By Barb Cronin
at 2018-06-19T04:49
現在才看QQ 不知道還可不可以跟 [email protected]
Harry avatar
By Harry
at 2018-06-20T00:47
[email protected] 麻煩了,感謝
Gary avatar
By Gary
at 2018-06-22T02:48
[email protected] QQ還來得及嗎
Rachel avatar
By Rachel
at 2018-06-27T00:38
[email protected]謝謝
Olive avatar
By Olive
at 2018-06-29T16:57
[email protected]
Quanna avatar
By Quanna
at 2018-07-01T10:55
[email protected]
Kristin avatar
By Kristin
at 2018-07-04T06:26
(抱歉剛剛才看到,麻煩您了QQ
Lily avatar
By Lily
at 2018-07-05T11:24
[email protected] 抱歉有點遲
Elvira avatar
By Elvira
at 2018-07-07T07:01
[email protected] 謝謝
James avatar
By James
at 2018-07-07T22:43
[email protected]
David avatar
By David
at 2018-07-09T06:18
[email protected] (抱歉,前天留錯,謝謝)
Ophelia avatar
By Ophelia
at 2018-07-09T15:41
[email protected]
希望還可以收到!謝謝~
Susan avatar
By Susan
at 2018-07-14T03:23
[email protected] 希望還能收到 麻煩了
Wallis avatar
By Wallis
at 2018-07-16T10:11
[email protected]
Joe avatar
By Joe
at 2018-07-16T16:43
[email protected]
Dorothy avatar
By Dorothy
at 2018-07-19T18:44
感謝 已收到
Damian avatar
By Damian
at 2018-07-19T21:25
謝謝 已收到~~~
Andy avatar
By Andy
at 2018-07-21T14:47
收到 感謝
Una avatar
By Una
at 2018-07-22T10:37
己收到,感謝。
Tom avatar
By Tom
at 2018-07-26T07:34
[email protected]
Heather avatar
By Heather
at 2018-07-30T14:26
麻煩你惹,謝謝
Lauren avatar
By Lauren
at 2018-08-01T16:18
[email protected]
麻煩了!謝謝~~
Ula avatar
By Ula
at 2018-08-05T04:12
已收到,感謝您!
Regina avatar
By Regina
at 2018-08-07T07:42
[email protected] 謝謝你
Emma avatar
By Emma
at 2018-08-11T19:00
[email protected] 謝謝
Dorothy avatar
By Dorothy
at 2018-08-15T10:27
[email protected]
Iris avatar
By Iris
at 2018-08-18T21:49
[email protected]
Emma avatar
By Emma
at 2018-08-22T20:52
[email protected]
Catherine avatar
By Catherine
at 2018-08-24T16:27
[email protected] thx
Yedda avatar
By Yedda
at 2018-08-25T07:04
[email protected] 謝謝你
Hedy avatar
By Hedy
at 2018-08-28T09:35
[email protected] 感謝~
Puput avatar
By Puput
at 2018-08-28T23:51
[email protected]
謝謝您
Charlotte avatar
By Charlotte
at 2018-09-01T03:13
[email protected]

有關備供出售金融資產

Dinah avatar
By Dinah
at 2017-03-11T23:08
http://i.imgur.com/cqrAEsF.jpg 備供出售金融資產公允價值變動計入OCI 但股利又要計入當期損益不是很不合理嗎? 我看老師後面是用清算股利的作法 但現在不是沒有清算股利了嗎? 謝謝 - ...

請問OCI

Olive avatar
By Olive
at 2017-03-11T22:31
請問將期末將OCI轉結到其他權益算是 分錄過帳試算調整結帳編表的那一個程序啊 算是結帳嗎? 可是結帳不是將虛帳戶之餘額歸0 那OCI算虛帳戶嘍 謝謝 - ...

請問有關普通股帳面價值

Kelly avatar
By Kelly
at 2017-03-11T22:16
http://i.imgur.com/Dj3LRSX.jpg 請問第14題答案為何不是b (180000+36000+15000+120000)/18000=19.5 正確答案是A 為什麼好像沒把保留營餘加入 - ...

104年薦任升等考試-中會

Dinah avatar
By Dinah
at 2017-03-11T17:05
104年薦任升等考試-中級會計學-選擇題 第7題 油達公司於X1年初,將帳面價值$46,000,000、公允價值$50,000,000 之建築物, 以$45,000,000 賣給歐斯公司,又立即以每月$40,000 向歐斯公司租回使用 2 年。 若此項租賃並未移轉附屬於資產所有權之幾乎所有風險與報酬,當時之 ...

請問台中有北一補習班嗎?

Ophelia avatar
By Ophelia
at 2017-03-11T16:24
想請問大家台中有北一補習班嗎? 因為打過去發現電話是空號 - ...