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

[noworneverev (小朋友)]

小魯之前在某四大實習，公司電腦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
推 yololu: 推tick mark好用，出來外面偶爾做底稿也會用到
※ 編輯: noworneverev (111.253.8.48), 03/09/2017 09:11:11
→ parfait1984: [email protected]
推 ortiz3434: [email protected]
推 conk: [email protected]
推 alex19830510: [email protected]
推 april0910: [email protected]
推 popoyuiyui: [email protected]
推 april0910: 推板主用心
推 ilikefalali: [email protected]
推 geroro: [email protected]
推 welovee: [email protected]
推 ppot: [email protected]
推 Minochilly: [email protected]
推 yuna0711: [email protected]
我會再加點東西，禮拜日統一寄出
※ 編輯: noworneverev (111.253.8.48), 03/09/2017 13:20:35
推 ice5589: [email protected]
→ puding0713: [email protected]
推 chun107: [email protected]
推 fdgvfdgv: [email protected]
推 tiffu: [email protected]
推 Lwssftml: [email protected]
推 kellycyn: [email protected]
推 yiyi0919: [email protected]  謝謝！
推 TWALlen: [email protected] 謝謝
推 prter0809: [email protected]
推 sky0828: [email protected] 感謝！
推 axdong: [email protected]
推 chichong: [email protected]
推 emdiath: [email protected] 謝謝！
推 aya0203: [email protected] 謝謝
推 UTsWenTs: [email protected]
推 a6943kght: [email protected]. 感謝大大
推 bbyyy: [email protected]
推 sofar14: [email protected]  謝謝大大
推 CPQ: [email protected] 感謝大大
推 ken60816: [email protected] 感謝！！！
推 a84727: [email protected]
推 fufujack: [email protected] 謝謝～
推 navykao: [email protected]推好心,先跪了
推 jawill: [email protected] 謝謝!
推 Bhpk: [email protected]    感謝分享!!
推 sheilawu: [email protected] 謝謝！
推 scott0306: 推好心，謝謝[email protected]
推 thbetray: [email protected] 謝謝
推 pbdq: [email protected]   感謝
推 yeshchen: [email protected]
推 chen801012: [email protected] 非常感謝
推 heavener: [email protected]
推 b0937994222: [email protected] 謝謝
推 Zhenx20805: [email protected] 感恩
推 fifi1031: [email protected]
推 s8868861: [email protected] 謝謝！
推 minor2586: [email protected]
推 acy2567: [email protected] 謝謝好心人！
推 cindy0217: [email protected] 謝謝
推 keith8923: [email protected] 謝謝
推 akiraloiter: [email protected] 謝謝！
推 foreverfish: [email protected]，超懷念這個功能！！謝謝：）
推 wky0930: [email protected] 謝謝
推 gujnhj: [email protected]
推 ilihsun: [email protected]  感謝
推 jht0426: [email protected]
推 sheuyuann: [email protected] 謝謝～～～
推 cyshyu: [email protected]  謝謝
推 yuwen7995: [email protected] 謝謝
推 bruce0927: [email protected]  感謝大德
推 fish523420: [email protected] 謝謝!
推 s4656811: [email protected] 謝謝
推 annayjudy: [email protected]
推 Josunshiny: [email protected] 太感謝了!!!!
推 z00338972: [email protected] 謝謝
推 s3268ha: [email protected] 謝謝！
推 soluvtw: [email protected] 謝謝
又吃鍋貼只好繼續來codingQQ
怎麼都沒人提要什麼功能呢~
我是有點想加個笑話的功能 加班到半夜還有機會笑一下這樣
※ 編輯: noworneverev (111.253.8.48), 03/09/2017 22:55:30
推 s914234: [email protected] 謝謝！
推 anguskenneth: [email protected]  感謝~
推 luluhigh: [email protected]
推 cornslife: 推+1, [email protected]
推 unklemai: [email protected]
推 joyce79: [email protected] 謝謝：）
推 f89514179: [email protected] 謝謝～
推 violinal: [email protected] 感謝
推 sa046426: [email protected] 謝謝
推 ChrisOvO: [email protected]   感謝你！！
推 quickly: [email protected]  感謝
推 colours: [email protected] 謝謝您！
推 c443: [email protected]
推 workplayhard: [email protected]  謝謝！
推 eric1188: [email protected] 謝謝!
推 ajosidan123: [email protected] thx!!!
推 jenny60930: [email protected] 謝謝~ :)
推 judy242722: [email protected]
推 aabbabc1989: [email protected] 謝謝!
推 lucky80266: [email protected]
推 WARRENWU: [email protected]
推 Nance: [email protected]
推 ACC810919: [email protected] 感謝分享！
推 johngy: [email protected]  推好心！
推 mikemike8737: [email protected] 推好心謝謝！
推 daviedya: [email protected]    謝謝！
推 bear2man: [email protected]
推 easypasta: [email protected]       推推推！
推 blueken1025: [email protected] 謝謝
推 despairF: [email protected] 謝謝！
推 sodomylala: [email protected] 謝謝你
推 lilac52: 謝謝 [email protected]
推 LINGHY: [email protected] 感謝你
推 cowwarm: [email protected] 感謝！
推 acct0518: [email protected]
推 pacific1029: [email protected] 謝謝!
推 nicepoint: [email protected]
推 kuku702: [email protected]     謝謝
推 sunchieh: [email protected] 感謝！！！
推 hary1329: [email protected]. 謝謝！
推 accboy: [email protected]
推 hspss896329: [email protected] 謝謝！
推 sd616314: [email protected]
推 pk66295532: [email protected]
推 zulus3591: [email protected] 謝謝!!!
推 conan10978: [email protected] 感謝!
推 earl0528: [email protected] 謝謝!
推 tyui1213: [email protected]
→ noworneverev: 所以其他四大有沒有這個工具呢？ 如果我要去的那家
→ noworneverev: 沒有 我就再認真一點做XDD
推 mjt: [email protected]
推 yulien2226: [email protected] 謝謝
推 f8301018: [email protected] 推好心 謝謝！
推 holove318: [email protected]  感謝!!!
→ cqr97sam: [email protected]. 感謝！
推 joan810817: Deloitte 有
推 specialdeck: [email protected] 感謝您：)
推 forwhom: [email protected] 謝謝: )
推 chann: [email protected]  感謝
推 dg56655: [email protected] 感謝！
推 WangJieqing: [email protected] 感謝
推 ben60030: [email protected]
推 Heriof: [email protected] 感謝分享
推 lory5667: [email protected] 謝謝！！
推 lzx0416: [email protected]    感謝分享！！！
推 greencloudy: [email protected]    謝謝:)
推 hiroki310617: [email protected]  謝謝分享 K所有
推 wowwowwu123: [email protected] 麻煩了！謝謝
推 sandy3542200: [email protected].
推 ankial: [email protected]
推 auditjp: [email protected]
推 stu87192: [email protected] 謝謝大大
推 wakucha: [email protected]   感謝大大分享
推 pp850506: 難得爆
簽名的地方有人提議抓Excel內建的使用者名稱
http://imgur.com/Zio5V3Y

