Re: [請益] 關於事務所 Excel的Tick Mark

作者noworneverev (小朋友)

看板Accounting

標題Re: [請益] 關於事務所 Excel的Tick Mark

時間Sun Mar 12 01:13:03 2017

經過測試，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封裝完才想到) : (請不要寄站內信信箱已經爆了) -- ※ 發信站: 批踢踢實業坊(ptt.cc), 來自: 111.253.39.218 ※ 文章網址: https://www.ptt.cc/bbs/Accounting/M.1489252397.A.B54.html

推 littlesnight: [email protected] 03/12 01:17

推 conk: [email protected] 03/12 01:19

推 len83502: [email protected] 03/12 01:26

推 kmnridq: [email protected] 03/12 01:31

推 acy2567: 請問上次留過信箱的話，需要再留一次嗎？ 03/12 01:58

不用

推 boob0220: [email protected] 03/12 02:19

※ 編輯: noworneverev (111.253.39.218), 03/12/2017 02:50:44

推 tom1693: [email protected] 謝謝 03/12 02:57

推 holga1986: [email protected] 03/12 03:52

推 phoenix0714: [email protected] 謝謝~ 03/12 04:41

推 hccx94: [email protected] 03/12 04:52

推 jiaronglucky: [email protected] 謝謝您 03/12 06:46

推 LighToP: [email protected] 謝謝 03/12 07:48

推 smallsha: [email protected] 03/12 07:49

推 jack200200: aaatooo@gmail 03/12 08:03

→ jack200200: com. thx 03/12 08:03

推 Hugh0303: [email protected] 03/12 08:13

推 endicool: [email protected] 謝謝 03/12 08:20

推 indesign: [email protected] 謝謝 03/12 08:30

推 lupalupa: [email protected] 03/12 08:40

推 kkuma: [email protected] 謝謝 03/12 08:42

推 bbb88163: [email protected] 03/12 09:04

推 bananakobe: [email protected] 謝謝！ 03/12 09:15

推 rexlin: [email protected] 感謝 03/12 09:20

推 lispfeng: [email protected] 感恩 03/12 09:34

推 kj799: [email protected] 03/12 09:43

推 ludwickfan: [email protected] 03/12 09:45

推 CMTC: [email protected] 03/12 09:46

推 st8624714: [email protected] 03/12 10:12

推 ariel19: [email protected] 謝謝 03/12 10:23

推 zebrainc: [email protected] 03/12 10:35

推 stellasuchin: [email protected] 感恩 03/12 10:40

推 annayjudy: [email protected] 謝謝 03/12 10:44

推 iwillbeaceo: [email protected] 謝謝了！ 03/12 10:55

推 scott0717: [email protected] 謝謝 03/12 11:04

推 friendegg: [email protected] 謝謝 03/12 11:12

推 Ncoolo: [email protected] 感恩 03/12 11:16

推 uunina: [email protected] 03/12 11:18

推 acecm: [email protected] 謝謝 03/12 11:23

推 bill810103: [email protected]感恩 03/12 11:27

推 swear: [email protected] 謝謝！ 03/12 11:34

推 earl0528: [email protected] 謝謝 03/12 11:38

推 gjes87067: [email protected] 謝謝您 03/12 11:40

推 shihchia: [email protected] 謝謝～ 03/12 11:46

推 LuisSuarez: [email protected] 03/12 11:56

推 pity: [email protected] 謝謝您 03/12 12:03

推 Powertalk1: [email protected] 感謝 03/12 12:03

推 natureliting: [email protected] 03/12 12:19

推 mandy810519: [email protected] 謝謝 03/12 12:32

推 mesopotamie: [email protected] 謝謝 03/12 12:41

推 allen731103: [email protected] 謝謝 03/12 12:49

→ peix: [email protected] 謝謝 03/12 12:52

推 sandy3542200: [email protected] 謝謝 03/12 12:54

推 shidoirokui: [email protected] 謝謝！ 03/12 12:55

推 aya0203: [email protected] 謝謝 03/12 13:03

推 hspss896329: [email protected] 謝謝！ 03/12 13:11

推 kinty: [email protected] 03/12 13:13

