事務所新生Excel教學手冊 - 會計

Ethan avatar
By Ethan
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/

--
Tags: 會計

All Comments

Kama avatar
By Kama
at 2019-08-29T14:43
推好人
Hardy avatar
By Hardy
at 2019-09-01T10:07
推好人
Yedda avatar
By Yedda
at 2019-09-01T11:29
推 收藏
Daniel avatar
By Daniel
at 2019-09-01T17:40
Madame avatar
By Madame
at 2019-09-04T10:58
Skylar Davis avatar
By Skylar Davis
at 2019-09-09T05:13
Sierra Rose avatar
By Sierra Rose
at 2019-09-13T08:11
推好人
Victoria avatar
By Victoria
at 2019-09-14T20:02
Caitlin avatar
By Caitlin
at 2019-09-18T19:33
用心推
Barb Cronin avatar
By Barb Cronin
at 2019-09-19T22:48
感謝好人
Anonymous avatar
By Anonymous
at 2019-09-21T19:37
推好心人
Audriana avatar
By Audriana
at 2019-09-24T20:57
推,謝謝
Noah avatar
By Noah
at 2019-09-29T16:40
推你好心
Ethan avatar
By Ethan
at 2019-10-01T11:48
推推
Enid avatar
By Enid
at 2019-10-05T18:16
推 感謝分享!!
Valerie avatar
By Valerie
at 2019-10-06T17:26
推,大感謝
Rebecca avatar
By Rebecca
at 2019-10-09T18:02
Todd Johnson avatar
By Todd Johnson
at 2019-10-11T20:53
Anthony avatar
By Anthony
at 2019-10-13T20:48
Heather avatar
By Heather
at 2019-10-17T03:08
推!
Puput avatar
By Puput
at 2019-10-18T13:13
推!
Zenobia avatar
By Zenobia
at 2019-10-22T00:15
實用推
Lauren avatar
By Lauren
at 2019-10-26T07:21
感動!
Barb Cronin avatar
By Barb Cronin
at 2019-10-31T06:32
Doris avatar
By Doris
at 2019-11-01T17:00
Oliver avatar
By Oliver
at 2019-11-02T20:15
Odelette avatar
By Odelette
at 2019-11-07T15:54
推一個
Madame avatar
By Madame
at 2019-11-11T15:40
推!
Mary avatar
By Mary
at 2019-11-13T07:07
Hedwig avatar
By Hedwig
at 2019-11-15T07:34
推!!!
Poppy avatar
By Poppy
at 2019-11-16T10:11
Zora avatar
By Zora
at 2019-11-18T04:17
推 好人有好報
Emily avatar
By Emily
at 2019-11-20T17:03
多希望當年進事務所可以看到這篇
推 謝謝你!
Leila avatar
By Leila
at 2019-11-24T07:44
推分享!
John avatar
By John
at 2019-11-25T04:51
Thx
George avatar
By George
at 2019-11-28T14:48
推!
Daniel avatar
By Daniel
at 2019-11-29T07:12
推! 可是那個壓縮檔好像損毀了?!
Rosalind avatar
By Rosalind
at 2019-12-02T09:15
推 感謝
Carolina Franco avatar
By Carolina Franco
at 2019-12-02T15:08
推,謝謝你
Mia avatar
By Mia
at 2019-12-02T17:36
感謝,很棒的分享
Liam avatar
By Liam
at 2019-12-04T10:55
Christine avatar
By Christine
at 2019-12-08T12:28
推 好人
Edward Lewis avatar
By Edward Lewis
at 2019-12-13T07:02
Ivy avatar
By Ivy
at 2019-12-15T13:37
檔案毀損了。
Mia avatar
By Mia
at 2019-12-17T21:00
哦不!還沒惡補就毀損了...
Brianna avatar
By Brianna
at 2019-12-18T09:22
推 樓上顯示毀損應該是壓縮程式版本過舊 更新試試
Thomas avatar
By Thomas
at 2019-12-23T00:16
推推
Quanna avatar
By Quanna
at 2019-12-23T10:42
推好心人
Liam avatar
By Liam
at 2019-12-26T16:14
謝謝分享!
Ophelia avatar
By Ophelia
at 2019-12-29T11:07
推 感謝
Oliver avatar
By Oliver
at 2020-01-01T20:12
推!!
Rae avatar
By Rae
at 2020-01-04T12:32
推好心人!
Franklin avatar
By Franklin
at 2020-01-08T22:07
Skylar DavisLinda avatar
By Skylar DavisLinda
at 2020-01-10T07:00
推!!!原po大好人
Aaliyah avatar
By Aaliyah
at 2020-01-13T22:46
推推推~~~
Lydia avatar
By Lydia
at 2020-01-16T11:14
Franklin avatar
By Franklin
at 2020-01-17T02:01
只能推了
Victoria avatar
By Victoria
at 2020-01-17T10:24
Eartha avatar
By Eartha
at 2020-01-18T15:58
好心人
Elvira avatar
By Elvira
at 2020-01-20T00:34
推新板主好心
Faithe avatar
By Faithe
at 2020-01-21T04:05
Mary avatar
By Mary
at 2020-01-22T02:29
推,大推心得
Zora avatar
By Zora
at 2020-01-23T05:24
人真好
Jacob avatar
By Jacob
at 2020-01-24T04:38
推推
Irma avatar
By Irma
at 2020-01-27T21:18
推推
Emily avatar
By Emily
at 2020-02-01T13:37
真D感動
Rachel avatar
By Rachel
at 2020-02-05T16:04
Andy avatar
By Andy
at 2020-02-08T17:30
好心人!!!
Mary avatar
By Mary
at 2020-02-12T09:53
推善心人
Catherine avatar
By Catherine
at 2020-02-16T09:54
Selena avatar
By Selena
at 2020-02-16T14:19
謝謝分享!!!
Tristan Cohan avatar
By Tristan Cohan
at 2020-02-20T08:33
推佛心版友
Steve avatar
By Steve
at 2020-02-24T01:51
Agatha avatar
By Agatha
at 2020-02-24T18:46
Callum avatar
By Callum
at 2020-02-27T16:41
有心推一個
Hazel avatar
By Hazel
at 2020-03-03T03:00
Jessica avatar
By Jessica
at 2020-03-05T19:20
推 很實用
Necoo avatar
By Necoo
at 2020-03-07T13:33
推!謝謝!!
Yuri avatar
By Yuri
at 2020-03-08T23:36
是版主大人 佛心推
Yuri avatar
By Yuri
at 2020-03-09T16:28
Necoo avatar
By Necoo
at 2020-03-11T20:29
Tom avatar
By Tom
at 2020-03-15T21:32
準備要進去 非常感恩!

