使用excel管理多張信用卡心得分享 - 信用卡

By Elvira
at 2015-10-29T20:22
at 2015-10-29T20:22
Table of Contents
今天早上在前篇PO文分享本魯用execl管理信用卡的拙見,
幾位板大們說想要參考一下,
基於和excel同好們的分享和討論,
僅提供相關檔案給有興趣的板大朋友作參考,
檔案內有關於個人資料內容已多作修減,
但仍保留一些數據作為"填入哪些資料?"的參考,
若板大們要延用檔案自己使用,請自行增減內容。
檔案聯結:(點入後點"最上方"的箭頭圖案下載)
https://goo.gl/23lle2
檔案名稱:
信用卡記錄LOOKJASON分享-1.1版(檔案內容數據僅供參考,實際以官網公告為準)
104/10/31 更新1.1版說明:
1.更新Go大推文建議內容,將信用卡使用資歷自動計算格式改成易讀格式。
2.新增"道路救援"免費服務里程簡略內容。
說明:
頁籤1:記錄各張信用卡的優劣自評,額度,結帳日,繳款日,開卡,發卡,往來期間,
到期日,年費,使用策略,卡片特色/權益,保險,首刷禮,回饋率...等內容。
頁籤2:記錄信用卡各銀行每月繳費的結帳日,繳款日,金額統計等。
頁籤3:記錄信用卡開卡時間序,填入開卡日期會自動換算三個月後的日期,
可以使用字體顏色來判斷哪些卡已經滿三個月不會出現在聯徵上了。
頁籤4:記錄購物網站Y購,PCHOME,森森購物每月初搶登路的回饋內容,
用來網路購物時選擇在哪邊購買用哪張卡的參考。
這四個頁籤是目前我記錄信用卡最主要的內容,
因為是私人記錄,內容凌亂格式也沒有很美觀,
還請有興趣的excel高手大大們多加指導,感謝!
--
Tags:
信用卡
All Comments

By Wallis
at 2015-10-30T01:08
at 2015-10-30T01:08

By Oscar
at 2015-10-31T23:15
at 2015-10-31T23:15

By Kumar
at 2015-11-02T08:31
at 2015-11-02T08:31

By Ula
at 2015-11-03T07:45
at 2015-11-03T07:45

By Selena
at 2015-11-04T19:05
at 2015-11-04T19:05

By Kumar
at 2015-11-06T18:55
at 2015-11-06T18:55

By Wallis
at 2015-11-11T04:00
at 2015-11-11T04:00

By Isla
at 2015-11-12T10:45
at 2015-11-12T10:45

By Annie
at 2015-11-12T21:07
at 2015-11-12T21:07

By David
at 2015-11-16T17:05
at 2015-11-16T17:05

By Delia
at 2015-11-21T02:53
at 2015-11-21T02:53

By Thomas
at 2015-11-21T07:21
at 2015-11-21T07:21

By Yuri
at 2015-11-25T18:29
at 2015-11-25T18:29

By Rebecca
at 2015-11-29T04:33
at 2015-11-29T04:33

By Kyle
at 2015-12-01T22:45
at 2015-12-01T22:45

By Noah
at 2015-12-05T22:28
at 2015-12-05T22:28

By Elizabeth
at 2015-12-10T15:20
at 2015-12-10T15:20

By Olivia
at 2015-12-13T18:25
at 2015-12-13T18:25

By Sarah
at 2015-12-16T05:35
at 2015-12-16T05:35

By Tracy
at 2015-12-16T12:24
at 2015-12-16T12:24

By Rebecca
at 2015-12-17T13:32
at 2015-12-17T13:32

By Cara
at 2015-12-20T13:09
at 2015-12-20T13:09

By Bethany
at 2015-12-24T16:00
at 2015-12-24T16:00

By Ethan
at 2015-12-26T04:24
at 2015-12-26T04:24

By Edward Lewis
at 2015-12-26T07:58
at 2015-12-26T07:58

By Olive
at 2015-12-28T04:32
at 2015-12-28T04:32