推 aa2267006: [email protected] 謝謝 03/12 13:14

推 easypasta: [email protected] 推推! 03/12 13:19

推 versatile770: [email protected] 謝謝！ 03/12 13:25

推 ivyxxx620: [email protected]謝謝 03/12 13:26

推 null0826: [email protected]謝謝 03/12 13:39

推 dana1988: [email protected] 謝謝~ 03/12 13:53

推 bestneil: [email protected] 謝謝 03/12 13:55

推 nooooooooon: [email protected] 03/12 13:57

→ louis99: [email protected] TKS 03/12 14:08

推 jay60119: [email protected] 03/12 14:12

推 Zhenx20805: [email protected] 謝謝 03/12 14:17

推 estalluvia: [email protected] 03/12 14:40

推 lyly555: [email protected] 謝謝～ 03/12 14:46

推 seebrave: [email protected] 謝謝 03/12 14:50

推 fish523420: [email protected]. 謝謝ㄝ 03/12 14:55

推 rabbitpei: [email protected] 謝謝 03/12 15:20

→ purplechen: [email protected] 感謝！ 03/12 15:21

推 x4970251134: [email protected] 03/12 15:54

推 thbetray: [email protected] 謝謝 03/12 16:06

推 rubysecret: [email protected] 03/12 16:12

→ pagenotfound: [email protected] 03/12 16:39

推 Cordierite: [email protected] TKS! 03/12 16:39

推 JIMMLIN: [email protected] 03/12 16:41

推 linmengkai: [email protected] 03/12 16:55

推 yoshiai: [email protected] 謝謝 03/12 16:56

推 lazy9969: [email protected] 謝謝您 03/12 17:12

推 sky252330: [email protected] 謝謝您 03/12 17:14

推 ckm5695: [email protected] 謝謝 03/12 17:17

推 anguskenneth: [email protected] 03/12 17:33

推 ksheena21: [email protected] 03/12 17:36

推 ioioccc: [email protected] 謝謝 03/12 17:42

推 WanRenFu: [email protected] 03/12 17:46

→ WanRenFu: 謝謝您 03/12 17:46

推 Cactusman: [email protected] 03/12 17:56

推 helen28mth: [email protected] 謝謝 03/12 17:56

→ Cactusman: Thx 03/12 17:56

推 headiness: [email protected] 03/12 17:59

推 aewul: [email protected] 謝謝 03/12 18:18

推 dg56655: [email protected] 謝謝 03/12 18:18

推 pipipencil: [email protected] 謝薛你 03/12 18:19

推 pipipencil: 哈哈沒有.tw 03/12 18:20

推 xplendid: [email protected] 03/12 18:22

推 j199104: [email protected]. 感謝 03/12 18:26

推 a0991259619: [email protected] 感謝 03/12 18:31

推 ETyii: [email protected] 感謝 03/12 18:42

推 samch2003: [email protected] 謝謝大大 03/12 18:43

推 darwiniee: [email protected] 非常感謝！ 03/12 18:54

推 jiajugo: [email protected] 謝謝~~~ 03/12 18:59

推 bano: [email protected] 03/12 19:29

→ bano: 謝謝 03/12 19:29

推 xltye: [email protected] 03/12 19:40

→ xltye: 謝謝您 03/12 19:40

推 popoyuiyui: [email protected] 03/12 19:44

推 nongmei: [email protected] 03/12 19:50

推 start9527: [email protected] 謝謝 03/12 19:57

推 tebd123: [email protected] 感恩!! 03/12 20:01

推 boyambrose: [email protected]. 謝謝辛苦了~ 03/12 20:06

推 Ravenclaw: [email protected] 03/12 20:09

→ Ravenclaw: 謝謝！ 03/12 20:09

推 Mercy5963: [email protected] thank you. 03/12 20:16

推 whmoioi: [email protected] 03/12 20:19

→ whmoioi: 感謝！ 03/12 20:19

推 loveklimt: [email protected] 03/12 20:20

推 da19910721: [email protected] 謝謝 03/12 20:21

推 d9321003: [email protected] 謝謝 03/12 20:29

推 Kyra: [email protected]，謝謝！ 03/12 20:31

