事務所新生Excel教學手冊 - 會計
By Ethan
at 2019-08-26T01:16
at 2019-08-26T01:16
Table of Contents
下禮拜是今年大批新人進入事務所的時間,
抽空把以前寫的東西整理一下,
下載連結(rar):https://tinyurl.com/y6ootamz
內含PPT剪報檔、Excel範例檔及VBA快捷鍵增益集,
或許對即將進入事務所的新人有所幫助,
在離開前公司前,因為看到只是VLOOKUP不會的新人被很兇的教,
所以曾寄這份PPT給組上的一年級,如果當時有收到的那幾位有看到這篇,
這是會有那封信的原由.
PPT的大綱如下:
一、基本概念 & 快捷鍵
.Excel 基本概念
.Excel 內建快捷鍵
二、公式 & 小技巧
.SUMIF、SUMIFS
.SUMPRODUCT
.VLOOKUP
.INDEX + MATCH
.IF
.YEAR、MONTH、DAY
.LEFT、RIGHT、MID、LEN、SEARCH
三、樞紐分析表 & 資料剖析
四、檔案毀損修復 & 檔案整理加速
五、自訂快捷鍵
.22個VBA自訂快捷鍵
六、巨集 & VBA
.錄製巨集
.簡易VBA語法
VBA快捷鍵(xlam)的安裝及使用方法都在PPT裡面,
如果曾經用過我之前PO的那個VBA快捷鍵的檔案,也可以更新成目前這個版本,
最主要的差異是請教大神後,
把Shift + Tab 切換工作表功能再改造成近似於Alt + Tab(Windows切換視窗),
可以來回往返快速切換工作表外,連續按會切到下一張工作表。
關於主題六VBA的部分只做最粗淺的介紹,
認真教VBA要花幾十小時,不太合適也用不太到。
另外下面的這篇文章對新人來說非常實用,建議也看一下
┌─────────────────────────────────────┐
│ 文章代碼(AID): #1QbJQ3PL (Accounting) [ptt.cc] Re: [請益] 有辦法短期上手 │
│ 文章網址: https://www.ptt.cc/bbs/Accounting/M.1519728259.A.655.html │
│ 這一篇文章值 256 Ptt幣 │
└─────────────────────────────────────┘
-----------------------------
最後幾句話給正在看這篇文章的新生:
你一定會碰到很多奇怪的事、奇怪的人、奇怪的工時、奇怪的客戶,
不要太早放棄了,如果你撐過來,能對他人友善一些,
行有餘力的話充實自己,這很難,非常難,但你的能力將是你唯一的依仗。
祝各位在事務所生活順利!
--
Accoding: https://www.facebook.com/AccodingTW/
--
抽空把以前寫的東西整理一下,
下載連結(rar):https://tinyurl.com/y6ootamz
內含PPT剪報檔、Excel範例檔及VBA快捷鍵增益集,
或許對即將進入事務所的新人有所幫助,
在離開前公司前,因為看到只是VLOOKUP不會的新人被很兇的教,
所以曾寄這份PPT給組上的一年級,如果當時有收到的那幾位有看到這篇,
這是會有那封信的原由.
PPT的大綱如下:
一、基本概念 & 快捷鍵
.Excel 基本概念
.Excel 內建快捷鍵
二、公式 & 小技巧
.SUMIF、SUMIFS
.SUMPRODUCT
.VLOOKUP
.INDEX + MATCH
.IF
.YEAR、MONTH、DAY
.LEFT、RIGHT、MID、LEN、SEARCH
三、樞紐分析表 & 資料剖析
四、檔案毀損修復 & 檔案整理加速
五、自訂快捷鍵
.22個VBA自訂快捷鍵
六、巨集 & VBA
.錄製巨集
.簡易VBA語法
VBA快捷鍵(xlam)的安裝及使用方法都在PPT裡面,
如果曾經用過我之前PO的那個VBA快捷鍵的檔案,也可以更新成目前這個版本,
最主要的差異是請教大神後,
把Shift + Tab 切換工作表功能再改造成近似於Alt + Tab(Windows切換視窗),
可以來回往返快速切換工作表外,連續按會切到下一張工作表。
關於主題六VBA的部分只做最粗淺的介紹,
認真教VBA要花幾十小時,不太合適也用不太到。
另外下面的這篇文章對新人來說非常實用,建議也看一下
┌─────────────────────────────────────┐
│ 文章代碼(AID): #1QbJQ3PL (Accounting) [ptt.cc] Re: [請益] 有辦法短期上手 │
│ 文章網址: https://www.ptt.cc/bbs/Accounting/M.1519728259.A.655.html │
│ 這一篇文章值 256 Ptt幣 │
└─────────────────────────────────────┘
-----------------------------
最後幾句話給正在看這篇文章的新生:
你一定會碰到很多奇怪的事、奇怪的人、奇怪的工時、奇怪的客戶,
不要太早放棄了,如果你撐過來,能對他人友善一些,
行有餘力的話充實自己,這很難,非常難,但你的能力將是你唯一的依仗。
祝各位在事務所生活順利!
--
Accoding: https://www.facebook.com/AccodingTW/
--
Tags:
會計
All Comments
By Kama
at 2019-08-29T14:43
at 2019-08-29T14:43
By Hardy
at 2019-09-01T10:07
at 2019-09-01T10:07
By Yedda
at 2019-09-01T11:29
at 2019-09-01T11:29
By Daniel
at 2019-09-01T17:40
at 2019-09-01T17:40
By Madame
at 2019-09-04T10:58
at 2019-09-04T10:58
By Skylar Davis
at 2019-09-09T05:13
at 2019-09-09T05:13
By Sierra Rose
at 2019-09-13T08:11
at 2019-09-13T08:11
By Victoria
at 2019-09-14T20:02
at 2019-09-14T20:02
By Caitlin
at 2019-09-18T19:33
at 2019-09-18T19:33
By Barb Cronin
at 2019-09-19T22:48
at 2019-09-19T22:48
By Anonymous
at 2019-09-21T19:37
at 2019-09-21T19:37
By Audriana
at 2019-09-24T20:57
at 2019-09-24T20:57
By Noah
at 2019-09-29T16:40
at 2019-09-29T16:40
By Ethan
at 2019-10-01T11:48
at 2019-10-01T11:48
By Enid
at 2019-10-05T18:16
at 2019-10-05T18:16
By Valerie
at 2019-10-06T17:26
at 2019-10-06T17:26
By Rebecca
at 2019-10-09T18:02
at 2019-10-09T18:02
By Todd Johnson
at 2019-10-11T20:53
at 2019-10-11T20:53
By Anthony
at 2019-10-13T20:48
at 2019-10-13T20:48
By Heather
at 2019-10-17T03:08
at 2019-10-17T03:08
By Puput
at 2019-10-18T13:13
at 2019-10-18T13:13
By Zenobia
at 2019-10-22T00:15
at 2019-10-22T00:15
By Lauren
at 2019-10-26T07:21
at 2019-10-26T07:21
By Barb Cronin
at 2019-10-31T06:32
at 2019-10-31T06:32
By Doris
at 2019-11-01T17:00
at 2019-11-01T17:00
By Oliver
at 2019-11-02T20:15
at 2019-11-02T20:15
By Odelette
at 2019-11-07T15:54
at 2019-11-07T15:54
By Madame
at 2019-11-11T15:40
at 2019-11-11T15:40
By Mary
at 2019-11-13T07:07
at 2019-11-13T07:07
By Hedwig
at 2019-11-15T07:34
at 2019-11-15T07:34
By Poppy
at 2019-11-16T10:11
at 2019-11-16T10:11
By Zora
at 2019-11-18T04:17
at 2019-11-18T04:17
By Emily
at 2019-11-20T17:03
at 2019-11-20T17:03
By Leila
at 2019-11-24T07:44
at 2019-11-24T07:44
By John
at 2019-11-25T04:51
at 2019-11-25T04:51
By George
at 2019-11-28T14:48
at 2019-11-28T14:48
By Daniel
at 2019-11-29T07:12
at 2019-11-29T07:12
By Rosalind
at 2019-12-02T09:15
at 2019-12-02T09:15
By Carolina Franco
at 2019-12-02T15:08
at 2019-12-02T15:08
By Mia
at 2019-12-02T17:36
at 2019-12-02T17:36
By Liam
at 2019-12-04T10:55
at 2019-12-04T10:55
By Christine
at 2019-12-08T12:28
at 2019-12-08T12:28
By Edward Lewis
at 2019-12-13T07:02
at 2019-12-13T07:02
By Ivy
at 2019-12-15T13:37
at 2019-12-15T13:37
By Mia
at 2019-12-17T21:00
at 2019-12-17T21:00
By Brianna
at 2019-12-18T09:22
at 2019-12-18T09:22
By Thomas
at 2019-12-23T00:16
at 2019-12-23T00:16
By Quanna
at 2019-12-23T10:42
at 2019-12-23T10:42
By Liam
at 2019-12-26T16:14
at 2019-12-26T16:14
By Ophelia
at 2019-12-29T11:07
at 2019-12-29T11:07
By Oliver
at 2020-01-01T20:12
at 2020-01-01T20:12
By Rae
at 2020-01-04T12:32
at 2020-01-04T12:32
By Franklin
at 2020-01-08T22:07
at 2020-01-08T22:07
By Skylar DavisLinda
at 2020-01-10T07:00
at 2020-01-10T07:00
By Aaliyah
at 2020-01-13T22:46
at 2020-01-13T22:46
By Lydia
at 2020-01-16T11:14
at 2020-01-16T11:14
By Franklin
at 2020-01-17T02:01
at 2020-01-17T02:01
By Victoria
at 2020-01-17T10:24
at 2020-01-17T10:24
By Eartha
at 2020-01-18T15:58
at 2020-01-18T15:58
By Elvira
at 2020-01-20T00:34
at 2020-01-20T00:34
By Faithe
at 2020-01-21T04:05
at 2020-01-21T04:05
By Mary
at 2020-01-22T02:29
at 2020-01-22T02:29
By Zora
at 2020-01-23T05:24
at 2020-01-23T05:24
By Jacob
at 2020-01-24T04:38
at 2020-01-24T04:38
By Irma
at 2020-01-27T21:18
at 2020-01-27T21:18
By Emily
at 2020-02-01T13:37
at 2020-02-01T13:37
By Rachel
at 2020-02-05T16:04
at 2020-02-05T16:04
By Andy
at 2020-02-08T17:30
at 2020-02-08T17:30
By Mary
at 2020-02-12T09:53
at 2020-02-12T09:53
By Catherine
at 2020-02-16T09:54
at 2020-02-16T09:54
By Selena
at 2020-02-16T14:19
at 2020-02-16T14:19
By Tristan Cohan
at 2020-02-20T08:33
at 2020-02-20T08:33
By Steve
at 2020-02-24T01:51
at 2020-02-24T01:51
By Agatha
at 2020-02-24T18:46
at 2020-02-24T18:46
By Callum
at 2020-02-27T16:41
at 2020-02-27T16:41
By Hazel
at 2020-03-03T03:00
at 2020-03-03T03:00
By Jessica
at 2020-03-05T19:20
at 2020-03-05T19:20
By Necoo
at 2020-03-07T13:33
at 2020-03-07T13:33
By Yuri
at 2020-03-08T23:36
at 2020-03-08T23:36
By Yuri
at 2020-03-09T16:28
at 2020-03-09T16:28
By Necoo
at 2020-03-11T20:29
at 2020-03-11T20:29
By Tom
at 2020-03-15T21:32
at 2020-03-15T21:32
Related Posts
高點三勝!CPA、公職考、會研所課程Go
By Edwina
at 2019-08-25T22:09
at 2019-08-25T22:09
會計師稅法(高會)師資選擇
By Eartha
at 2019-08-25T17:01
at 2019-08-25T17:01
徴求林爵Or高薔(唐三采)財政學
By Faithe
at 2019-08-25T01:43
at 2019-08-25T01:43
已報名109金永勝審計,想合購稅務法規
By Belly
at 2019-08-24T18:22
at 2019-08-24T18:22
2019年會計師公司法證交法考題分析
By Poppy
at 2019-08-24T17:07
at 2019-08-24T17:07