我一開始是抓登入Windows的使用者名稱，這次試用版兩個都會有

完成版只會留一個，看看大家比較想要哪一個再請留言
※ 編輯: noworneverev (111.253.31.127), 03/10/2017 17:22:20
推 orzxx1994: [email protected]
推 peilin1001: [email protected]
推 kent189: [email protected] 感謝
推 blaze080: [email protected]
推 harryfr: [email protected] 謝
推 bnmbnmbnm3: [email protected]
推 debbia285: [email protected]。  謝謝！！
推 lisa830303: [email protected]
推 Mattt: [email protected]
推 white0128: [email protected]      謝謝
推 cup3880: [email protected]  謝謝！
推 alissa8292: [email protected] 謝謝！
http://imgur.com/qr1f5fS
試用版就暫時這些功能，加點office image icon看起來應該專業點了
好懶得再畫圖...
不知道有沒有人有多益、托福還是GRE GMAT的單字本可以借我呢
如果加一個每日單字功能會不會被吉啊(￣□￣|||)a
※ 編輯: noworneverev (111.253.31.127), 03/10/2017 21:12:38
推 morgran: [email protected] 謝謝！
推 littleamas: [email protected] 謝謝!!
推 wowopu: [email protected] 謝謝！
推 coke123tw: [email protected]
推 wayne654852: [email protected] 謝謝您
推 pytw: [email protected] 感謝！
推 kmtsop: [email protected]
推 Ncoolo: [email protected]  感謝!
推 jane790104: [email protected]
推 ydadoog622: [email protected] 謝謝
推 NYYorz: [email protected] 感恩~*^_^*
推 ploki2726: [email protected]
→ ploki2726: 感謝~
推 kiwiandyou: [email protected] 謝謝
推 amy91669: [email protected] 謝謝！
推 MsAnn: [email protected] 謝謝!!
推 milu945: [email protected] 謝謝~~
推 b1nm336: [email protected] 謝謝～
推 wishes28: [email protected]
推 joanne60821: [email protected]
推 nooooooooon: [email protected] 謝謝您
推 scott0717: [email protected] 謝謝
推 Kevinkiss: [email protected] 謝謝
推 wangrose: [email protected]
→ wangrose: 謝謝><
推 KFSBB: [email protected]
推 Oooooopsy: yhshiao@outlook
→ Oooooopsy: com 謝謝大大!!!
outlook應該不是你信箱的域名...
推 asd5asd5asd: [email protected]  感謝大大
推 zzp: [email protected] 謝謝,加個每日英文名言也許不錯^^
終於有人提建議了
這個功能完成版一定加
推 millet703: [email protected]謝謝唷
※ 編輯: noworneverev (111.253.30.66), 03/11/2017 09:33:58
※ 編輯: noworneverev (111.253.30.66), 03/11/2017 09:36:00
推 kaoru0204: [email protected]
推 jay60119: [email protected]
推 lemonade7903: [email protected]
推 asdw555016: [email protected]    感恩
推 qaz4510: [email protected]
推 georgechen19: [email protected]感恩
推 twskyking: [email protected]  謝謝！
推 shihying1990: [email protected] 謝謝!!!
推 mia3: [email protected] 謝謝～！
推 rting0758: [email protected]
推 ths47477: [email protected] 謝謝！
推 wewe13: [email protected]
→ wewe13: [email protected]
→ wewe13: 感恩，不好意思我少打一個l
推 skyun: [email protected]
推 Alors: [email protected]
推 zxc456183: [email protected]  感謝！
推 ahong88105: [email protected] 感謝！
推 qq168: [email protected] 感恩
推 ceiro: [email protected] 謝謝！祝考試順利！
推 tytyuio: [email protected] 謝謝
推 maychao9124: [email protected]
推 scenery59832: [email protected]
推 claire00: [email protected] 謝謝!
推 luckycute: [email protected]
推 JeremyMauer: [email protected] 謝謝大大
推 wayne654852: 看一次推一次，拜託了！ [email protected]
推 kmnridq: [email protected] 謝謝
推 Yenscofield: [email protected] 感謝~
推 Chihhh: [email protected] 謝謝~
推 axilla0904: [email protected]
推 motley: [email protected]. 感謝！
推 DABO0524:  [email protected] 謝謝你
推 phoenix0714: [email protected] 謝謝~
推 hxqoiqo: [email protected]
→ hxqoiqo: 多謝
推 aa2267006: [email protected] 感謝
推 sandy3542200: [email protected]
推 au4a83su3: [email protected]
→ kkk258: [email protected] 樓主大大一生平安
推 senyuua: [email protected] 感謝大大
推 arielyuuu: [email protected]謝謝耶！
以上皆已寄出
※ 編輯: noworneverev (111.253.29.169), 03/13/2017 01:35:25
推 ChrisOvO: 已收到，感謝
推 f89514179: 收到了 謝謝～
推 j1017552: [email protected]謝謝！
推 allenhwu112: [email protected]，感謝
推 employ:  [email protected] 謝謝！
推 squall7434: [email protected] 感謝大大~
推 MASERU: [email protected]  謝謝你的分享
推 grace551199: [email protected] 謝謝
推 sunjk: [email protected] 謝謝~
推 ninaAJ: [email protected]
推 fmradio: [email protected] 感謝大大!!