推 jgjian: [email protected] 謝謝! 03/12 20:35

推 a9101522523: [email protected] 03/12 20:38

推 potato6202: [email protected] 謝謝 03/12 20:41

推 whjjacky: [email protected],謝謝您 03/12 20:41

推 copicogg: [email protected] 謝謝! 03/12 20:47

推 annabelle613: [email protected] 謝謝 03/12 20:48

推 peter8416305: [email protected] 謝謝您 03/12 20:56

推 JackLu: [email protected] 感謝 03/12 21:02

推 calaca: [email protected] 謝謝 03/12 21:02

推 imaa: [email protected] 謝謝 03/12 21:09

推 Richee1996: [email protected] 感恩 03/12 21:09

推 mandygirl: [email protected] 謝謝 03/12 21:11

推 johnson7692: [email protected] 謝謝你 03/12 21:19

推 Liha1002: [email protected] 謝謝 03/12 21:20

推 JacobKuo: [email protected] 謝謝 03/12 21:22

推 bearchun1: [email protected] 感恩 03/12 21:30

推 johnsu: [email protected] 謝謝您~ 03/12 21:35

推 littleamas: [email protected] 謝謝!! 03/12 21:41

推 alex19830510: [email protected] 謝謝您 03/12 21:45

推 sherry200429: [email protected] 謝謝！ 03/12 21:45

推 teresavk: [email protected] 謝謝 03/12 21:47

推 sarah55885: [email protected] 謝謝 03/12 21:47

推 le81224: [email protected] 03/12 21:49

推 whale1112: [email protected] 03/12 21:53

→ whale1112: 感謝您~ 03/12 21:54

推 ttocs406: [email protected] 03/12 21:56

→ ttocs406: 謝謝你的熱心！ 03/12 21:56

推 anarch: [email protected] 謝謝您 03/12 22:01

推 cl3her: [email protected] 03/12 22:02

推 ghost159: [email protected] 謝謝您 03/12 22:04

推 likez1235: [email protected]謝謝 03/12 22:04

推 lukecoke: [email protected] 感激！ 03/12 22:07

推 yijing595: [email protected] 謝謝 03/12 22:07

推 lunki86620: [email protected]，謝謝N大 03/12 22:10

推 jane19881229: [email protected] 03/12 22:11

→ jane19881229: 謝謝:) 03/12 22:11

推 iolk: [email protected] 謝謝 03/12 22:15

推 s710204: [email protected] 謝謝！ 03/12 22:20

推 nashQ: [email protected] 謝謝您：） 03/12 22:21

推 Ewighket: [email protected] 非常謝謝你 03/12 22:22

推 lvpsa: [email protected] 太感謝您，好人有福報!! 03/12 22:27

推 petty840312: [email protected] 03/12 22:30

推 masonlin: [email protected] 感謝您的無私分享 03/12 22:32

推 masonlin: [email protected] 不好意思剛才key錯這個才 03/12 22:37

→ masonlin: 對謝謝 03/12 22:37

推 ken60816: [email protected] 謝謝！！！ 03/12 22:37

推 jsjjjjej: [email protected] 謝謝! 03/12 22:48

推 loveama: [email protected] 03/12 22:48

推 karolte: [email protected] 謝謝! 03/12 22:58

推 onepiece46: [email protected] 03/12 22:58

推 senten: [email protected] 03/12 22:59

推 sdyhs: [email protected] 謝謝分享~ 03/12 23:02

推 ptpter: [email protected] 謝謝～ 03/12 23:03

推 wyr0111: [email protected]，麻煩您了。 03/12 23:04

推 jamic: [email protected] 感謝您了 ! 03/12 23:05

推 bbyyy: [email protected] 謝謝您 03/12 23:10

推 foryou217: [email protected] 03/12 23:10

推 leir: [email protected] 謝謝您 03/12 23:11

推 lnwnl: [email protected] 謝謝您 03/12 23:12

推 inoice: [email protected] 謝謝你～ 03/12 23:19

→ inoice: [email protected] 謝謝你（上個錯了 03/12 23:20

推 xxhuang: [email protected] 03/12 23:21

