事務所新生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