[請益] 關於事務所 Excel的Tick Mark
看板Accounting作者noworneverev (小朋友)時間7年前 (2017/03/09 01:09)推噓230(230推 0噓 12→)留言242則, 230人參與討論串1/2 (看更多)
小魯之前在某四大實習,公司電腦Excel有他們自己的增益集,
裡面是各種做底稿會用到的功能,不知道其他事務所的Excel有沒有這樣的工具?
準備會計師太無聊就把一些我記得的功能寫出來,
這張圖是我現在開發出來的功能,年代久遠只記得自己用過的
http://i.imgur.com/XpoRvsA.png
請教各位版上的前輩在工作上還需要用到哪些Excel的功能?
例如常用到的還是任何可以程式化的功能,我應該都可以試著coding
雖然還沒做UI美化,不過再加個50個功能應該不是問題,
如果有版友想試用看看可以推文留個信箱(截止到星期日24:00),我再寄給你
(目前只有開發Excel2016 和 2013)
順便幫我看看有沒有Bug XD(目前這版有一個bug封裝完才想到)
(請不要寄站內信 信箱已經爆了)
--
※ 發信站: 批踢踢實業坊(ptt.cc), 來自: 111.253.4.29
※ 文章網址: https://www.ptt.cc/bbs/Accounting/M.1488992944.A.0A2.html
推
03/09 08:59, , 1F
03/09 08:59, 1F
※ 編輯: noworneverev (111.253.8.48), 03/09/2017 09:11:11
→
03/09 09:20, , 2F
03/09 09:20, 2F
推
03/09 11:49, , 3F
03/09 11:49, 3F
推
03/09 12:22, , 4F
03/09 12:22, 4F
推
03/09 12:23, , 5F
03/09 12:23, 5F
推
03/09 12:28, , 6F
03/09 12:28, 6F
推
03/09 12:32, , 7F
03/09 12:32, 7F
推
03/09 12:33, , 8F
03/09 12:33, 8F
推
03/09 12:48, , 9F
03/09 12:48, 9F
推
03/09 12:48, , 10F
03/09 12:48, 10F
推
03/09 12:55, , 11F
03/09 12:55, 11F
推
03/09 13:07, , 12F
03/09 13:07, 12F
推
03/09 13:08, , 13F
03/09 13:08, 13F
推
03/09 13:14, , 14F
03/09 13:14, 14F
我會再加點東西,禮拜日統一寄出
※ 編輯: noworneverev (111.253.8.48), 03/09/2017 13:20:35
推
03/09 13:27, , 15F
03/09 13:27, 15F
→
03/09 13:50, , 16F
03/09 13:50, 16F
推
03/09 13:54, , 17F
03/09 13:54, 17F
推
03/09 14:01, , 18F
03/09 14:01, 18F
推
03/09 14:04, , 19F
03/09 14:04, 19F
推
03/09 14:05, , 20F
03/09 14:05, 20F
推
03/09 14:16, , 21F
03/09 14:16, 21F
推
03/09 14:19, , 22F
03/09 14:19, 22F
推
03/09 14:31, , 23F
03/09 14:31, 23F
推
03/09 14:43, , 24F
03/09 14:43, 24F
推
03/09 15:11, , 25F
03/09 15:11, 25F
推
03/09 15:13, , 26F
03/09 15:13, 26F
推
03/09 15:24, , 27F
03/09 15:24, 27F
推
03/09 15:33, , 28F
03/09 15:33, 28F
推
03/09 15:42, , 29F
03/09 15:42, 29F
推
03/09 15:46, , 30F
03/09 15:46, 30F
推
03/09 15:52, , 31F
03/09 15:52, 31F
推
03/09 16:45, , 32F
03/09 16:45, 32F
推
03/09 16:57, , 33F
03/09 16:57, 33F
推
03/09 16:59, , 34F
03/09 16:59, 34F
推
03/09 17:04, , 35F
03/09 17:04, 35F
推
03/09 17:18, , 36F
03/09 17:18, 36F
推
03/09 17:24, , 37F
03/09 17:24, 37F
還有 166 則推文
還有 6 段內文
推
03/11 16:55, , 204F
03/11 16:55, 204F
推
03/11 17:58, , 205F
03/11 17:58, 205F
推
03/11 18:03, , 206F
03/11 18:03, 206F
推
03/11 20:35, , 207F
03/11 20:35, 207F
推
03/11 21:12, , 208F
03/11 21:12, 208F
推
03/11 21:13, , 209F
03/11 21:13, 209F
推
03/11 21:29, , 210F
03/11 21:29, 210F
推
03/11 21:39, , 211F
03/11 21:39, 211F
推
03/11 21:45, , 212F
03/11 21:45, 212F
推
03/11 22:30, , 213F
03/11 22:30, 213F
推
03/11 22:59, , 214F
03/11 22:59, 214F
推
03/11 22:59, , 215F
03/11 22:59, 215F
推
03/11 23:22, , 216F
03/11 23:22, 216F
推
03/12 00:09, , 217F
03/12 00:09, 217F
推
03/12 00:11, , 218F
03/12 00:11, 218F
推
03/12 00:29, , 219F
03/12 00:29, 219F
推
03/12 01:07, , 220F
03/12 01:07, 220F
推
03/12 01:43, , 221F
03/12 01:43, 221F
推
03/12 03:16, , 222F
03/12 03:16, 222F
推
03/12 04:37, , 223F
03/12 04:37, 223F
推
03/12 11:05, , 224F
03/12 11:05, 224F
→
03/12 11:05, , 225F
03/12 11:05, 225F
推
03/12 12:53, , 226F
03/12 12:53, 226F
推
03/12 12:56, , 227F
03/12 12:56, 227F
推
03/12 16:50, , 228F
03/12 16:50, 228F
→
03/12 17:42, , 229F
03/12 17:42, 229F
推
03/12 18:17, , 230F
03/12 18:17, 230F
推
03/12 21:35, , 231F
03/12 21:35, 231F
以上皆已寄出
※ 編輯: noworneverev (111.253.29.169), 03/13/2017 01:35:25
推
03/13 12:50, , 232F
03/13 12:50, 232F
推
03/13 23:49, , 233F
03/13 23:49, 233F
推
03/17 23:19, , 234F
03/17 23:19, 234F
推
03/19 13:41, , 235F
03/19 13:41, 235F
推
03/20 00:21, , 236F
03/20 00:21, 236F
推
04/09 11:52, , 237F
04/09 11:52, 237F
推
04/11 14:38, , 238F
04/11 14:38, 238F
推
04/21 02:23, , 239F
04/21 02:23, 239F
推
05/13 01:52, , 240F
05/13 01:52, 240F
推
07/01 00:27, , 241F
07/01 00:27, 241F
推
09/12 13:44, , 242F
09/12 13:44, 242F
討論串 (同標題文章)
以下文章回應了本文:
完整討論串 (本文為第 1 之 2 篇):