高點三勝!CPA、公職考、會研所課程Go

Edwina avatar
By Edwina
at 2019-08-25T22:09
高點助攻 CPA、公職考、會研所一起來圓夢吧! https://imgur.com/GjYuzBI.jpg 精品教學,創造連續高分上榜 狂賀!!2019 會研所 台大/政大/北大/中興/中正榜首就在高點! https://imgur.com/fALoWB9.jpg [新班開課!] 最新CPA、研 ...

會計師稅法(高會)師資選擇

Eartha avatar
By Eartha
at 2019-08-25T17:01
有爬過文但還是有點不知所云 再麻煩前輩們說明一下推薦的理由 也可以分享老師上課筆記、教課方式、對該科目整體的了解等等 如整理很好,或需要自己吸收整理。 小的是非本科系亦非相關科系 學過中成。審三法上過幾堂課 明年可能要考中審三法稅法高會五科 前半年寫論文沒修課,後半年當全職考生 目前考慮要報稅法,高會 A ...

徴求林爵Or高薔(唐三采)財政學

Faithe avatar
By Faithe
at 2019-08-25T01:43
徴求林爵or高薔財政學課程 來信詢問!謝謝~ - ...

已報名109金永勝審計,想合購稅務法規

Belly avatar
By Belly
at 2019-08-24T18:22
已報名109審計金永勝審計學視訊課程 但也想報名稅務法規,希望可以合購學習稅務法規或交換筆記 - ...

2019年會計師公司法證交法考題分析

Poppy avatar
By Poppy
at 2019-08-24T17:07
剛剛看完會計師的公司法、證券交易法考題,分享一下心得: (一)選擇題難度幾乎和律師、司法官相同: 會計師考公司法、證券交易法選擇題,係由2005年開始,整體來說,早期公司法選擇題難 度偏低,多以單一法條之特殊要件作為考題,證券交易法則是考出細瑣的行政規則以增加 難度。 2019年會計師選擇題則感覺開 ...