→ xxhuang: 感恩 03/12 23:21

推 ahhh555: [email protected] 感謝～ 03/12 23:22

推 juneko: [email protected] 感恩 03/12 23:23

推 garnett2255: [email protected] 謝謝 03/12 23:24

推 chrisblr: [email protected] 03/12 23:27

→ chrisblr: 謝謝~ 03/12 23:29

推 jecatai: [email protected]謝謝！ 03/12 23:32

推 lespeci: [email protected] 03/12 23:34

→ lespeci: 謝謝!!! 03/12 23:34

推 gdchess: [email protected] 感謝您~ 03/12 23:38

推 JYS024: [email protected] 謝謝~ 03/12 23:43

推 yunchuchu: [email protected] 謝謝 03/12 23:47

推 nanaguan: [email protected] 03/12 23:48

→ nanaguan: 謝謝!! 03/12 23:48

推 huangwen: [email protected] 麻煩了，謝謝你。 03/13 00:41

推 rting0758: [email protected] 謝謝！ 03/13 00:54

推 nihcwen: [email protected] 謝謝您>< 03/13 01:03

推 texa565554: [email protected] 還可跟嗎謝謝 03/13 01:15

以上皆已寄出 ※ 編輯: noworneverev (111.253.29.169), 03/13/2017 01:34:56

推 kmtsop: 謝謝泥 03/13 01:46

推 ACC810919: 已收到，感謝 03/13 02:33

推 Ba11dontlie: [email protected] 還可以加一嗎..謝謝～～ 03/13 03:35

推 bk201xx: 現在才看QQ 不知道還可不可以跟 [email protected] 謝 03/13 08:43

→ bk201xx: 謝 03/13 08:43

推 kiddlue: [email protected] 麻煩了,感謝 03/13 10:56

推 tantai99: [email protected] QQ還來得及嗎 03/13 15:19

推 a5971532: [email protected]謝謝 03/13 16:35

推 pat6212: [email protected] 03/13 19:27

推 hehohoe: [email protected] 03/13 19:30

→ hehohoe: （抱歉剛剛才看到，麻煩您了QQ 03/13 19:31

推 hamasakino: [email protected] 抱歉有點遲 03/13 19:43

推 kumicky: [email protected] 謝謝 03/13 19:52

推 helen826: [email protected] 03/13 20:06

推 qq168: [email protected] (抱歉，前天留錯，謝謝) 03/13 21:07

推 wow01010: [email protected] 03/13 21:28

→ wow01010: 希望還可以收到！謝謝～ 03/13 21:28

推 saske31429: [email protected] 希望還能收到麻煩了 03/13 23:27

推 lancerjump: [email protected] 03/13 23:42

推 alize: [email protected] 03/14 00:05

都寄了，接下來不會再寄了，請等我把完成版發佈吧 ※ 編輯: noworneverev (111.253.29.169), 03/14/2017 00:52:49

推 hamasakino: 感謝已收到 03/14 06:37

推 bk201xx: 謝謝已收到~~~ 03/14 08:54

推 saske31429: 收到感謝 03/14 11:06

推 qq168: 己收到，感謝。 03/14 12:47

推 j7862278622: [email protected] 03/14 19:08

→ j7862278622: 麻煩你惹，謝謝 03/14 19:09

推 yushien: [email protected] 03/14 19:20

→ yushien: 麻煩了！謝謝～～ 03/14 19:20

推 acy2567: 已收到，感謝您！ 03/15 13:08

推 neall8987g: [email protected] 謝謝你 03/15 13:18

推 yahui413: [email protected] 謝謝 03/15 17:39

推 tinakao2613: [email protected] 03/15 23:33

推 Tactician: [email protected] 03/16 08:26

推 xx19908: [email protected] 03/17 08:11

推 h41615: [email protected] thx 03/17 09:21

推 stu87192: [email protected] 謝謝你 03/20 03:36

推 aiko3508: [email protected] 感謝～ 03/21 05:57

推 aileenyihsin: [email protected] 03/24 20:39

推 aileenyihsin: 謝謝您 03/24 20:39

推 st81221: [email protected] 02/11 13:43