By James
at 2015-12-30T18:50
at 2015-12-30T18:50

By Ivy
at 2016-01-02T02:25
at 2016-01-02T02:25

By Sarah
at 2016-01-03T15:34
at 2016-01-03T15:34

By Edith
at 2016-01-06T12:58
at 2016-01-06T12:58

By Sandy
at 2016-01-09T20:23
at 2016-01-09T20:23

By Hazel
at 2016-01-13T08:25
at 2016-01-13T08:25

By Ophelia
at 2016-01-17T20:49
at 2016-01-17T20:49

By Belly
at 2016-01-19T18:48
at 2016-01-19T18:48

By Connor
at 2016-01-23T10:17
at 2016-01-23T10:17

By Una
at 2016-01-26T15:42
at 2016-01-26T15:42

By Susan
at 2016-01-31T12:55
at 2016-01-31T12:55

By Cara
at 2016-02-03T13:13
at 2016-02-03T13:13

By Rae
at 2016-02-08T08:05
at 2016-02-08T08:05

By Ula
at 2016-02-12T07:29
at 2016-02-12T07:29

By Charlie
at 2016-02-16T15:40
at 2016-02-16T15:40

By Robert
at 2016-02-18T04:58
at 2016-02-18T04:58

By Caitlin
at 2016-02-20T15:20
at 2016-02-20T15:20

By Odelette
at 2016-02-24T19:51
at 2016-02-24T19:51

By Lily
at 2016-02-28T15:36
at 2016-02-28T15:36

By Edith
at 2016-03-03T23:01
at 2016-03-03T23:01

By Joe
at 2016-03-07T12:27
at 2016-03-07T12:27

By Hedy
at 2016-03-09T23:53
at 2016-03-09T23:53

By Sarah
at 2016-03-10T13:46
at 2016-03-10T13:46

By Skylar DavisLinda
at 2016-03-12T05:48
at 2016-03-12T05:48

By Jacob
at 2016-03-13T14:29
at 2016-03-13T14:29

By Hardy
at 2016-03-13T19:36
at 2016-03-13T19:36

By Heather
at 2016-03-16T23:50
at 2016-03-16T23:50

By Jacky
at 2016-03-20T19:45
at 2016-03-20T19:45

By Todd Johnson
at 2016-03-22T09:45
at 2016-03-22T09:45

By Christine
at 2016-03-24T16:12
at 2016-03-24T16:12

By Rachel
at 2016-03-26T19:36
at 2016-03-26T19:36

By Delia
at 2016-03-29T03:39
at 2016-03-29T03:39

By Ethan
at 2016-03-31T04:17
at 2016-03-31T04:17

By John
at 2016-04-01T11:08
at 2016-04-01T11:08

By Aaliyah
at 2016-04-04T01:16
at 2016-04-04T01:16

By Agatha
at 2016-04-08T02:06
at 2016-04-08T02:06

By Una
at 2016-04-10T20:22
at 2016-04-10T20:22

By Edward Lewis
at 2016-04-12T04:20
at 2016-04-12T04:20

By Selena
at 2016-04-13T19:32
at 2016-04-13T19:32

By Frederic
at 2016-04-15T23:19
at 2016-04-15T23:19

By Wallis
at 2016-04-20T00:16
at 2016-04-20T00:16
Related Posts
安泰銀行分期卡 設定問題

By Daph Bay
at 2015-10-29T17:57
at 2015-10-29T17:57
電影片優惠需要信用卡實體簽單

By Rae
at 2015-10-29T17:44
at 2015-10-29T17:44
PP 卡也可以用數位卡了

By Skylar Davis
at 2015-10-29T17:29
at 2015-10-29T17:29
凱基馬卡龍卡友請注意&JCB悠遊活動回饋

By Agatha
at 2015-10-29T17:23
at 2015-10-29T17:23
華南 櫃買贏家、icash聯名卡 核卡

By Genevieve
at 2015-10-29T16:47
at 2015-10-29T16:47